moving secure database from desktop to network drive

[Markitos]

My database has a group setup and I want to move it from my destop to the
network drive but cant seem to. I have three access icons since setting up
security: 1. security icon, 2. mdb file( shortcut file), and 3. access file.
How do I transfer these files correctly? Thanks- Mark

 

[Scott McDaniel]

My database has a group setup and I want to move it from my destop to the
network drive but cant seem to. I have three access icons since setting up
security: 1. security icon, 2. mdb file( shortcut file), and 3. access file.
How do I transfer these files correctly? Thanks- Mark

Generally, you'd transfer the security file to an accessible network drive, then build a shortcut that would "point" to
that location, something like this:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "full path to workgroup file"

This opens Access with your security file, then opens the database. This can be tricky when deploying, since the first
two paths can be different on each machine. You can use UNC paths for the workgroup file (like
//MyServer/MyFolder/securityfile.mdw).


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Don Barton]

My database has a group setup and I want to move it from my destop to the
network drive but cant seem to. I have three access icons since setting up
security: 1. security icon, 2. mdb file( shortcut file), and 3. access file.
How do I transfer these files correctly? Thanks- Mark

I would also recommend Tony Toew's Auto FE Updater. This program not
only performs updates transparently, but will also use the workgroup
file of your choice. This is a life saver of a program, and after
using it in various client situation, I highly recommend it.

http://www.granite.ab.ca/access/downloadsindex.htm

This program has made my life much easier. The cost is your
conscience; if it helps you then send a donation.

Don