Open One DB With Another

[SteveF]

Hi guys, I wonder if some of you clever folk could help me out again?

I have a stock control database that I'm very happy with. When I need to set up a new site, I just copy the database and re-name it. All the databases sit together in a single folder called 'Stocks'.

What I want to do now is write another database as a front end that will open and close databases contained in the 'Stocks' folder.

The advice I've had so far is to use hyperlinks, but I don't know how to go about it.

As ever, all help and advice appreciated.

 

[pbaldy]

Not sure you need different databases rather than a site field, but look at FollowHyperlink in VBA help.