Force to open link table

[marvin67]

Hi there,

I developed a job system database for our company and we've been using this for a while. I split the database BE and FE and copy FE on every workstation. My problem right now is the database is starting to run slow. I have read some article saying this

"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 from creating and deleting the associated .ldb file."

I am not an expert in coding, I would really appreciate someone can guide me on how to do this.

Many thanks

 

[RuralGuy]

I use a hidden form for housekeeping and maintenance shutdowns and simple bind the form to a System table in the BackEnd.