p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Pro VB Databases (http://p2p.wrox.com/forumdisplay.php?f=81)
-   -   Access (.mdb) over network using Jet 4 OLE DB (http://p2p.wrox.com/showthread.php?t=57962)

sajid_rauf May 16th, 2007 07:41 AM

Access (.mdb) over network using Jet 4 OLE DB

I'm trying to use Ms Access mdb on a network using a shared folder on a machine. I'm having trouble running the application simultaneously on more than one computer on the network and gives an error something like this "File in use". They work fine when I run them individually.

How can I solve this problem? Furthermore the crystal report in the application is also not showing on the machine on which the mdb does not reside. It works fine on the machine with the mdb. The path in the CR designer is correct.

Here is the code.


'These lines go in a Module so that it makes it easy to use the objects in differnt forms
Option Explicit
Public con As New ADODB.Connection
Public rs As New ADODB.Recordset
'Module ends

Private Sub MDIForm_Load()
con.Provider = "Microsoft Jet 4.0 OLE DB Provider"
con.Properties("Jet OLEDB:Database Password") = "abc"
con.Open ("Data Source=\\jsf\jsf\JSF.mdb")
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.ActiveConnection = con
End Sub

I would really appreciate if anyone can give me a few tips soon.

Anxiously waiting for replies.

Take care, Peace!

All times are GMT -4. The time now is 08:01 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.