About System tables in MSAccess

No.  Even if you could, the risk of corruption exists and therefore not a good idea.  Instead, programitcally, make changes to the objects and allow Access to update them.  Reading the system tables is no problem, however.

What exactly are you trying to do? Why do you need to drop/write to the system tables in Access?

Will has answered your question succinctly.

Joe

Joe, could you imagine what would happen if you 'dropped' a system table????  Yikes!!!!!

It would give a new meaning to corruption for MS Access.

I tried and tried, but appearantly access has secured them enough for ignorant users.. Now the chalenge is to find out how you can delete or change the tables....

Oh you can delete them.......and also be sure to provide a nice parting gift for your db............

hey I'm not blond:) I created a nice dummy database with some tables and tried to delete the system tables, but I wasn't allowed:(

LOL!!!!!  

I'm bored, don't want to be serious and keep thinking it will be the end of friday sometimes soon... thought deleting systemtables would be fun specially the errormessage that it would create, scare the hell out of my collegues, but alas.. I will have to live with the system tables....

I gotchya.  Did you try to delete vis a code.  Certain tables can be dropped that way.

I imagine that if they can be deleted at all, your best chance is to connect to them through an ODBC connection and delete them.  I am not knowledgeable about doing DB programming over ODBC, but if you could write low level DB code that ignores warnings, you might succeed.  I don't have a clue where to start beyond that.

Now that I have advised you, please do not use such knowledge to attack anyone.

There is a definite way to do it in dos.
del *.mdb will remove the system tables....but there are some side effects that might be undesirable!!

undesirable side effects... could be............  ;)

LOL!!!

This is a great thread!

Now if only the originator of the question would respond as to why they would want to do such a thing.

Joe

I'll be good and make a copy first:) It's friday afternoon and I want to annoy everyone as much as they have annoyed me all week.

people, i want this to protect by project, I dont want it to be so easy to steal.

When the main form open it run a script that check for some key value in the registry, if the key value is not the expected one then I want to perform some operations in my db like drop or alter the system tables.

Anyway if somebody can post here a better and more robust method it's ok to me.

Batista

for others reasons it cant be deleted,  what are those other methods joe?