Hey, I have two Access Databases 2

[SpankYou]

Hey,

I have two Access Databases, one contains a staff table, with a field called "staffid", the other database contains an "Import" table, for each import a "staffid" must now be associated. Any Idea on how to link these two databases? I'm not overly keen on rewritting the whole lot

Thanks

Sam

 

[simco]

Just import/link the staff table into the second Access database.

 

[Rilez]

SpankYou - in case you need clarification of what simco said, the following is the link method... go to tools - relationships and add the link between the two tables on that. Save it and now any sql you create from Access will contain the link. you could then use that SQL for any ASP etc work your doing. hth

 

[SpankYou]

Thank you for both of your help,

Sorry it is a bit late, but carried away with the project, anyway thanks once again,

Cheers

Sam