upgraded to Access 2007 from 2003 - lost admin rights

[Linda]

Our office upgraded from 2003 to 2007 and since then, I am unable to make any
changes to the database. I was very careful in 2003 to set up security and
save all the workgroup information. I can open the database and all of the
tables, etc., but can't figure where to enter all of the WID info, etc. that
should be in place.

I am a basic user who unfortunately has no support at work, hence I must
turn to this group for assistance.

I did see message references to inserting this into the properties - but
where??
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
Also, would the "path" be the drive access resides on? Sorry to be so
dense, I am NOT a programmer!

Thanks for your assistance.

 

[Tom van Stiphout]

On Mon, 1 Mar 2010 10:54:01 -0800, Linda

That phrase:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
refers to making a shortcut. Right-click on the desktop and choose New

Shortcut.

You will see a field named Target. That's where you type a long
string. The first part of that string is the exact location of
msaccess.exe. Typically it's a location such as:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
Note how I put double-quotes around the text. This is required if
there are funny characters like spaces in the text. Use your
computer's Search feature to search for msaccess.exe.
Next in the long string is a space, then the exact location of your
database. Then another space, then /wrkgrp, and finally the exact
location of the .mdw file that is used by your application. This is
the security file that may be hardest to find. Again use your search
feature. Also check possible previous shortcuts for this information.

-Tom.
Microsoft Access MVP

 

[Linda]

Tom - I just saw your response - for some reason, the notification email was
turned off. Anyhow, I just tried the string you suggested. Here is what I
typed in (actually cut and pasted in most cases):
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Documents and
Settings\linichols\My Documents\FARGAS\db R3 FARGAS " /wrkgrp "C:\Documents
and Settings\linichols\Application Data\Microsoft\Access\System5"

I am now getting a message whiile Access is opening that says "Microsoft
Access couldn't find the file 'C:\Documents and
Settings\linichols\Application Data\Microsoft\Access\System5'
This file is required for startup.

I copied the string right off of the search screen, so I know it is correct,
and I can go to the file and open it.

Any suggestions?
I feel that I must be getting close!

 

[Tom van Stiphout]

On Tue, 25 May 2010 09:35:01 -0700, Linda

The second part of the shortcut is not a path to the mdb, or it would
include ".mdb" (or any of its cousins) at the end. The same thing with
the path to the .mdw file.
You must have Windows Explorer configured with the default settings
which include "hide extensions for known file types". This is not
appropriate for programmers. We need to see the full filename.

-Tom.
Microsoft Access MVP

 

[Linda]

I made the changes and added mdb and mdw to the appropriate files. I am
still gettting a message that says Access can't find the files.

 

[Joan Wild]

please post what you currently have in the target of the shortcut (you
can copy and paste it)

Joan Wild