Re: Access 2000 unworkably slow

[Steve Raden]

I'm working on this problem as well. I'm also working on finding an Access converter that is free, open source and allows you to log the sql script. If you try anyone of the suggestions below , maybe post back to this same thread as to whether they helped

I read a few msdn.microsoft.com articles. It seems in addition to strategic stuff, you can provide several alterations to your schema to improve matters, this involves adding a table called MysConf on backend

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowMsysconfTableAttachedSqlDatabasesS.asp

and also timestamps to each table (which I saw should be called verion but I can't find the reference.

Also, VB code can force another optimization with the connection.

"You can greatly enhance performance when opening the main database and opening tables and forms by forcing the linked database to remain open. To do this, create an empty table in the linked database, and link the table in the main database. Then use the OpenRecordset method to open the linked table. This prevents the Microsoft Jet database engine from repeatedly opening and closing the linked database and creating and deleting the associated .ldb file."


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowMsysconfTableAttachedSqlDatabasesS.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;128808

http://support.microsoft.com/kb/q128808/