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.
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.
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.