Link Excel Tables in Access

S

slumert

I have linked Excel pages into Access. I need to create another Access
database that's linked to the Excel pages in my other database. When I create
a knew database and attempt to link tables to my other database that contains
the linked Excel tables, I cannot see them. I need to be able to this so that
more than one user can access the database on the same time.
 
J

John Nurick

You can't link from the second .mdb file to linked tables in the first
..mdb file. Instead, have the second .mdb file link directly to the Excel
sheets.
 
S

slumert

Thanks John. But won't that give me the same problem with only having one
user access the original db? i'd like to have mutiple users access the same
table.
 
J

John Nurick

Yes, there are problems with providing shared simultaneous access to
data in a worksheet. Given all the other disadvantages of Excel as a
database management system, I've never tried to master them.
 
Top