Accessing SQL Table through Access

[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?

 

[Clifford Bass]

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

 

[Jody]

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

 

[Clifford Bass]

Hi Jody,

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

Clifford Bass