Home » questions » I need to fix my connection string for an online Access Table to a database. What do I change?

I need to fix my connection string for an online Access Table to a database. What do I change?

2
2006-08-10 22:01:35, Category: Programming & Design
Provider = Microsoft.Jet. OLEDB.4.0; User ID=Admin; Data Source = login.mdb; I realize I shouldn't have the spaces. But I didn't want answers to cut them off. So the database and Access Table *.htm file are located in the same folder. This isn't an ASP file, so I can't use the " & Server.Mappath ("login.mdb") & " to work this out. Any ideas? I took out the User ID=Admin. I'm trying to make a DSNless connection.

Answers

  1. blah_in_az

    On 2006-08-10 22:08:39


    I have never used HTML files to access a table, I don;t even know if it is possible. I have always given my database access through ASP pages. Because the HTM pages will run on the client machine, while the ASP will run on the webserver.

  2. p_sathiish

    On 2006-08-10 23:26:09


    You can try Tabular Data Control (TDC) ...