Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reserved error (-1517); there is no message for this error.

Status
Not open for further replies.

Phooey

Programmer
Feb 14, 2000
111
GB
I can't for the life of me figure this one out.... :-(

I have an Access 2000 database running on the Runtime software which purely imports data from a powerbuilder database using an Adaptive Server Anywhere 6.0 ODBC connection to a dtabase on an NT server. The database is not exceptionally large, only about 8000 records in total across 10 tables.

I have tested this using the Full version of Access 2000 and Access 2000 Runtime files on a client build machine.

The only time this error occurs (as far as I know so far) is if the User tries to import the data (I've not been able to reproduce the error). It falls over running an append query which compares an external table to an Access table and append all matching records to a temporary table for later use.

Code:
INSERT INTO ArchEnqTemp ([Enquiry Number])
SELECT DISTINCTROW sepowner_archived_enquiry_header.enquiry_number
FROM [SEP HEAD]
INNER JOIN sepowner_archived_enquiry_header
ON [SEP HEAD].[Enquiry Number] = sepowner_archived_enquiry_header.enquiry_number
WHERE ((([SEP HEAD].Source)="L"));

ArchEnqTemp - Access Temporary table
[SEP HEAD] - Access table
sepowner_archived_enquiry_header - External table

All importing is done from compiled VBA modules calling Access queries.

I can't find any help on this error anywhere so any help would be much appreciated...

Phooey
Andrew.j.harrison@capgemini.co.uk
Otherwise known as Windy Bottom.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top