A
Andreas
Create a folder in your "C:" drive.
Call it "Database" (without the quotes).
Copy the database (.mdb) into that folder.
Copy the workgroup (.mdw) into that folder.
Create a shortcut as follows:
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\Database\YourDatabaseName.mdb" /WRKGRP
"C:\Database\YourWorkgroupName.mdw"
Ensure the workgroup file is the one the wizard created and not the
original one. Ensure you type the above with the quotes as shown without
pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in
the directory as per above - if not, modify the path appropriately.
If this doesn't work, I am out of ideas.
You can make Access look at the workgroup file permanently but then you
will have issues with any other databases that may be in use or created
later, therefore I won't go there.
As far as security is concerned, this is a whole discussion in it's own
right.
My main concern at this point is that if you are going to have multiple
users and the database is not on the server, and anyone makes changes,
the others will not be able to see those changes as everyone has their
own local copy, which is not shared.
Regards,
Andreas
Call it "Database" (without the quotes).
Copy the database (.mdb) into that folder.
Copy the workgroup (.mdw) into that folder.
Create a shortcut as follows:
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\Database\YourDatabaseName.mdb" /WRKGRP
"C:\Database\YourWorkgroupName.mdw"
Ensure the workgroup file is the one the wizard created and not the
original one. Ensure you type the above with the quotes as shown without
pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in
the directory as per above - if not, modify the path appropriately.
If this doesn't work, I am out of ideas.
You can make Access look at the workgroup file permanently but then you
will have issues with any other databases that may be in use or created
later, therefore I won't go there.
As far as security is concerned, this is a whole discussion in it's own
right.
My main concern at this point is that if you are going to have multiple
users and the database is not on the server, and anyone makes changes,
the others will not be able to see those changes as everyone has their
own local copy, which is not shared.
Regards,
Andreas