Link to home
Start Free TrialLog in
Avatar of Hermetica
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?
Avatar of GRayL
GRayL
Flag of Canada image

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.
Avatar of Hermetica
Hermetica

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.
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.
Never mind.  I fixed it myself.
How? That is what this is all about.
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
Avatar of modulo
modulo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial