Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 989
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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