"OpenRecordset method" and linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After succesfully splitting one of our databases, I'm trying to speed up its <painfully> slow performance. I've done everything listed under "Obtain optimal performance with linked tables..." in the Access 2000 Help files, except the first one: Creating an empty table in the back end, linking it to the front end, then using the OpenRecordset method to open it. I've modified some VBA expressions in the past when the needed correction was obvious, but have never created any VBA code. The more I delve into the VB Editor and its help files to try to learn how to use the OpenRecordset method, the more entangled I get. Is there some easy way to do this?
 
FS volunteer said:
After succesfully splitting one of our databases, I'm trying to speed
up its <painfully> slow performance. I've done everything listed
under "Obtain optimal performance with linked tables..." in the
Access 2000 Help files, except the first one: Creating an empty table
in the back end, linking it to the front end, then using the
OpenRecordset method to open it. I've modified some VBA expressions
in the past when the needed correction was obvious, but have never
created any VBA code. The more I delve into the VB Editor and its
help files to try to learn how to use the OpenRecordset method, the
more entangled I get. Is there some easy way to do this?
Click to expand...

You might try this: instead of fooling around with opening your own
recordset, create simple form and bind it to the linked table you
created for the purpose. Open that form hidden -- DoCmd.OpenForm
"YourFormName", WindowMode:=acHidden -- when your database opens, and
leave it open.

I think that ought to accomplish the same thing.
 
Back
Top