Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Edit Msysqueries

Posted on 2004-07-31
11
Medium Priority
?
973 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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

722 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