Ms Access Error

S

silkkeng

Hi, I am creating a make table query based on a 57k rows of Link Table which
linked to my Access 2007 database.

The link table is linked to PSQL database.

In my query, if I try put a join condition, or not putting any condition, I
am getting an error below:
Reserved Error (-7711); there is no message on this error.

The make table query doesn't work.

However, if I straight away put the condition "Like '1249%' "on one of the
column, it does works.

So, I am not sure what is going wrong here.

Can someone advise?

Thank you and apperciates.
 
J

John W. Vinson

Hi, I am creating a make table query based on a 57k rows of Link Table which
linked to my Access 2007 database.

The link table is linked to PSQL database.

In my query, if I try put a join condition, or not putting any condition, I
am getting an error below:
Reserved Error (-7711); there is no message on this error.

The make table query doesn't work.

However, if I straight away put the condition "Like '1249%' "on one of the
column, it does works.

So, I am not sure what is going wrong here.

Can someone advise?

Thank you and apperciates.

It may be a problem with the PSQL database or with the ODBC connection (is
that what you're using?) as well as with Access. Try putting a "hits
everything" criterion such as "Like '%'" on the field, if this is a one-time
operation.

You did not post the SQL view of the query so it's a bit hard to be sure there
isn't something else wrong...
 
S

silkkeng

Hi John,
Thank you for your reply.

Apparently this is not a one time query.

The query is a simple INSERT INTO Table () SELECT FROM Source table.

I saw this fix and was just wondering if this is related to this since I am
connecting to pervasive via ODBC.
http://support.microsoft.com/kb/884404

Hits everything creation doesn't work. this will make table with 57k rows
Putting Inner Join condition also doesn't work. this will filter down to 422
rows

Only filter the field with hardcoded condition e.g. LIKE '1249%' and it
works. This is same result as inner join. But this one works and table is
made succesfully.
 

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

Top