Best Choice?

  • Thread starter Thread starter Secret Squirrel
  • Start date Start date
S

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?
 
But I was wondering if I should be using -
Linked table
or OpenDatabase (via either Workspace of DBEngine)
or TransferDatabase [acLink]
Click to expand...

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

Tim F
Click to expand...

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