Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to take the security off of a database once you put it on?

I posted about my database yesterday and a couple of poeple posted some helpful things and I was able to get back into the database.(using the .bak) But now you can only access this database from my pc. I created the database on the server from this PC. If I can't take the security off is there anyway to make it so you can access the needed forms and reports from other PC's? I seem to have a file which one I don't know that is on my PC and not the server. I copied the SYSTEM.MDW and the workgroup administrator files to the server and it still doesn't work.
 
try to make a shortcut to it with <path to msaccess.exe> <path to mdb>
/wrkGrp<path to system.mdw> as the command line & you should be able to do
it
seccond option is to copy all objects from the secured db into a new
unsecured db (but option 1 is far better)

HTH

Pieter

lost said:
Is there anyway to take the security off of a database once you put it on?

I posted about my database yesterday and a couple of poeple posted some
Click to expand...
helpful things and I was able to get back into the database.(using the .bak)
But now you can only access this database from my pc. I created the database
on the server from this PC. If I can't take the security off is there anyway
to make it so you can access the needed forms and reports from other PC's? I
seem to have a file which one I don't know that is on my PC and not the
server. I copied the SYSTEM.MDW and the workgroup administrator files to the
server and it still doesn't work.
 
I copied the SYSTEM.MDW and the workgroup administrator files to the server and it still doesn't work.
Click to expand...

owwwwww....!!

I hope you kept a backup of the default system.mdw. If not, you have
disrupted ALL ACCESS DATABASES on the server.

As suggested - Stop. Turn off your monitor. Sit down and read the
Security Whitepaper carefully. THEN go back to work on fixing this.

You need to either use the Workgroup Manager (under the Security tab
in Access, or you can run wkgrpadm.exe in Windows) to join the
appropriate (different for each secured database!) MDW file, or use a
shortcut referencing that file to open Access. This is all explained
in the whitepaper.
 
Back
Top