Solved

Edit Msysqueries

Posted on 2004-07-31
11
920 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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now