Database link and Webforms

ny2222

New member
Joined
Jul 23, 2004
Messages
3
Programming Experience
10+
Well I am not sure where this should go but this seemed like the best place.
I am having real trouble getting a webform to open a database - in this case an ACCESS database (using the JET engine)
I tried setting up a simple datagrid (which works fine with a regular windows form)
but on the Webform version when the program tries to execute the database.fill instruction I get the following error:
The Mcirosoft Jet database eingine cannot open the file (my .mdb file). It is already opened exclusiverly by another user, or you need permission to view its data.

I have a feeling this is a permission or security issue, but have no idea what. The ASPNET virtual machine is a local user.

any help would be greatly appricaited.
 

levyuk

Well-known member
Joined
Jun 7, 2004
Messages
313
Location
Wales, UK
Programming Experience
3-5
You need to make sure that the ASPNET users has permission to ammend the database, check under the databases security options in properties.

Also make sure you close the connection to the database once you have finished reading from it.
 

ny2222

New member
Joined
Jul 23, 2004
Messages
3
Programming Experience
10+
Thanks for the reply....I think that is it...only Admin has Permission for that database...but I am not sure how to add ASPNET...
 
Top Bottom