mdw file move to shared network drive

[jimmy g]

i want to move the mdw file created on my local drive to a network drive ?
when i copy or move the local version my access files located on the network
won't open

 

[Granny Spitz via AccessMonster.com]

when i copy or move the local version my access files located on the network
won't open

That's because you're joined to the wrong workgroup when you try to open the
secure databases, which also means that the databases were probably secured
properly, since you can't open them with another workgroup (exactly what you
want to happen).

Instead of opening the file directly, it's best to use a shortcut that
includes the new path to the workgroup file and the database file, like this
(it's all one line):

"C:\Program Files\Microsoft Office\OFFICE10\MSACCESS.EXE" \\Server\IMDB\
Database.mdb /wrkgrp \\Server\IMDB\Secure.MDW

 

[jimmy g]

Thanks, but I don't really follow you. If i didn't put a lot of time into a
form I designed to use with the database I would just delete everything ,
reinstall access again, and start over. Anyway to save the form design ?

 

[Granny Spitz via AccessMonster.com]

If i didn't put a lot of time into a
form I designed to use with the database I would just delete everything ,
reinstall access again, and start over.

Good heavens! You don't have to get that drastic! User-level security is a
tough bullet to chew, but you'll overcome the hurdles if you keep practicing
and don't give up.

Anyway to save the form design ?

I take it you've designed a form in another database to open the secured
database, which is now located on the network, right? If so, how are you
opening the secured database? With a hyperlink on your form?