Error on database.

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

Guest

I have a database that is shared with about 20 users. This database already
existed when I came into this company. It is created in Access 97. It
currently has a table that is corrumpted. I cannot access this table, I
cannnot delete it and I cannot compact or repair the database. Because of
this I created a database and imported all of the tables except for the one
that was corrupted. However when I try to have multiple users access this
new fixed database I get an error and only one can access it. How can I find
out how this table was setup as the front end and the back end. How can I
find out which other file this corrupted database uses as a back end? Does
this make sence. Any help is appreciated.

Thanks
Celia
 
Hi Kitty,

I need to know a few things before I can answer your question.

1. What version of Access are you running?
2. Do you use Access security settings?
3. Do you use an MS SQL 2000 backend or are all of your tables stored in an
Access mdb file? (FYI - briefly, backend refers to where your data tables
are stored)
4. What error message are you getting?

Russ
 
Hi Russ:

1. What version of Access are you running?
We are running Office 97 on a Windows XP environment.

2. Do you use Access security settings?
We don't use Access security settings, we use the SQL 2000 security settings
for allowing users to access the tables.

3. Do you use an MS SQL 2000 backend or are all of your tables stored in an
Access mdb file? (FYI - briefly, backend refers to where your data tables
are stored)
We use the MS SQL 2000 backend to hold all of our tables, except for that
table that is bad that recides in the database which is partly corrupted.
The table that recides on the database is bad (got corrupted while trying to
access the database wirelessly)
4. What error message are you getting?
The eror that I am gettinng while trying to get rid of that table is:
Access has performated an illegal operation and it must be shut down.
I am getting this error as well when I try to run the Database compaciting
or the database repair. Or when I try to access that specific table or
anything related to that table.
 
Hi Kitty,

I found resources for you in regards to fixing Damaged MS Access Jet based
databases.

http://www.datarevive.com/support/kb/kb2204.htm

The link contains quite a few knowledge base articles that may help you.

Keep in mind that you are using (in computer terms) a very old piece of
software. Technology in regards to drivers and data access has changed
significantly since Access 97; consequently, Microsoft no longer supports
Access 97. Newer versions of Access can also support multiple users much
better than older versions.

You may end up saving yourself a lot of time and changing over to a newer
version of MS Access (i.e. Office XP or Office 2003), because their are most
likely compatibility issues between MS Access 97 and Microsoft XP's data
access components and drivers. Changing over is not overly difficult, it may
require some debugging.

One last point, make certain that you have two copies of the database. One
production and the other development. If you are using the production
version to update reports, queries, forms or tables, it is very easy to
corrupt the database (Access 97 in particular). The development and the
production versions also act as backups (i.e. if the production version
becomes corupted, the development copy can be used to replace it. If the
change didn't go as expected, undo your errors with a copy of the Access
production version.

Hope the information helps

Russ
 
Back
Top