ASP / SQL: Parametres on connection string

<%
dim dbConn
dim resSet
Set dbConn = Server.Createobject("ADODB.Connection")
Set resSet = Server.Createobject("ADODB.Recordset")

dbConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db\news.mdb")
Set resSet = dbConn.execute("SELECT * FROM News")
%>

Where and how to add User and Password information? I keep getting "No read permission on 'News'" error

I think I've done everything correctly, except I can't access to the db. If I try to modify security / user & group accounts, I get a dialog "Record(s) cannot be read; no read permission on 'MSysAccounts'".

At work, we have separate Workgroup Administrator which is targetted to a system database (.mda) file. This can be the reason, why I can't access externally to a database created at work?

Heck, the network admin at work *tries* to keep this stuff a secret, lol... although I've managed to glean some info from him a time or two. ;)

It definitely sounds like a network problem though... I would talk to your network admin and say "Hey, I need to read from this file!!!" - if he's cool, he'll hook you up. :)

Originally posted by whammy
It definitely sounds like a network problem though... I would talk to your network admin and say "Hey, I need to read from this file!!!" - if he's cool, he'll hook you up. :)

*g*
I just happens to be, that I'm also the possible admins this minor company could have about computers and information techonology.

I remember there was an easy way to allow permissions through this .mda file to modify user & group permissions in db itself. Unfortunately, the other guy (who has created this permission thingie) is on vacation :(.

I'll have to build the db somewhere else to prevent permission information to be attached on it.

I wish I could help more... but I probably have much less knowledge than Dave on this particular aspect of ASP! :(

If I was you I'd go look around in IIS on the machine in question if you can, though... just to see what you can find out...