Filling a data adapter control

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hello, 

I am trying to work with a database in Visual Studio.NET.  I have created
a connection (cnn), data adapter (da), and a data set (ds).

When I click on Data/Preview Data from the menu bar I am able to see the
results. 

In my code, I have 

private void Page_Load(object sender, System.EventArgs e)

        {

            // Put user code to
initialize the page here

da.Fill(ds)       ;   

             dg.DataBind()  

        }

When I go and run the program, it crashes at da.Fill(ds) and the error
message is as followed:  

"Cannot open the file 'C:\Location of databasebase\databaseName.mdb'. 
It is already opened exclusively by another user, or you need permission to
view its data"

I am working on a stand alone computer and I do not have the database
open.  The only logical conclusion I have came up so far is the user id in
the connection string may be incorrect. When I change to any other name besides
Admin/admin - the connection fails and thus I am in the same situation.

Any assistance would be appreciated.

RCorr