How to move a secure Db from one laptop to another

[Glen]

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

 

[strive4peace]

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
*

 

[Joan Wild]

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]

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

 

[Rick Brandt]

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.

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.

 

[Glen]

"wif" Workgroup Information File

 

[Rick Brandt]

"wif" Workgroup Information File

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

 

[Glen]

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

 

[Glen]

Im sorry I keep saying workgroup file I mean workgroup ID

 

[Rick Brandt]

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

len

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.

 

[Joan Wild]

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