1 table in 2 files

[PedRocK]

Hi, [access 2000 or 2003]

Is there a way i can use one table shared & updated in 2 access files? if yes what are the conditions please

thank you

 

[neileg]

You can link from an Access application to an external file. So you could hold your common table in of of your two applications and link the second one to that, or you could set up a third mdb to hold your file and link the two applications to that. You can add, edit and delete data in a linked file, but you can't change the table structure or the datatypes.