use OpenRecordSet method to open linked table??

[leeroi]

Hi,

I am looking for ways to speed up a networked database. One suggestion that I have read is to create a blank table in the back-end database, link it to the front end, and then use the OpenRecordSet method to open the linked table. According to Microsoft, doing this keeps MS Jet from repeatedly opening and closing the linked database and creating/deleting the .ldb file.

OK, I've gotten the blank table created and linked. What do I do now? I have minimal experience with code and don't know how to proceed.

Any help would be appreciated!

Lee

 

[willir]

Lee

What this "solution" is attempts to do is to maintain an open link to the database. This is done by always accessing a record on the backend. As I understand it, with ADO linking takes time, and this is an important method for addressing this performance issue.

The trick is to have your main menu, albeit, not normally bound to a table or record, to access a dummy table or record of inconsequence. The assumption is that the main menu is never closed. You can also open a form, hide it and use the same approach. Here, since the end user can not see the form, they wont close it, thus preserving your connection.