By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,173 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

1 Excel spreadsheet linked to 3 databases

P: n/a
Good afternoon,

I am not the most informative when it comes to Microsoft Access. I
have a user that is using Access 2003 and has 1 excel spreadsheet
linked to 3 different databases. They are only able to have one of
the databases open at a time. When someone is using one of the
databases associated to the spreadsheet and another user tries to
access one of the other linked databases then they just get an error
stating that the file is already opened. It won't let them view the
database read only or anything.

Does anyone know if there is a way around this to where more than one
user can be accessing the other 2 databases associated with this
spreadsheet even when one of the other linked databases is open?

Thanks,
Josh

Feb 5 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 5, 1:05 pm, crimestarter....@gmail.com wrote:
Good afternoon,

I am not the most informative when it comes to Microsoft Access. I
have a user that is using Access 2003 and has 1 excel spreadsheet
linked to 3 different databases. They are only able to have one of
the databases open at a time. When someone is using one of the
databases associated to the spreadsheet and another user tries to
access one of the other linked databases then they just get an error
stating that the file is already opened. It won't let them view the
database read only or anything.

Does anyone know if there is a way around this to where more than one
user can be accessing the other 2 databases associated with this
spreadsheet even when one of the other linked databases is open?

Thanks,
Josh
You'll have to show the code of how they are using Excel to open the
Access Databases.

Feb 6 '07 #2

P: n/a

Are you sure that it is not the spreadsheet that you are getting the
error message on.

Typically, spreadsheets will only allow 1 user in at a time and that
is the message you get for the spreadsheet.

Ron

Feb 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.