Database locking when linking

[StryderLlama]

I am having an issue with a particular database. I try to link to it in several different ways but it causes whatever app I am in to lock during the linking phase.

Example: I tried importing tables from this database into SQL Server. During the import when SQL Server brings the list up of tables available in the Access database it locks SQL Server Import wizard.

Another example: I try to import a query from the same Access Database into Excel using Import Data in Excel. When I try to use this Access database it locks Excel up.

Now no other database is doing this to either program, only this particular database. Something must be off in this database and I was hoping someone would know what to do. i can't seem to find this issue on the web.

 

[ghudson]

Try importing all of the db objects from the bad database into a new database.

 

[boblarson]

Just checking - how long have you waited for it to finish linking? I've got one app that takes upwards of 3 minutes to link due to our network.

 

[StryderLlama]

It was actually due to a corrupt query. This query was not being used so I deleted it. Once I did that I was able to start linking to it again.

I tried creating a copy of the database and then I started deleting one table at a time. I found deleting onc specific table allowed me to link to the database. Well, go figure that was the table I needed to link to.

I looked at the object dependencies and found that one query would lock the database when I tried to run it. That query literally had about 50 joins to other tables. Instead of investigating each single join, I didn't see where that query was used any longer and so I deleted it. I have a back up of that query if I ever need to use it again and I will have to investigate deeper if that happens but for now, I am good to go.

Thank you all