Question Import External Data Fails if Access Database Open

Bill Bisco

Custom User Title
Local time
Today, 07:31
Joined
Mar 27, 2009
Messages
92
Dear all,

When another user on the intranet has my Access Database Open, I am unable to import data from my Access Database onto my Excel Spreadsheet.

Is there a way to configure Access such that I can import the external data into excel and have another user editing the database?

Any help is appreciated,
Bill

Edit: I also posted this thread here
 
You may want to think about splitting the database to a front-end and back-end structure. WHere the datatables are housed separately from the forms and queries, that way you can make the modifications needed without having to open the database exclusively.
 
Actually I have already split the databases and I'm still having this issue. Any advice is greatly appreciated!
 
Thank you for your help. I believed I solved the problem. The lesson is to never ever open up the backend and do stuff unless no one else is accessing the database.
 

Users who are viewing this thread

Back
Top Bottom