Sharing a DB with other locations

[Allie]

I have created a database (front end and back end) that I
would like to share with other offices (not over the
internet/intranet).

I have emailed it to another location and they were not
able to open it (even though I sent the DB with its own
workgroup file specific for that location)

The other location had to create new databases and import
the database objects. In doing this some important things
were missed, like the VBA references, causing the database
to crash.

Please help

Thanks

 

[Joan Wild]

I have created a database (front end and back end) that I
would like to share with other offices (not over the
internet/intranet).

I have emailed it to another location and they were not
able to open it (even though I sent the DB with its own
workgroup file specific for that location)

They would need to open the frontend using the correct workgroup file.
Ideally, they'd create a desktop shortcut to open it (since they may put it
in a different folder than you). The target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
In addition, you'd need to either provide a method for them to relink to the
backend tables in code ( see http://www.mvps.org/access/tables/tbl0009.htm)
or they'd need to use Tools, Database Utilities, Linked Table Manager to do
so.

The other location had to create new databases and import
the database objects. In doing this some important things
were missed, like the VBA references, causing the database
to crash.

Since they were able to do this, it may not have been secured properly to
begin with.