• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1031
  • Last Modified:

Edit Msysqueries

I am using Access 2003 and I need to edit an entry in the msysqueries table.  How can I do that?
0
Hermetica
Asked:
Hermetica
  • 5
  • 4
1 Solution
 
GRayLCommented:
Options, View tab, check system objects.
0
 
GRayLCommented:
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.
0
 
HermeticaAuthor Commented:
I already have that setting.  I can see it, but I can't change it.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
GRayLCommented:
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.
0
 
HermeticaAuthor Commented:
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.
0
 
HermeticaAuthor Commented:
Never mind.  I fixed it myself.
0
 
GRayLCommented:
How? That is what this is all about.
0
 
HermeticaAuthor Commented:
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.
0
 
GRayLCommented:
Thanks for answering. Have a good one.
0
 
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now