Access says that database is already in use

[phons]

I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.

From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).

Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time

This is the function used to connect.....

Public Function connectpm()
Set cn = New ADODB.Connectio n
Dim cnstring As String
cnstring = "provider=Micro soft.Jet.OLEDB. 4.0;Data source=" & server & "\" & path & "\Patent_ipm_db .mdb"
cn.Open cnstring
End Function

[phons]

please help me urgently have to submit it by tomo

I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.

From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).

Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time

This is the function used to connect.....

Public Function connectpm()
Set cn = New ADODB.Connectio n
Dim cnstring As String
cnstring = "provider=Micro soft.Jet.OLEDB. 4.0;Data source=" & server & "\" & path & "\Patent_ipm_db .mdb"
cn.Open cnstring
End Function

[QVeen72]

Hi,

Yes, Access Database Can be Opened for Multiple Connections..
Check the Sharing options for the Folder Which has Database.
It should be shared with Complete access.. (Read/Write).
Otherwise, you will get that error.

Regards
Veena

[r035198x]

I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.

From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).

Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time

This is the function used to connect.....

Public Function connectpm()
Set cn = New ADODB.Connectio n
Dim cnstring As String
cnstring = "provider=Micro soft.Jet.OLEDB. 4.0;Data source=" & server & "\" & path & "\Patent_ipm_db .mdb"
cn.Open cnstring
End Function

Please do not post questions in the articles section.
Moved to the forum section.

[danp129]

I haven't shared an access databases before, but I would:

Open the database connection as Read Only when not performing an update.

Close the connection to the database immediatly when done updating and reconnect as read only when finished.

[Killer42]

This question was posted twice, so I have merged the two threads.