Reading from Linked Tables on an ASP page

[curtishamrick]

Hi All-

I am working with a page that reads from an Access table (using VB Script). It is a simple application that compares username and password fields in the table and compares it to what the user entered. If it finds a match, another field diplays. It works great, up to the point when I use a linked table. I am using a .csv file as my linked table. I tried moving the .csv file over to the server, but no luck. I get an access engine error that appears to be telling me that it can't find the .csv file.

Any tips would be appreciated.....also, would it be possible to read directly from the .csv file?

Thanks

[jhardman]

Hi All-

I am working with a page that reads from an Access table (using VB Script). It is a simple application that compares username and password fields in the table and compares it to what the user entered. If it finds a match, another field diplays. It works great, up to the point when I use a linked table. I am using a .csv file as my linked table. I tried moving the .csv file over to the server, but no luck. I get an access engine error that appears to be telling me that it can't find the .csv file.

Any tips would be appreciated.....also, would it be possible to read directly from the .csv file?

Thanks

Show the code for the db connection and the query statement. That may tell what's going wrong.