473,320 Members | 1,939 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Admin locked all users out of Database

LMHelper
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
2 1743
nico5038
3,080 Expert 2GB
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
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

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

Similar topics

12
by: Google Mike | last post by:
You know, while working on my moonlight corporation's LAMP project at home this weekend, I couldn't help but wonder if people writing similar projects are solving similar problems with having to...
5
by: David C. Barber | last post by:
I'm trying to determine which user has locked a given record from VB6. I know I can use sp_lock and sp_who, and match up the data to determine which users have locked records in my database,...
2
by: byrocat | last post by:
I am working with a SQLServer installation where all public permissions have been revoked from the system. I currently hold the securityadmin and sysadmin roles to perform my logicall access...
12
by: Arno R | last post by:
Hi there, I just distributed an application in which I (try to) change db.properties depending on CurrentUser() For instance I set the property's AllowBypassKey and AllowBuiltinToolbars to False...
6
by: DebbieG | last post by:
I have created a database for a client and was told that it was to be a one-user database. Well, you know the next statement ... now they want 3 people to be able to use the database. (FYI, I...
11
by: AnhTai | last post by:
Hi all, I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: -...
2
by: gangac | last post by:
I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has...
8
by: aklein | last post by:
I was given a database to update and am running into the following problem: The database appears to have been secured using Access security (it is an MDB, not MDE). Every form etc that I try to...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.