By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,084 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,084 IT Pros & Developers. It's quick & easy.

Admin locked all users out of Database

LMHelper
P: 12
The problem started when a database Form Page for users starting acting wierd when Service Pack 3 was installed. The form they use that brings up a control box or drop down list was "blank" I saw in other websites and postings that the Service pack 3 caused this problem. So now we are having problems with the Securities on the Database and the Admin cannot get in - it is telling us that there is no such user. I thought that I could switch out the MDW file from an earlier date (backup) but when we try that it states this user is unable to open or convert the database. Almost like it is stating it is an earlier version. I had converted this database back in March 2007 from Access 97 over to Access 2000. So this does not make sense. Not only can we not get into the database due to security issues (it is not even accepting the Admin's password and user ID) to fix the problem with the format in tables to make the Form control list box show up correctly. But it is now saying it may be an earlier version? Is anyone else having problems with this?

Please help.

Tracy Dahl
Lockheed Martin
Oct 17 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
This is a new problem to me, but it has signs of database corruption.
You could try these steps:
1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm

check also: http://www.granite.ab.ca/access/corruptmdbs.htm


Nic;o)
Oct 18 '07 #2

LMHelper
P: 12
Thank you so much for your input.. We found out what the problems were. First of all the SP3 Service Pack did in fact mess with the Control List boxes and we "finally" were able to get into the tables database directly to change the format. This fixed that problem. The reason that Access was coming up with an error stating that we were trying to enable or convert an earlier version of the database when we were trying to open up the tables directly is due to the fact that when we converted the database over we never converted the tables database itself. We have a tables database and a MDW file plus the front end of the database. We converted everything BUT the tables database. We found this out just recently because of having to go back into it for fixing. So the Admin went into it through Access 97 itself and made the formatting changes. We still did not convert it because now everything is "working" and we do not want to mess with it more. The switching out the MDW file worked because that seemed to be corrupted as well, (but I think the Admin himself did this). I do the research, they go in and fix it. :) So this issue is closed for now. Thanks again!
Oct 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.