Talbe show as in use by others, when it is not

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hello.

I just created a database with multiple
tables/queries/macros. The last table I created had two
fields: "Org" and "Factor". The factor field had several
fields populate with a fraction (12/5, 12/8). I received
errors saving the table, but the table did save.

Now, I want to create another table, and I cannot. I want
to run my queries (which are make table queries), and I
cannot -- I get a popup window that says the table already
exists, but it won't delete/overwrite it.

I want to delete the table and I cannot - I get this
message "The table is already open exclusively by another
user, or it is already open through the user interface and
cannot be manipulated programmatically". Did I activate
some kind of SQL code that is causing these errors?

All I want to do is delete this table and run my macros.
 
Chances are you have corrupted the table as well as the database. Without
opening the database, but opening Access, issue a compact/repair against the
database. Depending on the version of Access you have, depends on whether
these can be issued separately or as one action.

Make sure your database is closed down and no one else is in the database.
If separate, issue the repair first.

If it does not repair, look for an .ldb file named the same as your mdb
database. Make sure your database and Access is closed down this time and no
one else is in the database. Delete the .ldb file. Retry the repair. If that
is successful, the issue a compact. Again, assuming these are listed
separate. If they are together, that is okay.

Another action if all above fails, is to create a new database. Using the
Import feature of Access: File | Get External Data | Import, try to import
all the tables accept the one with the fractions. Import any queries, forms,
reports that have may have been created in this other database. Issue a
compile against the new database using the code editor window (View | Code).
Then select Debug | Compile.

The table with the fractions. What is the data type? If it is number, then
this will be an issue. To my knowledge Access can not accept fractions.
These must be calculated out and entered with the decimal equivalent. If it
is a text field, then this is not an issue. However, you won't be able to
conduct any calucations with the fractions.
 
Back
Top