2003 makes many network accesses in design mode

[TimK01]

I am in the process of testing Access 2003.

All of our existing databases are Acces97.

I have a test workgroup set up with 3 machines, 1 server 2 cliets.

The data is on the server

If i start a new 2003 database on a client, and link to data in a 97 database on the server I can see the data.

Then I created some queries, then a report based on a query.

When I started to create the report Access ran really slowly everytime I touched a field fom the query. I found that whenever I touch a field access goes back to the server for heeps of data. To the extent on a 10mb network that you get to wait 30 seconds after touching any field, even a label.

I tried disconnecting the server and working on the local application and it went much faster but threw up errors saying the fields were not in the field list, but when i reconnected the server it recovered.

Has anyone else met this,

Is it something to do with the 97 data?

Is there a workarround

Any

Thanks

Tim

 

[TimK01]

I love answering my own questions.

It seems that if you have a table open all of the time you are working then it reduces the trafic. But if you have no table open it seems to go through some opening process for the database every time a field is referenced.

Im sure there is a good reason for this but it escapes me at the moment.

 

[TimK01]

Well that only partialy worked, so looking for more ideas please