Solved

Edit Msysqueries

Posted on 2004-07-31
11
953 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

751 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