Splitting a database - problems

N

Nancy

I have created an order entry database where 2-3 will be using for order
entry. They only need access to the order form. I have split the database
and moved the FE and BE to my shared drive (so I can copy the FE to each
users desktop). Everything works good on my computer, but other computers
receive a message that the file path for the BE database is not valid (it IS
correct). Holding down the SHIFT key when opening the database works for the
initial error message, but when the user attempts to open the form - they get
that same error message.

On another note, I want to have the form come up automatically when the user
opens the db. The switchboard worked fine, before I split the database.
What are some other solutions??
 
N

Nancy

Thanks Albert, that fixed the problem. I was even able to get my
switchboard to work, by deleting the macro before copying the db to the
desktop and then adding the AutoExec command once copied.
 
A

Albert D. Kallal

Splitting can be a bit tricky at first, but once you work with it..you will
start to like it very much (trust me on this one!!).

The problem is likely that you have a path name that includes a drive letter
(drive C: is not drive c on the other computers!).

To solve this, open the FE, (hold down the shift key), then use the linked
table manager. When you re-link to the BE, you need to browse via network
neighborhood.
 
Top