Access database table linked to Excel file question

25 pts.
Tags:
Access Database
Excel worksheets
Microsoft Access
Microsoft Access 2007
Microsoft Excel
Can multiple instances of the same access database be open when linked to same excel file?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, its possible.
Provided its saved on common folder/network folder Also, you will have to use ADO for updation/insertion.

Regards,
Sarfaraz Ahmed
<a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a>

How is it possible? In order to achieve this the Excel file would have to open in read only mode correct? The problem is Access open any linked Excel file in “executable” mode.

Thanks for your help.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    Think you mean open the access db in read only mode. The excell mode is totally irrelevant, unless you try to write to the data back to the access db, In which case it could case errors on the excell sheet. you can't update an access record from one spreadsheet if another is using the data you are trying to update. leads to ciclic errors, read write errors etc. Which is why the access db should be opened in read only mode. You never actually mentioned what the spreadsheet(s) will be doing with the data it retrieved from the db. Why so many sheets anyway? Dave
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following