Moved secured .mdb and lost permissions

[adalger]

A colleague was working on a database, developed with user-level security. When he was satisfied with its operation, he moved the secured .mdb file and its accomplanying .mdw file to a network drive to deploy. He then created a shortcut which appears to properly reference the moved .mdb and .mdw files, but gets the message "You do not have the necessary permissions to use the <name of file> object."

Is this a known issue? Any advice on fixing it?

TMTOWDI - it's not just for Perl any more

 

[PHV]

I think he should have full control on the directory where the DB is (for .ldb file).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[adalger]

He does -- he created the folder to house the db, and is the owner. Supplemental information: Windows XP Professional, Access 2k, Novell Client 4.91.

TMTOWDI - it's not just for Perl any more

 

[PHV]

Have a look here: thread181-942230

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[adalger]

Interesting information, but wrong problem.

TMTOWDI - it's not just for Perl any more

 

[adalger]

Okay. I'm an idiot. The shortcut needs to have the target as

[COLOR=black yellow]"<path_to>\MSACCESS.EXE"[/color] "<path_to>\DB.MDB" /WRKGRP "<path_to>\WGIF.MDW"

Guess what part we left off.


TMTOWDI - it's not just for Perl any more