Quote:
|
Originally Posted by pkstormy
When you get into the mdb, are you able to go to design view of any form or does it tell you that you don't have permissions to get into design view?
|
It tells me I don't have permission to do anything. I try and open it in design view, even importing data into a new blank db still says I don't have privileges.
Quote:
|
Originally Posted by pkstormy
Are you able to get into design view of the tables?
|
No.
Quote:
|
Originally Posted by pkstormy
Are you able to go to Tools -> Database Utilities -> Convert and convert the database to a later version of MSAccess?
|
No. Doesn't let me convert either, says I have insufficient privileges to access that .mdb object.
Quote:
|
Originally Posted by pkstormy
What version of MSAccess are you currently using?
|
We have 2003 installed. However if I go by the shortcut to launch the program:
C:\FFWEAR\Office\MSACCESS.EXE /runtime /wrkgrp "C:\WIN2003\FFWEAR.MDW" "C:\FFWEAR\ffwearproCP.mdb"
MSACCESS.EXE I think is version 95. File version is 8.0.0.5903
The entire folder is attached.
Quote:
|
Originally Posted by pkstormy
Did you try getting into it and exporting all the objects into another new mdb?
|
I can't even get into the database.
Quote:
|
Originally Posted by pkstormy
Did you try importing any of the objects into a new mdb?
|
Yes. I can see all the object inside the db, but when I click import, it says I don't have permission.
Quote:
|
Originally Posted by pkstormy
If you select Tools -> Security, what options are available for you? Have you tried adding a new user if available? Are you able to edit the Admin user?
|
If I open what file? Opening the .mdw file doesn't give them these options.
Quote:
|
Originally Posted by pkstormy
Are you able to run the wrkgadm.exe and join to the mdw file?
|
Yes. I've joined ffwear.mdw and system.mdw several times with name "admin".
Quote:
|
Originally Posted by pkstormy
Are there ANY other mdw files on the drive anywhere?
|
Yes. I've attached another system.mdw that is from an older back up.
Quote:
|
Originally Posted by pkstormy
Did you create a new mdw (DON'T)? Again, I think the one you supplied is not the correct mdw. See if there are any other mdw's anywhere which might be related to this mdb. If you somehow replaced the current mdw with a different one or somehow created a new one, you need to let me know. You may need to restore the mdw before you created a new one. The mdw is extremely important and holds all the security information for the mdb. Creating a new one or copying one from another source can make it futile in breaking the security (and lock yourself out of the mdb which is very easy to do!)
|
Well, because I can't contact the original developer I can't get any real clarification. Maybe he wanted to lock everyone out on purpose? All I know is that he is long gone and I really need to get into that database.
Quote:
|
Originally Posted by pkstormy
Upload screen snapshots in a zip if you can. It will really help.
|
Ok I'll include some next post.
Quote:
|
Originally Posted by pkstormy
Otherwise, there are companies you can search for on the web which specialize in unprotecting mdb's. Cost I believe is around $100 or more (but don't quote me on that.) They may also need the original mdw file though. I'm trying to help you free of charge but I need you to try a few things.
|
I'd love to give you some money to do that or anything similar for me? Your help as been absolutely invaluable to me. Thank you very much
pkstormy