Dividing mdb to data part and control part

[dannis]

Hello,

I've got divided my "some.mdb" to data part and control part with Access
2003 master.
As a result Access created a new file named "some_be.mdb", it contains
tables only.
Also Access wiped out tables from original "some.mdb" and left it with it's
original name.
The question is: how Access determines which file contains tables when
"some.mdb" starts?

Thank you.
Denis.

 

[John W. Vinson]

The question is: how Access determines which file contains tables when
"some.mdb" starts?

Each "table" in some.mdb is now in fact not a table - it's just a link, a
pointer to some_be.mdb. You can see this by hovering the mouse pointer over
the table name - you'll see the Connect string pointing to some_be.

If you need to change the location of the backend, you can use Tools...
Database Utlities... Linked Table Manager to display the current location of
the backend for each table (they'll all be the same place at this point, but
sometimes it's appropriate to have different tables in different backends),
and allow you to specify a new location for any or all of them.

John W. Vinson [MVP]