Solved

Edit Msysqueries

Posted on 2004-07-31
11
962 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

Industry Leaders: 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!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

628 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