Snail DB

[matt]

When I change from or to design mode, save something or even just open
anything in MS A2K (including reports, querys, tables, forms) it
queries the network which takes 30secs to about 4mins to respond.
Other database I have are ok. This one, like the others are split in
two. The back end on the server.

Any ideas welcomed!

TIA Matt

 

[Arvin Meyer]

When I change from or to design mode, save something or even just open
anything in MS A2K (including reports, querys, tables, forms) it
queries the network which takes 30secs to about 4mins to respond.
Other database I have are ok. This one, like the others are split in
two. The back end on the server.

Have a look at Tony Toews' performance FAQ:

http://www.granite.ab.ca/access/performancefaq.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[matt]

Thank alot, it works a treat. I had a problem with the tables set to
[Auto]. I would never have found that. Thanks again, Mt