access 97- error 3011 occurs after migrating from windows 95 to xp

P

pop

i have recently migrated to windows xp and now get an error 3011 (The
microsoft jet database engine could not find the object "EzyChart.txt) in vba
routine that uses 'connect' property to import text data.i have been using
this routine for several years without a problem with windows 95.
The routine fails on the last line of code listed below.
'ConnectOutput dbstemp, _
"CSVTable", _
"Text;DATABASE=C:\importdocs;TABLE=EzyChart.txt", _
"EzyChart.txt" '

'Sub ConnectOutput(dbstemp As Database, _
strtable As String, strConnect As String, _
strSourceTable As String)
Dim rstLinked As Recordset, rsttd1 As Recordset
Dim intTemp As Integer
Dim strasxcode As String, stropenprice As String, strhiprice As String
Dim strloprice As String, strcloseprice As String, strvolume As String
Dim strdate As String
Set tdflinked = dbstemp.CreateTableDef(strtable)
tdflinked.connect = strConnect
tdflinked.SourceTableName = strSourceTable

dbstemp.TableDefs.Append tdflinked'

I have verified the pathway is valid using 'search' and the schema.ini file
exists and contains a valid entry for this file.

desperately in need of a solution for this problem.
 

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