3033 error

[Gitche Gumee]

This query works:
INSERT INTO [Outlook Contacts] ( Company, Address, City, State, [Zip/Postal
Code], Phone, [Business Fax], [Email Address], [User Field 1] )
SELECT Customers.CompanyName, Addresses.Address, Addresses.City,
Addresses.State, Addresses.Zip, Customers.PhoneNumber, Customers.FaxNumber,
Customers.EmailAddress, Customers.CustomerID
FROM Customers INNER JOIN Addresses ON Customers.CustomerID =
Addresses.CustomerID
WHERE (((Customers.CustomerID)=[Forms]![Customers1]![CustomerID]));

The same query without the Where clause causes a 3033 permissions error: You
do not have the necessary permissions to use the <name> object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you.

I'm the designer and the only user. There are no passwords or permissions on
the DB.

Can anyone explain?

 

[Clifford Bass]

Hi,

Perhaps some kind of corruption in your database? Can you open up and
browse through all of the records in Customers and in Addresses? Make a
backup and try a compact and repair if you have not already done so. If
that does not help, try creating a new database and importing the two tables,
the query and the form into it. Does the query run there when it does not
have the where clause? If it does, import any remaining items from the
current database, retire the current one and use the new one.

Hope that helps,

Clifford Bass