Search results for query: *

I want the information to help me decide how to prioritize the offloading of data (which could be just to split the databases or to upgrade some tables to SQL Server) from the Access databases that I "inherited". The larger one is 1.6 GB in size. Each has many tables. Yes, I know I can get a...

Is there an easy way to determine the number of data pages (4 KB each) that a Microsoft Access table is stored in? I have Access 2007, but the tables that I want to examine are in 2003 databases (.mdb files). A programming solution is desired, but a manual solution is acceptable. I am not...

Why the question? Well, I have at least one .mdb file that is approaching the 2 GB limit, and would like to use the table sizes to help decide how to split the database. (Yes, I would like to move the data to SQL Server, but there are other priorities.)

Duane, I'm asking about data pages, as in the chunks (4 KB in size, starting with Jet 4.0) by which Access manages data in the .mdb file. See, e.g., http://support.microsoft.com/kb/275561/en

Is there a simple way to determine the number of data pages that a Microsoft Access table is using? I have Access 2007, but the tables that I want to examine are in 2003 databases (I think). A programming solution is desired, but a manual solution is acceptable. I am not interested in...

FYI, that appears to work for VSS Explorer, but not for the Visual Studio .NET (2002) IDE.

Is that solution sufficiently accurate for you? Note that DATEDIFF differences can be larger than you might expect: PRINT DATEDIFF(mm, '1/31/2005', '2/1/2005') So the "18-month old" child selected by the filter previously posted could be just 17 months and 1 day old.

NCH, per your suggestion I tried an INSTEAD OF trigger. But I get the same results as with the AFTER trigger - the RAISERROR causes an automatic rollback of the implicit transaction, so no log entry is written to the table. I could still write the log record to a file, as I posted earlier ...

Yes, I am using "inserted" and "deleted" (in fact I need values from both pseudo-tables for my logic). But I have the apparently conflicting desires to: 1) rollback the changes, to protect the data; 2) raise an error, to notify the client software of the condition; and 3) log the fact that the...

I need a set of SQL Server 2000 triggers (for multiple tables) that will - dependent on the data values - prevent UPDATEs/DELETEs to the row(s) "in perpetuity". (OK, there are some exceptions, but I can handle those.) I have chosen to use the default type of trigger rather than an INSTEAD OF...

Hello all, The shop I'm in is using VB6, but is starting to use VB.NET. What design practices - specific to .NET - do you recommend to ensure good maintainability? Performance? Security? And what coding practices would you recommend - specific to VB.NET? (I see that someone recommends...

That error message can also occur if the COM server does not expose an Automation interface, which is used for late binding. (Scripted languages use late binding. VB can use either early binding, as in the example you were given, or late binding.) Ask the support people for Northern if their...

(I can't tell what the main purpose of your program is, but I don't need to know. I'll refer to it as "Task X".) If you want to use a Timer control with some "quick and dirty"/simplistic/untested code... 1) Put a Timer control on a form that will be loaded all the time your program is running...

Minimalist? I seem to recall coding it something like this... Function NumberOfDimensions(ivntArray As Variant) As Integer Dim dintDimension As Integer Dim dlngUpperBound As Long On Error Resume Next For dintDimension = 1 To 65 dlngUpperBound = UBound(ivntArray...

You write that you want to "clear" the Variant. What exactly does this mean to you? To many VB programmers, it would mean to assign an Empty value to it, as in HolidayList = Empty. (Review the VB Help on the VarType function to see what a Variant can contain, and click the See Also link to...

Uhhh... What's a synonym? (And which database management system is this?) Your usage of the term suggests that anyone can access a stored proc with a PUBLIC synonym, but that only certain, DBA-specified database users can access a stored proc with a LOCAL synonym. Do I infer correctly? VB...

Or, if you need to retain any leading spaces that may appear in those values, use the function that trims only spaces on the right: txtTest.Text = RTrim$(txtTest.Text)

The posts so far cover the movement of data FROM a matrix to a row, but there's more to the story. Matthew Curland's book Advanced Visual Basic 6 talks about the hidden flags that are associated with arrays (i.e., a VB array is more than a contiguous block of memory). My copy is at the office...

A co-worker who is using VB.NET has not been successful in executing VBC because the LIBPATH argument value that he needs to use is a directory name that contains spaces. He has tried quoting the directory name, but gets a compiler error. (Samples are below.) There is the possible solution of...

Using SQL Server 2000... I would like to compare the contents of user-defined stored procedures in two databases, outputting their names and colid values. The procedures have the same names in the databases. So I tried the obvious coding of: SELECT O1.name, C1.colid FROM...