ASP / SQL: Parametres on connection string

[Zvona]

[size=2][color="green"]<%
	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")
%>[/color][/size]

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

[Zvona]

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?

[whammy]

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.

[Zvona]

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.

[whammy]

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...