Cant Connect to Data base

[Lian]

Hi every body
I have a problem with accesses and visual studio. I've just installed
XP and I can't get a connection with the Data base. I have this error
and I don't know how to fix it

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '. It is
already opened exclusively by another user, or you need permission to
view its data.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet
database engine cannot open the file
'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '. It is
already opened exclusively by another user, or you need permission to
view its data.

Source Error:

Line 29: private void Page_Load(objec t sender, System.EventArg s e)
Line 30: {
Line 31: this.oleDbConne ction1 .Open ();
Line 32: this.oleDbDataM ainAdapter .Fill (this.dataSetPl ayers1 );
Line 33: this.oleDbConne ction1 .Close ();

Source File: c:\inetpub\wwwr oot\manufactor\ webform1.aspx.c s Line:
31

Stack Trace:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '.
It is already opened exclusively by another user, or you need
permission to view its data.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr)
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider()
System.Data.Ole Db.OleDbConnect ion.Open()
Manufactor.WebF orm1.Page_Load( Object sender, EventArgs e) in
c:\inetpub\wwwr oot\manufactor\ webform1.aspx.c s:31
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

[Bradley1234]

If you create the database in the design page with the tools tab, you can
manually setup and test the database?

If you make a new dataConnector, click on properties and click on the
properties DataSource, then click on the add project data source wizard?

It should give you the chance to examine all the settings. The blank
password is advised, but databases tend to lock you out to protect the data
integrity.

Are you trying to open the database, copy to a new database that you operate
on, then close the database? And operate on the copy?

Do you need to make changes or can it be read only? Usually Ive found it
helps to allow all changes to be discarded by dumping the copy, and make
several warning buttons before the main database is changed
"Lian" <li*****@hotmai l.com> wrote in message
news:1a******** *************** ***@posting.goo gle.com...

Hi every body
I have a problem with accesses and visual studio. I've just installed
XP and I can't get a connection with the Data base. I have this error
and I don't know how to fix it

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '. It is
already opened exclusively by another user, or you need permission to
view its data.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: The Microsoft Jet
database engine cannot open the file
'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '. It is
already opened exclusively by another user, or you need permission to
view its data.

Source Error:

Line 29: private void Page_Load(objec t sender, System.EventArg s e)
Line 30: {
Line 31: this.oleDbConne ction1 .Open ();
Line 32: this.oleDbDataM ainAdapter .Fill (this.dataSetPl ayers1 );
Line 33: this.oleDbConne ction1 .Close ();

Source File: c:\inetpub\wwwr oot\manufactor\ webform1.aspx.c s Line:
31

Stack Trace:

[OleDbException (0x80004005): The Microsoft Jet database engine cannot
open the file 'C:\Inetpub\www root\Manufactor \DBManufactor\d bmanufactor.mdb '. It is already opened exclusively by another user, or you need
permission to view its data.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr)
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider()
System.Data.Ole Db.OleDbConnect ion.Open()
Manufactor.WebF orm1.Page_Load( Object sender, EventArgs e) in
c:\inetpub\wwwr oot\manufactor\ webform1.aspx.c s:31
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

[Liran By]

Thank you for your answer but fortunately I've tried all of those things
and it didn't work. How do I open the data base for more then one user?
when i open the accesses a copy temp file appears with alock on the
icon. how do i unlock it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bradley1234]

Ok, maybe its just wording here, but is your program going to modify any
database records? I mean, can you open read only?

When designing, I typically create dummy databases with known values at
specific locations so that no real data is lost

Your program should be able to operate on a new database you just created.
If you make a new db will you get the "already in use" error?

Do you run Microsoft Access ? Is it open? Does it have your database open?
If so, make sure Access closes the database because Ive had the "unable to
access db" if Access has it open

I dont know what you mean by "open the accesses a copy temp file"
"Liran By" <li*****@hotmai l.com> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..

Thank you for your answer but fortunately I've tried all of those things
and it didn't work. How do I open the data base for more then one user?
when i open the accesses a copy temp file appears with alock on the
icon. how do i unlock it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Liran By]

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Liran By]

Hi

I am getting desperate .I will try to be more clear. When I'm opening
the access in the same folder another file is opening also. The icon is
the same as the icon of access but with one difference. It has a lock on
it and I think it causes the problem. Do you know how to unlock this
file?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Anne Nolan]

When you open a Jet ("Access") database, a file with the same name as the
MDB file is created, but with extension LDB. This is normal, and its
purpose is to keep track of who's in the database.

Whatever you are doing to open the database the first time is apparently
opening in in "exclusive" mode, which is why you get that message. But, the
LDB file is not the source of the problem.

Anne

"Liran By" <li*****@hotmai l.com> wrote in message
news:%2******** *******@TK2MSFT NGP09.phx.gbl.. .

Hi

I am getting desperate .I will try to be more clear. When I'm opening
the access in the same folder another file is opening also. The icon is
the same as the icon of access but with one difference. It has a lock on
it and I think it causes the problem. Do you know how to unlock this
file?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bradley1234]

Hi Liran,

When you say "Access" ?? This has 2 meanings when talking about databases
and I dont know which one you are saying. Microsoft Access is a well known
application progam; but the word access means to get at something, like a
database; So you might say
"MS Access" and thats what Im assuming you mean here.

1. You have MS Access running and double click on the database file icon
you want to use, it has the MS Access style icon.
2. It opens, but creates another icon, which adds a "lock" picture, okay
Ill try something with my MS Access, hold on...

Ok, when I do this, it gets a second icon that shows who opened the file.
Im guessing that Access automatically opens a database as tight as it gets,
meaning total lock.

If youre coding in C# with a database *.mdb? and MS Access opens it first?
Its going to be locked out. (I think) Could your question be how to have MS
Access AND your C# program use a database at the same time??
"Liran By" <li*****@hotmai l.com> wrote in message
news:%2******** *******@TK2MSFT NGP09.phx.gbl.. .

Hi

I am getting desperate .I will try to be more clear. When I'm opening
the access in the same folder another file is opening also. The icon is
the same as the icon of access but with one difference. It has a lock on
it and I think it causes the problem. Do you know how to unlock this
file?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!