Search results for query: *

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...

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...

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...

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...

A co-worker has created a stored procedure (in MS SQL Server) that executes fine when called from the Query Analyzer. But when he uses VB and the ADO Command object to execute the procedure (i.e., objCmd.Execute after assigning the connection, parameter, etc.), the result is a Recordset object...

Hi, I'm using the ADO OpenSchema method to retrieve information about the SQL Server database. I successfully get table names, column names and data types, primary keys... But I can't seem to get the Description for the columns. The recordset contains a Field object named DESCRIPTION, but...