Error 3356 You attempted to open a database that is already opened exclusively

Hello.
I recently moved an order processing database from one server to another. This database is the source for linked tables in other databases. Everything works for several hours, but eventually this error occurs when accessing data on the linked tables:
3356 Autoload You attempted to open a database that is already opened exclusively by user Admin on machine FS04.  Try again when the database is available.
I have relinked all tables and refreshed all links. This was never an issue on the old server, and no database security changes were made.
chantalcookwareAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try investigating  permissions in the new server/folder location
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jefftwilleyCommented:
sounds like "Admin" has the database open with something in design view. This puts the backend database in an exclusive state. Is this possibly the case?
0
chantalcookwareAuthor Commented:
Everything works for several hours and then seems to fail. This is why I don't suspect permissions problem. Permissions on the folder are identical to the previous server setup.
Nothing is open in design view. The source database is open to a form which checks for data in a folder and processes it accordingly. The other apps read and write to various tables within the source db. I linked these tables using full unc to the new server.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.