Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

My Access app slowed down

Status
Not open for further replies.

MaxZak

Programmer
Oct 5, 2001
116
IT
I've had a problem with an application written in Access 2k that has 1 hundred of linked table, about 1 hundred of Forms, 20 Reports and 30 Queries.

I've added some forms to that app, and I've noticed that it slowed down very mutch. As I've modified it with Access XP, I'm asking if the new file isn't optimized for Access 2K and, consequentely, slowly.
Another limit could be the file size: is there a size of an mdb file over witch the file isn't handled in a "fast way"?
My mdb is about 12MB (only forms, reports, ecc... tables are linked)

Tanks, and sorry for my poor english!!!
 
Ok, I've found it:
I've just created a new mdb app with Access 2000, imported all Forms, Reports, etc. and it works faster (2-3 times)
It's courious that the new Access 2000 app (compacted) isn't the same size of the Access XP app (compacted)... the 2 files aren't equal!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top