Is there a way to unlock system object tables for editing?

[Davefeet]

Is there a way to unlock the system tables.

If I go into to tools>option>view(tab) and then under show select "system object"

I want to be able to edit those tables. DO you know of a way to do this.


SLC: Greatest snow on earth!!!

 

[psemianonymous]

You shouldn't be editing the contents of Access' system tables.


But from what you wrote above, you've already done the hardest part. Now just find the table in the 'tables' window, double-click to open it, edit it.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Davefeet]

WHen I open it I cant edit it. I want to edit the fixed width delimated table, and it wont let me edit it. I 'm in the table but I can't edit it....



SLC: Greatest snow on earth!!!

 

[psemianonymous]

If you're using Access/JET security, you may check under Tools->Security->User and Group Permissions to see whether you have permissions, and if not, who does have permissions, to edit the table. I think you can assign yourself permissions if you need to...


...but again, why do you need to edit a system table?

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[MichaelRed]

If you THINK you need to edit system tables, I think you need remedial reading in a few areas. You are either a LOT more capable than almost everyone in these fora or not qualified to edit this information. Posting the question belies the latter.

I do not mean to be HASRH, but this needs to be said -without mincing words.


Editing system information in a relational database can be quite harmful to the database.




MichaelRed
mlred@verizon.net

 

[assets]

I think you are trying to open or edit MsysACE's table. As stated above be VERY carefull if you change ANY table. Remember work with a copy of the data base NOT the orginal.

 

[KenReay]

HI

Is the answer to this that you should be using the builtin functionality of Access/VBA to update these tables, thus if you wish to add a table use the .create method of the tabledefs collection, if you want to add a field use the .create method of the fields collection, and so on and so on, the data is stored in the systen tables, but you manipulate it via the methods provided, in that way suitable checks are maintained to prevent you from screwing it all up,

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[assets]

If you want to hide a table in the database windows so that other users can't select it, preface the table's name with 'Usys'. For example, if your table's name is employee, change it to UsysEmployee. This makes your table into a system object which access does not display. To see this table later, choose view, options, show system objects.