Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Edit Msysqueries

Posted on 2004-07-31
11
Medium Priority
?
984 Views
Last Modified: 2008-01-09
I am using Access 2003 and I need to edit an entry in the msysqueries table.  How can I do that?
0
Comment
Question by:Hermetica
  • 5
  • 4
11 Comments
 
LVL 44

Expert Comment

by:GRayL
ID: 11685446
Options, View tab, check system objects.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 11685448
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
 

Author Comment

by:Hermetica
ID: 11685461
I already have that setting.  I can see it, but I can't change it.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 44

Expert Comment

by:GRayL
ID: 11685687
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
 

Author Comment

by:Hermetica
ID: 11686031
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
 

Author Comment

by:Hermetica
ID: 11686851
Never mind.  I fixed it myself.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 11689693
How? That is what this is all about.
0
 

Author Comment

by:Hermetica
ID: 11815012
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
 
LVL 44

Expert Comment

by:GRayL
ID: 11815492
Thanks for answering. Have a good one.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12685353
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question