Linked Table VS Import Table
Quote:
> I just got a set of databases and one of them contain many Linked
>tables. I think it is not convenient so I want to combile all of them into
>only one database. Therefore I delete Linked table and then import a same
>table from the original source. It should work but unfortunately it didn't
>work. It said "The link to database is fail" How can I overcome this?
I have no idea where that error comes from.
The key to a shared database is to have the data tables in
one or more MDB files on the server machine and the queries,
forms, reports and modules in an MDB file on each user's
machine.
This is not a matter of convenience. It's a question of
maintainability and reliabilty.
--
Marsh
MVP [MS Access]
