troubles opening a table

[fguihen]

ok, im using dreamweaver 2004, and using Asp ( not .net as far as im aware of).

my connection string is :objConn.ConnectionString="Provider = Microsoft.jet.OLEDB.4.0;Data Source =c:/inetpub/mysite/siteDb.mdb"

 

i get my error on this line :

Set objRs.Open = "Customers",objConn,,adLock,adCmdTable

 

i have used a this line in the same format in college for the last while, but now ,when running

it all off my laptop i get this error message:

 

Error Type:

Microsoft VBScript compilation (0x800A0401)

Expected end of statement

/fintan/AddedDetails.asp, line 12, column 28

Set objRs.Open = "Customers",objConn,,adLock,adCmdTable

---------------------------^

 

the "=" after the "open" was asked for, even though i never used that in college and it always

worked for me. anyone any ideas..

 

o, just for reference, im filling data into a form on one page, and trying to insert it into a

access DB on the asp page, and then display the entered info. it was all so simple in college,

but its not working out so well here.

[PlausiblyDamp]

try

objRs.Open  "Customers",objConn,,adLock,adCmdTable