DB Opening to slowly

[sondriven]

I have created a Purchase Order Program with Access 2K and everything is going well until today.

I updated a query for a combo box. Its not a complex one.

But now when I go to open the program it takes about a minute to open versus about 5 seconds.


Any input on this would be appreciated. Thanks.

John

 

[FloBob]

If the tables are linked access has this issue. Let me know... there are ways around the speed but I need to know whether or not the tables are located on a network or on your local machine.

 

[sondriven]

Yes the tables are linked.

5 computers have a copy of the FE and the BE is on the Server.

 

[FloBob]

What we do is create a make table on the FE so the users can create that before the combo box form is loaded. Then the speed issue only happens once and can be loaded into the background. I have been looking for otherways around this but have not found anything that works great. The only resolution is to set it up on a SQL server, which speed greatly increases at that point for the most part. Let me know.

 

[sondriven]

At the time there is only me and one other person in the Database. Its rather low traffic.

At first the form didnt load as fast, even after restarting the computer to make sure it wasnt my system. I tried about 3 times and it loaded really slow.

But now the last couple of tries have been okay. Is this a traffic issue, and if so how much is a lot?

Im sorry I dont think I was clear about this but everything works great up after the Purchase Order Form loads. The query I have a report built on is fast. But its that first start up.

But this has only started to happen today after the query update.


If its the query's fault, how do I post it?

Thanks

 

[Alexandre]

Edit the query, switch to SQL view (menu view > SQL), copy the SQL statement and paste it here

 

[sondriven]

Here it is:

SELECT [Vender Sort Query].[Vendor Name], [Vender Sort Query].[Phone Number], [Vender Sort Query].Fax, [Vendor Name].Address, [Vendor Name].City, [Vendor Name].State, [Vendor Name].[Zip Code]
FROM [Vender Sort Query] INNER JOIN [Vendor Name] ON [Vender Sort Query].[Vendor Name] = [Vendor Name].[Vendor Name]
ORDER BY [Vender Sort Query].[Vendor Name];


Thanks

 

[Fizzio]

Just a quick tip.
If you have Track Autocorrect enabled (Tools/Options/General) If you make changes to objects, it can really slow down forms.
Unchecking this will give you a speed boost but you will lose the autocorrect facility (not a bad thing in my book as it ensures that you are thorough with your code editing etc )

May not be too useful in your case though.