I created a database and secure it with the wizard, it is working find but
now I want to put a copy on another laptop and it is bringing up the path of
the first computer. How do I change the path in the target or is there
another way to make it work on the second computer (the on I put the copy one)

Thaks glen

Hi Glen,

if you are using Access 2003 or below:

press SHIFT when you click to open the database and keep it held down
until the database actually opens

choose -->
Tools, Database Utilities, Linked Table Manager

in the lower left corner, check --> Always prompt for new location

if all the tables are linked to the same database, click the 'Select
All' button

click OK

navigate to the back-end database


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

  *
    (: have an awesome day :)
  *





Glen wrote:
Show quoteHide quote

Did you copy the mdb, mdw and the shortcut to the other laptop?  If so,
then you'd need to modify the shortcut to reflect the paths to the mdb
and mdw.  Also, do you really want two separate copies of the mdb in use?

Did you actually split the mdb?

Joan Wild
MS Access MVP

Glen wrote:
Show quoteHide quote

Yes, I copied all three to a flash dr and then to the second computer. I did
split the database. In the wif the path still shows the original computer,
and so it saying cannot find. Oh I am transfering to another computer so
someone else can take over the db and I can keep my laptop. I created it on
that laptop and secured it there.

Thanks glen

Show quoteHide quote

On Sat, 31 Jan 2009 06:17:01 -0800, Glen wrote:

What is the "wif"?

Your table link paths in the front end and the paths in your shortcut
must either use UNC format or be changed for every computer you use them
on.

"wif" Workgroup Information File

Show quoteHide quote

On Sat, 31 Jan 2009 08:58:04 -0800, Glen wrote:

There is no "path" stored in a workgroup file.  What exactly are you
referring to?

when I click on the short cut, I get an error message that says "cannot find
C:document and setting\computer name\security\filename" this is the same
address in my WIF file

Thanks Glen

Show quoteHide quote

On Sat, 31 Jan 2009 09:33:02 -0800, Glen wrote:

So change your shortcut to where the WIF really is located.  If it were
located in a shared folder on the network and the path you used was UNC
like...

\\ServerName\Sharename\Security.MDW

....then that shortcut will work on any computer on your LAN that has
access to that shared folder.  Any shortcut that points to a specific
location on YOUR PC obviously has little chance of working when copied to
some other PC.

Im sorry I keep saying workgroup file I mean workgroup ID

Show quoteHide quote

You have been given the answer you need; just modify the shortcut to
point to the correct location(s) on the second laptop.

i.e. on the second laptop,
right-click the desktop shortcut
edit the target line
The target line says something like
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:document and
settings\Glen\databasename.mdb" /wrkgrp "C:document and
settings\Glen\WIFName.mdw"

You need to edit the path to the mdb and the path to the mdw to reflect
their location on the new computer.

Joan Wild
MS Access MVP

Glen wrote:
Show quoteHide quote

2007 access to a 2003 database
Password to open certain report
log in passwords
Database 30 Day Password
access to edit form but not change form
User Level Security on Replicated
Other methods for preventing "not have exclusive access at this time" message?
How to Identify a Digitially Signed Database ?
Access 2000 Security
error 3303