Search results for query: *

Our Access database is getting to be huge (300 megs). Have tried to use Sybase to hold tables, but peformance was poor. Has anyone tried MS Sequel Server or any other MS product that would work? Thanks, Jeff

If I run the following code, the values test, test1,1 and 2 are inserted as a record into the entityPos table: dbs.Execute " INSERT INTO entityPos(subModelNm,entityDisplayNm, horizontalPos,verticalPos) VALUES ('test', 'test1',1,2);" If I change the values I am inserting into...

I have a query that calls a function to populate a column. The function returns a string with embedded vbLf and vbCr (linefeeds and carriage returns). The resulting string has the "square box" character that signifies a non-recognized character. Question - can I use characters other...

I need to loop through a series of columns in Excel and bring back the number of records in each column. I have tried using the following code - Range("A6").CurrentRegion.Rows.Count The problem is that this will bring back the row count for the column that has the most rows in the...

I converted an Access 97 database to Access 2000. My DA0 works find in this converted database. However, when I export the DA0 to a non-converted database, it does not run!!! My Access exe is the same for both databases, and I have references set to DA0 3.6. Any help would be greatly...