security

[Guest]

i have a replicated database that a colleague of mine is trying to open up.
the problem i am having is that i dont have permissions to even view the
file. i need to know if it is possible to remove all permisions and get
access to it.
1. remove permissions on a replicated database
2. take the file rename and resave without any of the old information
3. change permissions?
i need some serious help with this one guys. i def. appreciate any response.
THANKS

 

[Joan Wild]

i have a replicated database that a colleague of mine is trying to open up.
the problem i am having is that i dont have permissions to even view the
file. i need to know if it is possible to remove all permisions and get
access to it.
1. remove permissions on a replicated database

The fact that it's replicated doesn't matter. You need to use the workgroup
file that it was secured with and log in as a member of the Admins Group.
You can then assign full permissions on every object to the Users Group.
Also, you shouldn't replicate anything but tables. Split the mdb and
replicate only the backend. Replication wasn't meant for other objects.

2. take the file rename and resave without any of the old information

I gather you intend to remove replication then? Once you have it unsecured,
you can just open Access using the standard system.mdw and import all the
objects from your mdb. If you don't want the data, you could just run a
series of delete queries to delete the data.

 

[Guest]

Joan,
i do not have the workgroup file, how can i finagle one?

 

[Joan Wild]

Joan,
i do not have the workgroup file, how can i finagle one?

You would need to recreate it using the same name and PID as the original.
If you don't have that, then I'm sure if you use google you can find someone
willing to help you hack into the database.