Cannot access Access database

I am a new user developing a Web form in vsnet. I have setup an ole
connection, a data adapter and a data set. When I test my connection it says
its OK. When I ask to preview the data from the data adapter properties box I
get a complete set of data. However when I try to fill the dataset from the
onload event of my form I get an error;

The Microsoft Jet database engine cannot open the file 'C:\Test
Databases\AMS Contacts BE\AMSContacts_be.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.

>From the investigation I've done I find that this is most likely due to
permissions on the c:\Test Databases folder. I don't have an ASPNET account
and despite running various versions of the asp aspreg_iis.exe command I
don't seem to be able to create one. As a last resort I added the account
'everyone' and gave it full control permissions to the folder. Still no joy.

Does anyone have any ideas?
.

Relevant Pages

  • vb- cant load data into data grid from Access db
    ... in Visual Studio from an Access db. ... I've got my connection, adapter, and dataset.i have tested my connection and ... When I go to Preview Data, then click fill data set, it works fine. ... but I have spent sooooo many hours trying to figure it ...
    (microsoft.public.vstudio.general)
  • Re: Multi-threaded apps and data readers
    ... So if I kept the connection open all ... commands reader, how would I prevent the readers from clashing or do they ... cmd.CommandText = "SELECT AccountName, accountid from accounts" ... I know it is possible because the data adapter class ...
    (microsoft.public.dotnet.framework.adonet)
  • Accessing Paradox Tables From C# Using ODBC
    ... I have added a Data Connection to the Paradox table in the Server ... I have also generated a data set from the data adapter. ...
    (microsoft.public.dotnet.general)
  • Re: GetString(4) is null
    ... >> This will trow an exeption: ... > have to read a data reader rather than a data adapter and data set? ... > Do you definitely have to read a data reader rather than a data adapter ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Access or SQL
    ... Team blog: http://devkids.blogspot.com/ ... D> I have some MS Access databases linked to SQL db's. ... D> I need to create a Web Form with Visual Studio 5.0 for useres to ... D> from VS Web site or should I create a connection to the MS Access ...
    (microsoft.public.dotnet.framework)