Permissions

[Mark L]

I recently had to reload Windows XP, after I re installed all my programs, I
now cannot open one Access 2003 database. It comes up with the error message
"you do not have the necessary permissions to open this database. Contact the
owner or administrator blah blah blah". I wrote it and am logged on as
adminstrator. Other databases open OK. Any help would be great, I'm totally
stuck.

 

[Graham R Seach]

Mark,

It sounds to me like the offending database was created with
user/group-level security, in which case, unless you have a backup of the
MDW file, your outta luck.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[aaron.kempf]

yes.

MDB security is CRAP.
use SQL Server and Access Data Projects; you can keep most of your
existing forms and reports-- but you don't have to deal with random
data loss like you do with mdb

 

[Mark L]

Thanks Graham
I found the mdw file, and copied it to the same directory as the database,
but it makes no difference, should I be doing anything else?
--
Thanks

Mark L

Mark,

It sounds to me like the offending database was created with
user/group-level security, in which case, unless you have a backup of the
MDW file, your outta luck.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

 

[Graham R Seach]

Mark,

<<...should I be doing anything else?>>
Yes. Create a shortcut to the database. Then right-click the shortcut and
select Properties from the context menu. At the extreme left of the Target
box, enter the path to msaccess.exe (enclosed in quotes). Then at the
extreme right of the Target box, enter the path to the mdw file.

....so the whole thing should look something like this:
"c:\Program Files\Microsoft Office\Office 11\msaccess.exe"
"c:\Temp\myDatabase.mdb" "c:\Temp\myWorkgroup.mdw"

The above may have been split onto two lines by your newsreader. It should
all be on one line. Make sure to change the paths and filenames as
appropriate to your system.

Click OK, then double-click the shortcut. You'll be prompted for your user
name and password. Enter those, and all will be well with the world.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Thanks Graham
I found the mdw file, and copied it to the same directory as the database,
but it makes no difference, should I be doing anything else?