Question A2003 takes long time to save forms

[bulrush]

I'm developing an A2003 application and making changes to forms. Whenever I save a form, it takes 5-10 seconds to save it. However, this doesn't happen with my other applications, developed on the same machine, using the same version of Access.

- I have Win XP.
- I have at least 1GB of ram.
- The MDB file is on a C: drive, which uses only 25% of the space. So at least 75% of C: is free space.
- I am linked to some other tables in another application, which resides on a network, through ODBC drivers. But no forms use these tables, and why would these tables be accessed while saving a form in design mode?
- This doesn't happen to my other Access apps. Some of which also use ODBC linked tables.
- My MDB file is in My Documents and is only 1700kb in size.
- I did do Compact and Repair several times this week, but that didn't speed up saving forms.

Any ideas how to speed up saving forms?

Thanks.

 

[Rabbie]

Since you say other Access applications are working OK on your C drive the issue would seem to be with that particular DB. I would suggest opening a new DB and importing your existing objects to it.

 

[bulrush]

Thanks, but I am unable to create a new .MDB file. My file is an Access 2000 format file, and the Access exe is version 2003. But I installed Outlook 2010, Word 2010, and Excel 2010, which wiped out my ability to create a new blank MDB file. When I right click in my File Manager, click New, I only get a .ACCDB file.

Any suggestions? A2010 will increase my development time by a lot, because the screen layout is so different, and some options I need are not even available. So, upgrading to A2010 is not an option.

 

[Galaxiom]

Sounds odd that you can't make an mdb when you have Access 2003 installed. That is surely intolerable. What does the File menu show?

How about a work around? Copy one of your other mdbs, delete everything and compact it. Then import the objects from the problem database.

 

[bulrush]

Many things about Microsoft products are intolerable. But that is a whole different thread.

I reinstalled A2003 and now I see on my right click menu 2 Access items:
- "Microsoft Access Database" creates a .ACCDB file, which I do not want.
- "Microsoft Access Application" creates the MDB file which I want.

EDIT: I created a new, clean MDB file by using right-click, New. Imported all items to the new MDB file, linked in my tables from the network, and changed a form called ProjectEdit. When I saved the form, it still takes 5 seconds or so.

The linked tables should have nothing to do with saving a form, unless A2003 now refreshes links (or pings them at least) whenever an object is saved. Note: this form does not use any of the linked tables as a record source. It uses 2 local tables, one for the main form, one for the sub form.

EDIT2: Ok I lied. A combo box on form ProjectEdit is connected to a linked table on the network (ODBC data source).

Clarification: This form ProjectEdit has 3 combo boxes whose recordsource links to linked tables. This form ProjectEdit takes a long time to save, no other forms in this MDB have this problem. That is weird.