moving secure database from desktop to network drive

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markitos - 25 Jun 2007 23:20 GMT

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

Reply to this Message

Scott McDaniel - 26 Jun 2007 14:01 GMT

>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

Reply to this Message

Don Barton - 27 Jun 2007 00:53 GMT

On Jun 25, 4:20 pm, Markitos <Marki...@discussions.microsoft.com>
wrote:

> 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

Reply to this Message