Access 2007/2010 question

[DBinPhilly]

Sometimes when making just a minor change in an Access 2007 or 2010 program, the system will freeze for minutes at a time - up to 5 to 10 minutes with the "Microsoft Access Not Responding" message

What could be causing this problem? My FE database in this case is about 40Mb. I sometimes end up bailing and restarting the program. This can happen when I'm merely looking at a Query and trying to save a minor change.

Ideas or suggestions are gratefully appreciated.

 

[Galaxiom]

Just a guess. In some circumstances Access looks for the printer and there will be a substantial delay if that printer is not available.

I thought it was mainly an issue with reports though.

 

[reezebeez]

Hi, only new to access here, however I was having this problem too. I found that is occurred mainly when I had the table open and the form (making changes on the form), so now I make sure I have only the one form open that I'm working on and ... so far so good. Hope this helps.

 

[DBinPhilly]

someone sent me the following suggestion and right now it is working like a champ.
I have yet to implement it across a full network but will do so later today so we'll see if it is as successful as it seems to be:

http://www.fmsinc.com/MicrosoftAccess/Performance/LinkedDatabase.html

go to the section labeled: The DAO OpenDatabase Method

it explains how to open each linked database when you first open your program so that they remain open until you close your program. This apparently saves a lot of time loading forms, queries, and reports based upon linked tables.

So far with me it is acting as advertised.

 

[DBinPhilly]

Hold On! This method seems to be causing me a problem with updating certain files.

I think it is not updating transitory local files. I'm referring to tables that are created 'on the run', updated and then the data is passed to a permanent table in a different format on a networked back end.

Is anyone familiar with this one?

Should I drop "Make Table" queries in favor of "Append Queries" adding the records to a linked work table database which I clean out before each use?
Do I have to make all updatable files linked?