database speed issue

[rkrause]

I currently have a access 2000 database thats on a server and have two users access it at the same time. There is a set of 4 import buttons, where they import some collections information in from an accounting system. Behind each button theres approx. 8-10 queries and some other code. Does anyone have any tips on how to make that run smoother, sometimes the buttons are taking an hour to complete.

thanks

 

[MSAccessRookie]

I currently have a access 2000 database thats on a server and have two users access it at the same time. There is a set of 4 import buttons, where they import some collections information in from an accounting system. Behind each button theres approx. 8-10 queries and some other code. Does anyone have any tips on how to make that run smoother, sometimes the buttons are taking an hour to complete.

thanks

The first thing I can say is that without seeing the SQL Queries, Macro Definitions, or VB Code that is used, all we can do is guess. If you can providfe samples, we might be able to give you better advice. In addition, the structure of the data can play a part in speed of access, so table layouts would also be useful.