Hermetica
asked on
Edit Msysqueries
I am using Access 2003 and I need to edit an entry in the msysqueries table. How can I do that?
Options, View tab, check system objects.
Sorry: That should be Tools, Options, View tab, check system objects. Be very careful with changes to any of these tables. Make a backup first or you may lose your database.
ASKER
I already have that setting. I can see it, but I can't change it.
Check Security tab in Tools - User and Group permissions. When you list tables, and check MSSysQuery you have to have update, insert, and delete permissions.
ASKER
Well, we're on the same wave-length. I've already done that, too, but I still can't make any changes to the msysqueries table.
ASKER
Never mind. I fixed it myself.
How? That is what this is all about.
ASKER
I opened a new database. Imported and/or linked all my tables, queries, forms and macros and everything was straightened out. The corruption in the msys files were cleaned-up with the new database.
Thanks for answering. Have a good one.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.