[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

Access ODBC Links to SQL Server Tables Slow From One File

I have a client with multiple Access 2002 databases which contain tables as well as ODBC links to tables in a SQL Server 2000 database on the network hosted on Windows 2000.

When opening one particular access database in design mode on Windows XP, opening the ODBC linked tables file takes a very long time.  This is for all links contained in the Access file.

Opening a different file containing ODBC linked tables pointing at the same table takes very little time.

This happens whether the tables being linked to contain 6 rows or 6,000.

I've tried deleting and recreating the ODBC links with no change in performance on the problem file.

What can I look at to resolve this file's performance issue?
0
e_vanheel
Asked:
e_vanheel
1 Solution
 
nexusnationCommented:
Have you tried compacting and repairing the front-end?

What about exporting all objects into a new database, starting fresh?
0
 
hnasrCommented:
Looks like this is a database related, since others are working fine.
1st: Try above comment

If the problem persists then
-----Create a new database
-----link the problem tables
-----If acceptable performance then
----------backup
----------Import other local tables
----------recreate relations
----------If ok then
---------------backup
---------------import queries
---------------if ok then
--------------------backup:
--------------------import other objects
--------------------if ok then
-------------------------congratulation
--------------------else
-------------------------:(
In any of the steps you may restart from a backup and reduce the number of objects imported.
0
 
e_vanheelAuthor Commented:
Thanks guys, we did end up recreating and reimporting the tables, in which case the performance was acceptable.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now