Sorting and Saving Queries

M

Megan

I have a SQL table that is attached to Access. I have
many tables, and queries in there. There are multiple
people that have access to the .ADP file.

The problem occurs when a query is run and viewed, but
sorted in a different way that the original query was
built. When the query is closed, Access asks if changes
want to be made. If the user answers yes, an error
message occurs saying "Object Invalid, Extended properties
are not permitted on 'Query Name', or object doesn't exist"
It will not save the changes.

This problem is only happening on one machine and I am not
sure how to fix it.

Can anyone help me? I would greatly appreciate any help
with this issue.

Thanks so much,
Megan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Working outlook via vba code with xlsx - error 0
Access 2002 change report header text 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Object is invalid. Extended properties are not permitted on '<*>.< 2
Some mail merge fields not pulling into document 2
Multiple ODBC Queries 2
Reasons that queries has no result 4

Top