Accessing SQL Table through Access

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I moved all of the data tables in my Access database to SQL. I am still
using Access as my front end. While this works great for user input, I have
recently experienced a problem opening the linked tables.

Up until Monday of this week, it took about 10 - 20 seconds to open a SQL
linked table in Access (to modify data directly in the table). Ever since
Monday, it takes about 4 minutes to open a table, and while it is opening, it
hogs all of my system resources. Nothing has changed, to my knowledge to
create this bottle neck. Any insight?
 
Hi Jody,

Direct maniuplation of data in a table is discouraged. Be that as it
may, if there are a lot of records and there is sorting applied to the table,
that could cause the delay. Do a backup first just in case of problems.
Then open up the table, clear out all filters and sorting and do a save.
Then do a compact and repair just for good measure.

Hopefully that will help,

Clifford Bass
 
100% Thank you! The compact and repair seems to have froze up now, but I
will work through that.
 
Hi Jody,

You are welcome! Frozen compact and repair = confirmation that a
just-in-case-of-problems backup was wise.

Clifford Bass
 
Back
Top