Excel data connection to Access

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

We have multiple users with a back end database. All users have XP2003
except one just started using Office 2007. 2007 user made a worksheet with
query connections to the back end database. When he is in this spreadsheet
it locks the database. I have never had any problem having queries open with
2003 locking the database. Any answers?
 
This is a shot in the dark, but does the Excel user have the same read/write
privileges to the directory the back-end is located in. If not, your Excel
user might have a lock file locally on his drive, preventing other users from
getting to the database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Opening excel 2010 spreadsheet from Access 4
Excel Template 13
External Data Refresh Issues 0
Using MS Query with Excel and Access 2007 3
Data Export from Access to Excel 2
2007 Pivot Tbl to Access Conversion Issues 6
Using SQL>Request with Excel 2003 1

Back
Top