Front end takes sooooo long to edit - Help (1 Viewer)

[G1ZmO]

We have a split database with the front end on 3 user pcs and the backend on the network

I have the only full version of access on my pc for editing the front end and the others have access runtime to use the database

Problem: Since I split the database this way it takes horrendously long to make any modifications to the front end design of queries, forms or reports. I mean when I go to save changes on a form it takes about 10 mins to do it. Likewise design modifications to a form are very slow. eg click a field to move it and theres a delay of 5 seconds before the field is selected then another 5 seconds to respond to the next mouse move. Frustrating

Can anyone shed any light on the reason for this and/or suggest a solution.

btw it doesnt seem to make a difference whether the other users have the database open or not.

Thanks

Paul

 

[Banana]

First, did you keep anything at all in your front end? It still should have forms, queries, modules but use linked tables and backend should only have tables, nothing else.

Second, how are you connecting to backend?

 

[G1ZmO]

The front end only has the queries, forms and reports and the back end only has the tables

The back end is linked to it using the link table manager

 

[Banana]

Where is the back end physcially located? How far are you to it?

 

[G1ZmO]

It on a local server connected to the same switch as the client pcs

 

[Banana]

I'm a bit puzzled because if you had said form's data entry is slow, then I'd say that you may need some tables to be local for the front-end client.

But you say it's very slow when you design the forms. Maybe the front-end isn't on your PC but actually on server?

Have you already compacted & repaired?

 

[pbaldy]

A number of things to check here:

http://www.granite.ab.ca/access/performancefaq.htm

 

[Simon_MT]

Have you got a form bound persistently into a back-end table?

Simon

 

[G1ZmO]

Simon: Yes there are a few forms which are bound to tables instead of queries.
I am updating the database slowly to get away from that type of thing.
Would that cause the problem even if I was doing design changes on a non-table form?

Thanks

 

[Oldsoftboss]

I have experienced a similar thing with my new laptop with wireless networking. When the wireless network is on (even editing stand alone Db's) and the network is idle, the thing slows to a dog,(in design mode) but turn off the wireless network, and it's fine. Work that out ???

Dave

 

[G1ZmO]

Just created a 2 new queries as a test
Both based on the same linked table
Query 1 using 5 fields - 10 seconds to save
Query 2 using all 78 fields - 4.5 mins to save

Paul

 

[RuralGuy]

You do have Name AutoCorrect turned off, right?
Failures caused by Name AutoCorrect

 

[G1ZmO]

Yes, its off.
What I've done in the meantime is taken a copy of the BE and saved it locally on my pc to the same folder as the FE and then relinked the tables to the local copy.
It's not ideal but it's a useable workaround.

I ran the Analyze performance wizard and I think it did improve things a bit but still takes ages

 

[Simon_MT]

Gizmo,

Is the update slow when the Form bound to a query?
How complex is the Query?
How many recrods are you dealing with?
How big is the Data file

When I have got up the swanny I go back to fundaments. First I see if it is my fault:

1) I create a new Database and import all the objects afresh.
2) Link all the tables
3) Run msaccess.exe /decompile against the new database
4) Repair and Compact new database
5) Get a copy of the Data and Repair and Compact

Then, if still no joy I take a copy the Query that causing the problem, save it and don't touch it. Then with the Original I take out one table at a time, this screws the query and form and hopefully you get a better understanding of whats actually go on. I know this is not a panacea but I used to haul into several of my Forms - Clients' Names from Clients via the Query. Broke my own rules and used DLookup instead and along with the Analyzer I did sort things out.

Hows the performance on your PC.

Simon

 

[RuralGuy]

Are you confident the network is running at full speed without errors? 100Mb?

 

[G1ZmO]

To answer Simons questions:

Is the update slow when the Form bound to a query? - No the data input from the form is fine
How complex is the Query? - Not sure what that means
How many recrods are you dealing with? - 23500
How big is the Data file - 18.5MB

Ruralguy: yes the network is running fine

 

[Simon_MT]

What's it like locally vis a vis all 78 fields?

Simon

 

[G1ZmO]

It took 2 seconds to save the same query locally compared to the 4.5 mins when using the BE on the server

 

[Bee]

Are your FEs copies or shortcuts to one FE on a share folder in your servers? You should not make shortcuts of the FE that point to one copy of the FE on the server which itself points at the BE. Make sure all of your FE copies are pointing at the BE directly.

 

[G1ZmO]

The FEs on the client pcs are copies not just shortcuts
Thanks