Sep 17 2008, 01:32 PM
I have copied all database objects into a new database multiple times, and have compacted and repaired and I still have a problem. The problem is that whenever I go into design mode in access 2007, the database moves EXTEREMELY slow, crashing a lot of times. This never happened during the initial design phase. But now, that the database has been split and is in production, It moves slow. I cant hardly work on the front end copy of the database because it moves too slow, it is corrupted somehow. Anyone have any ideas?
Sep 17 2008, 01:39 PM
Make a copy of your backend file and Save it on your local hard drive. Link your tables in your front-end to this local backend.
Remember to re-link to the 'live' backend on your server before distributing a new version!
Sep 17 2008, 02:33 PM
Works great michael, thanks
Sep 17 2008, 02:40 PM
Welcome! Good luck with your project