I would swear the syntax on this is correct. The sad part is that this tiny little statement is giving so much trouble.
The connect string is good. I use it 900 other places on the same site.
<%
Dim SSLPath, MainURL
SSLPath = "https://secure6.virtualvision.net/collegecrib/"
MainURL = "http://www.collegecrib.com/"
Dim Database
Set Database = Server.CreateObject("ADODB.Connection")
Database.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=" & Server.MapPath("/fpdb/AiCart.mdb")
Database.Open
Set ConnectDB = Database
Database.Execute("INSERT INTO AuthUsers (User) VALUES ('vv1domain\wandile')")
%>
Done
Thanks,
- Brad