FE and BE Split database

[Guest]

Hi everyone,

I recently split my database into BE (Back End) and FE (Front End) **at
Home**. I came to work and pasted the BE into the shared drive on the
network, and the FE into my Desktop. When I attempted to open the FE from
the desktop, I got a missing path error that was referring to my home
directory. Now, I do understand that this is because I split the database
at home. But, I want to know how I can re-link the tables in the BE with FE
database. I tried to open the FE to go to the linked table manager, but the
option is not active (not selectable). The only solution I can think of is
to redo the splitting again, but this time at my work rather than home. I
hope that's not the only solution.

2. Also, assuming that I manage to get this issue resolved; would all the
users have the ability to open their FE database from their desktop and work
simultaneously?? THank you.


John

 

[John Vinson]

But, I want to know how I can re-link the tables in the BE with FE
database.

Open the frontend; delete ALL THE TABLES <don't worry, you're just
deleting links, not data).

Then use File... Get External Data... Link; navigate to the .mdb file
containing the tables, and select all.

This is what the linked table manager does, basically.

2. Also, assuming that I manage to get this issue resolved; would all the
users have the ability to open their FE database from their desktop and work
simultaneously?? THank you.

Each user should have their own copy of the FE, preferably on their
local hard disk. They should NOT share the frontend - only the backend
(using the table links).

John W. Vinson[MVP]