1 Excel spreadsheet linked to 3 databases

[crimestarter.jim]

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

[jonceramic]

On Feb 5, 1:05 pm, [e-mail] 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.

[Ron2006]

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