Database Connection Question

[csiwa28]

If I connect to a database like so.......

Set oConn = Server.CreateObject("ADODB.Connection&quot
MdbFilePath = Server.MapPath("AMCA.mdb&quot
oConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM ProductTypes"
Set oRS = oConn.Execute(SQL_query)

do I still need to include commands found in the adovbs.inc like adLockReadOnly, adCmdTable if I want to Delete, Update, or Insert?

 

[CooterBrown]

NO..You just need connection.execute(query)

"Driver={Microsoft Access Driver (*.mdb)}; DBQ="
&

I've never seen this code with those braces{} around the driver.

set OBJdbConnection=Server.createobject("ADODB.connection&quot
strProvider ="Driver=Microsoft Access Driver (*.mdb); DBQ=" &_
server.mappath("database/b_days_anvsry.mdb&quot & ";"
OBJdbConnection.open strProvider

 

[csiwa28]

Well I am able to open up the database and pull records for display, but when I want to delete a record I get an error

"Could not delete from specified tables".