Best Choice?

[Secret Squirrel]

Can someone please advise…

I have 3 x Access97 databases:
- DB#1 is the main front-end DB
- DB#2 is the main back-end DB
- DB#3 is a separate front-end DB

DB#3 only occasionally needs to access a single table in the shared DB#2.
At present this is achieved via a linked table.

But I was wondering if I should be using -
Linked table
or OpenDatabase (via either Workspace of DBEngine)
or TransferDatabase [acLink]

Which is the most efficient method out of these?
Or would anyone recommend another mechanism?

 

[Secret Squirrel]

But I was wondering if I should be using -
Linked table
or OpenDatabase (via either Workspace of DBEngine)
or TransferDatabase [acLink]

Can't think of any reason to use anything but a normal linked table. What
doubts do you have?

Tim F

I was just interested in other's views.
I've always Linked, but I wanted to know if anyone else had better suggestions.
Thanks.