Check for errors in your Visual Basic Code.
If none, then compact and repair the database.
If that dosen't work.. reimport your database into a blank database.
Create a new blank DB. Then import the tables, queries, forms, macros, reports, and modules.
If that still dosen't work. Maybe it is tooo large. Have you seperated the DB and the front end? Tables are in one DB. Everything else in a different. The Tables are the Back End. Everything else becomes the Front End. More efficient if there are multiple users.
Also, be careful of which version of Access you are using and which MDE you are trying to create.
You mentioned Access 2005.
Are you referring to Access 2003?
|