Viewing archived Data from FE db

[jedel]

I have an Access 97 FE / BE database that will have a archiving system to another BE database. (I just like to keep these records safe and away from the main play)

Is there a way that I can view these records using the same FE database. ie maybe change the datasource for the viewing purposes?

I'm only starting in the archiving area and I see this as a bit of a hassle if I want to easily access these records. Feel free to post some example code

Thanks in advance

Jedel

 

[KenReay]

Hi

No need for code, you can just link to the tables in the Archive.mdb, there is nothing to say all linked tables must be in same MDB

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK