RomanTAtBayer said:
Has anyone experienced performance degradation when splitting an MS Access
2007 database into back end and front end? Seems like the pre-split
application worked fine but when you split it, queries take 10 times longer
to process.
Yes, this can be typical behavior.
The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
If the problem is for everyone when starting up the MDB then it likely
needs a decompile.
For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
Also the free Auto FE Updater utility can help keep all the copies of
the FE MDB/ACCDEs on the client PCs up to date. For more info on the
free Auto FE Updater utility see
http://www.autofeupdater.com to keep
the FE on each PC up to date.
Tony
