Database Connection [Resolved]

Printable View

Apr 3rd, 2005, 08:52 PM
Simply Me

Database Connection [Resolved]
Hi! I am trying to connect to my database. The database is in another computer. below is my connection code:
VB Code:
```
Set MyConn = New ADODB.Connection
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data Source=\\NetServer\Dbase\DatLibrary.mdb"
MyConn.Open
```
Below is the error:
Microsoft Jet Database engine cannot open the file '\\NetSever\Dbase\Datlibrary.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Apr 3rd, 2005, 09:28 PM
dglienna

Re: Database Connection

Probably has a password on the DB, or the Server
Apr 3rd, 2005, 09:57 PM
randem

Re: Database Connection

Simply Me,

Check the other computer to see if it does have the database open. If not then erase the ldb file on the computer where the database is to unlock it then try again. You may have to reboot to get it to release.
Apr 3rd, 2005, 10:01 PM
Simply Me

Re: Database Connection

Quote:

Originally Posted by dglienna

Probably has a password on the DB, or the Server

I dont have any password for my DB
Apr 3rd, 2005, 10:34 PM
Simply Me

Re: Database Connection [Resolved]

Got it now. i forgot to share the DB folder. ;)

All times are GMT -5. The time now is 04:33 AM.