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

Question

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.

Answer 1

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.

Answer 2

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