Pls Need help with DB Split

[Guest]

I am new to splitting Access DB. This is my first time. I used the Database
Splitter Wizard. My DB was in a share drive and decided to split it. by
maintaining the back end in the share drive and then putting a copy of the
Front end on the user's desktop. However, when opening the db on the user's
desktop there was an error saying it did not recognize the path and to check
the path. Can you please help?

 

[Duane Hookom]

Do all users have the same drive mappings? You can open the Linked Table
Manager to check where the tables are linked from and re-link them.

 

[Guest]

Thank you for your response. Can you please tell confirm the back end db
should reside in the share drive and the front end is the copy to be
distributed to users hard drives. Would it be okay to keep a copy of the
front end in the same share drive?

 

[Duane Hookom]

I always recommend placing the front ends on a user specific drive/folder so
that each user has their own copy of the front end.

If you link the back end to tables on the "R" drive but users have that
drive mapped as their "S" drive, you will get the error. You can use the
server name when linking like \\SERVERNAME\shares\Depts\Finance\PIP_BE.mdb.