Can't open linked tables from code database

[shenlee]

I have a code database and a data database. Something happened and all of a sudden I can't view the tables from the code database. When I double-click on a table name to open it, nothing happens. Anybody know how to resolve this? I haven't made any security changes.

 

[FoFa]

I have to ask, I am assuming they are linked tables. Have you refreshed the links? Have you opened the data DB and looked to see if there is data (don't laugh, I had a user delete all the data before than wonder where it went).

 

[shenlee]

Yes they are linked tables, I have refreshed the link and there is data in the tables.

 

[FoFa]

Do you have any applied filters or security issues that would preclude the data from displaying?

 

[shenlee]

Not that I'm aware of. When I first created the two databases, it worked fine. Then I made copies of them in a different folder. I then relinked the tables to the new location. After that it didn't work anymore.

 

[FoFa]

OK, On your front end, what happens if you run a count query on the table (no criteria)? Does it return a count, or zero?
Just wondering if this is truly an issue of not returning data, or not seeing data.
Is there any security on either DB?

 

[shenlee]

I am able to run a query on the table and see all of the records. I used the default security settings when I created the database and didn't change them. I compared the security settings on the problem databases to databases that are ok and they are the same.

 

[FoFa]

OK, When you say you double click on the linked table, and nothing happens, is it truly nothing happens, or the window opens with no rows returned?

 

[shenlee]

The first time I double-clicked and encountered a problem, I got an error message saying I could not open the sheet in datasheet mode. On subsequent attempts to open any table, Access would pause briefly and then just do nothing, no message, and no window opens.

 

[FoFa]

Humm, I am thinking it is some kind of Sharing problem. If you create a new DB, and link the tables, what happens. Are there any users using the backend?

 

[shenlee]

This is a single user installation. I'm in development mode right now so I'm the only one using this application. I think that something is screwed up in Access, like a switch has been set and I can't reset it. When I create a new database and link to new tables, everything is OK. It just seems to happen when I've been creating backup copies of my databases before implementing changes.

 

[FoFa]

At this point, I would suggest you create a new DB, Import all your objects and see if that fixes the issue. Some times that seems to be the only way out.

 

[shenlee]

I think you are right. The only way to fix this is to start fresh. Thanks for all of your input. I appreciate it greatly.