To give a little background, I am working on an application using VB6 with Access 2000 and ADO to connect. The OS is XP. My application is creating a new table from a .csv file, then using this table to populate data in another table in the database.
The issue is that my application works fine on my development machine, which is in English. However, international users have started using the program and are experiencing problems (specifically, Portugese and Turkish users). It's been tough to gather information but the error message is
Run-time error -2147217904(80040e10)
missing one or more necessary parameters
Here is the snippet of code that is causing problems. The error message seems to be thrown at the SQL DELETE statement. This is a tough one to debug and fix since on my development machine, everything works fine.
Dim con As New ADODB.Connection
con.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Records.mdb"
con.Execute "DROP table TempTable"
con.Execute "SELECT * INTO [TempTable] FROM [TEXT;DATABASE=" & App.Path & "].[TempFile.csv]"
'The purpose of the DELETE is to ensure that no existing records are overwritten. The 3 TempTable fields
'are combined to match the format of the [Recs].[IDNo] field, which is "xx-xx-xxxx"
con.Execute "DELETE TempTable.* FROM [TempTable] INNER JOIN [Recs] ON [TempTable].[Expr1] & '-' & [TempTable].[Expr2] & '-' & [TempTable].[Expr3] = [Recs].[IDNo]"
Any help would be greatly appreciated. I'm having a difficult time with this one.