PC Review


Reply
Thread Tools Rate Thread

Can't read queries in Access 2003

 
 
BenL712
Guest
Posts: n/a
 
      22nd Dec 2008
I am running Access 2003 SP3. I am new to the company and am trying to fix a
problem on a file that was created by the last guy here. The one person who
uses the db had no problems until she migrated to a new laptop. Now she
cannot run any of the queries. It does not appear to have any security
enabled - no specific users or groups other than the standard Admin and User.
All objects had shown a db owner of <unknown>. I was able to make all other
objects belong to Admin except for queries. I also attempted to create a new
blank db and import every object into it, but I can't get queries as I can't
read them. They all show up normally under the query group window, but any
attempt to run them results in the error message "Could not read definitions;
no read definitions permission for table or query X." I also attempted to
remove the old system.mdw file and create a new one, which didn't work. The
user indicates she is not aware of any specific workgroup and had not been
required to enter a user id/password before.

Thanks in advance for all your help!

Ben
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion of MS Access queries to SQL queries raonhassan Microsoft Access Queries 1 8th Jun 2007 12:11 AM
Help: Convert these Access queries to Microsoft SQL 2000 queries: admlangford@gmail.com Microsoft Access 5 16th Mar 2007 05:45 AM
Approach queries VS Access queries Nuti Microsoft Access 1 18th May 2006 12:29 PM
Access Queries to Sql Queries Scott Elgram Microsoft Access 0 24th May 2005 07:03 PM
Access: Documenting use of tables/queries in queries =?Utf-8?B?QXVja2xhbmQgQWNjZXNzIFJhdGVy?= Microsoft Access 0 3rd Aug 2004 11:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:19 PM.