Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Please Help - How To Sharing Database In LAN

TJ-AriffTJ-Ariff Posts: 5Member
Hi,
i need to know what coding for run my program (VB6) with access database between 2 or 4 computers in LAN.
-------------------------------
Private Sub Form_Load()
CustData.databasename = App.Path & ("CIS Database.mdb")
CustData.RecordSource = "CISData"



--------------------

when i run this program in another computer the error come out :

"Class not registered. Looking for object with CLSID:{0000000010-...}"


so how can i solve this problem

i already map a networking folder as a G drive. But still cannot.
___________________________________
Set DB = OpenDatabase("G:CIS.mdb")

__________________________

Please Help....


Comments

  • WEBMASTERWEBMASTER Posts: 549Member
    Perhaps one idea.

    Make sure the appropriate access database drivers (ADODB...?)? are installed on the client machines.


    [blue][italic][b]/WEBMASTER[/b][/italic][/blue]

  • dokken2dokken2 Posts: 532Member
    : Hi,
    : i need to know what coding for run my program (VB6) with access database between 2 or 4 computers in LAN.
    : -------------------------------
    : Private Sub Form_Load()
    : CustData.databasename = App.Path & ("CIS Database.mdb")
    : CustData.RecordSource = "CISData"
    :
    :
    :
    : --------------------
    :
    : when i run this program in another computer the error come out :
    :
    : "Class not registered. Looking for object with CLSID:{0000000010-...}"
    :
    :
    : so how can i solve this problem
    :
    : i already map a networking folder as a G drive. But still cannot.
    : ___________________________________
    : Set DB = OpenDatabase("G:CIS.mdb")
    :
    : __________________________
    :
    : Please Help....
    :
    :
    :

    how are you running the vb6 exe on the other computer? i assume you created an installation with the package & deployment wizard and are not just copying the exe file itself.
  • TJ-AriffTJ-Ariff Posts: 5Member
    : :
    :
    : how are you running the vb6 exe on the other computer? i assume you created an installation with the package & deployment wizard and are not just copying the exe file itself.
    : _____________________________________


    No, I run from Mapping drive (G:).
    also i try just copy the files, but still error.

    u mean, must create the installations programs ?

  • TJ-AriffTJ-Ariff Posts: 5Member
    : Perhaps one idea.
    :
    : Make sure the appropriate access database drivers (ADODB...?)? are installed on the client machines.
    :
    :
    : [blue][italic][b]/WEBMASTER[/b][/italic][/blue]
    :
    :
    _______________________

    Were can i get the files.... or u mean i must install VB6 to another computer ?


  • honest_dudehonest_dude Posts: 93Member
    I really need this too because the vb program i created cannot be used on LAN and some of them would be very useful if it is possible to use on LAN.

    Let me know how to make them usable on LAN system, if anyone knows

    my mail - sz_khiangte@yahoo.com


    Thank you.

    Zela

  • sudipta0183sudipta0183 Posts: 1Member
    If you want to share your access database then first copy the database file in shared document,then create a dsn and select the database file,after that from the client computer from where you want 2 access the database create a dsn and select the database from network and run your application it will cork properly.

Sign In or Register to comment.