Hi again.
Had some success yesterday pulling data from a Access mdb that was located in a folder in the WWWRoot folder. I then wanted to see if I could have a front end mdb somewhere on the network and link the tables to the web mdb but because it is on the other side of the DMZ this would not work so it looks like I shall have to go the way of using DSN. As a newbie this is causing some problems, i'm getting this error message on the website,
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/data.asp, line 8

I checked the code for data.asp and it points to another ASP file, testdata.asp which looks fine but it refers to an htm file, Connection_odbc_conn_dsn.htm, which I cannot locate anywhere. Can any pass me any advice on what is wrong and how I can resolve this ?

Thanks in advance,
Mitch....

Going just by file name alone, the Connection_odbc_conn_dsn.htm is the file that contains the information that you need to locate. It should contain the dsn connection. You'll need to try and find it, or replace it with another file that has the correct dsn connection.

I have to say it's a really poor idea to keep that connection information in an HTML file unless it's outside the public folder, otherwise, anybody who stumbles across it can read your connection info and possibly hack the database. That really should be an .asp file.

Cheers Witchblade. I too thought it would be an ASP file but where and why it creates this html file is beyond me. I can't locate it anywhere !!