After running DataGrid control and Binding control with an Access database successfully, I tried to run a Windows application on another Access database. This WinForm did show up; however, the first record was missing and all the database buttons didn't work.

Later on I tried to run a WebForm (aspx) application with the second databse. Simiarly, a 'can not open the file' error msg showed up. I checked my database security properties, my user name was permitted to access the database. The error msg displayed the reason for the error: It is already opened exclusively by another user, or you need permission to view its data.

Questions:
1. How do I know if the database is already opened by another user?
2. The coding I used was from a 2004 VB.net book. Is it possible that the VS.net 2002 does not support this source codes:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg:
 'Put User Code to initializa the page her
 Me.OleDbDataAdapter1.Fill(Me.DataSet11.Employees)
 Me.DataBind()

TIA,
Jeffrey

__________________
C. Jeffrey Wang

The error in question normally occurs in one of 2 secnarios: (note: I am basing this off of past ASP experience and not .NET as I have never tried to connect to Access from .NET)

1. Someone has opened the file directly in access and has caused windows to Lock the Database; while Access is open and running this database, your application will not be able to use it.
2. You have opened a connection to the database somewhere and have not closed it hence all subsequent calls cause this error to be thrown.

The code that you provided above should work just fine.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi Jeffrey,

Your user account probably has nothing to do with it; it's usually the ASPNET or Network Service account that you need to configure. Take a look here:
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=263

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thank you very much. I have solved the problem.

For the benefit of the archive of this forum, would you mind telling us how you solved it?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi Imar,

I opened the link in your email and followed the instruction to set up an database read and write permission for my VB.net account. That's it.

Thanks again,
Jeffrey

Great. Thanks for the follow up....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.