How would i...

[rtatnell]

How can I change this code:

Set DBCon = Server.CreateObject("ADODB.Connection")
DBCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db\gamers.mdb")

to suit the fact that I now have to log on to my database using a username and password. (I followed [SWR]Ribeyed's tutorial earlier to protect my database)

Cheers

[rtatnell]

nope, that aint done it.

I'll probably leave it as it is, as now I know no one can get to my database through my source code (as you proved earlier).

Thanks again

[rtatnell]

nope, tried that and a whole load of other combinations too...

[rtatnell]

Technically correct!? hmmm....
Well I'd have a lot more to recode if I went through changing that too; it works, so what's wrong with that?!

Thanks anyway for all your help
I'll see ya soon on here no doubt, next time I'm stuck!

[rtatnell]

It still doesnt like it. The new method works fine on my unsecure database, but its not liking the whole username and password bit. I tried using:

DBConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& Server.MapPath("db\gamers.mdb") & "User ID='Myuserid'; Password='Mypassword';"

And the other ideas on this thread too with no luck. It's getting a bit annoying now! :confused:

[rtatnell]

Never mind mate, thanks for putting so much into helping!

I'm quite happy with the security now anyway (plus I dont get enough visitors to my site to worry that much at the moment)

Thanks again