inexplicable table deletion

  • Thread starter Thread starter fasisi
  • Start date Start date
F

fasisi

hello,

i have a strange situation. somehow my table is deleted. and it occurs
randomly, not only a specific table.

do you know why?

thank you,
fasisi
 
Suggestions:

1. Make sure Name AutoCorrect is turned off. Details:
http://allenbrowne.com/bug-03.html
The compact/repair the database.

2. Make sure no code is marking the table hidden.
This flag could cause it to be deleted when compacted.

3. If this database is being used by others, don't let them near the
database window. It is all too easy to delete stuff.

4. If you are really stuck, create another table. Create a relationship,
where your original table is the primary one, and this new table is the
related one. In the Create Relation dialog, check the box for Referential
Integrity (but not the other two.) Enter a record that connects to one of
the records in your original table.

Now, at the point when the deletion is about to take place, you will get an
error message saying the table cannot be deleted. You can use this as an
indicator of what or who is deleting your table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top