Results 1 to 3 of 3
  1. #1
    the_others is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2010
    Posts
    4

    Multi Prgarm Need to use the same DB

    Hello All



    I have Already Acceess DB, and there is a project written in Vb wich use that DB, And i have to make another program which have to use the same DB
    i Split the DB and the two programs connected to the DB, but when i try to use the second Program it said that the DB aready in use by the first program

    That is my connection, i think the problem is that connection open the DB exclusively

    Set db = DBEngine.Workspaces(0).OpenDatabase("BD Path", True, False, ";PWD=Password")


    How can i solve that

    THanks

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Change that "True" to "False" to specify opening the DB in Shared Mode. That should solve your problem.

  3. #3
    the_others is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2010
    Posts
    4
    Thanks it worked

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to Query a Multi Value Combo Box
    By Viperpurple in forum Queries
    Replies: 0
    Last Post: 03-22-2010, 07:33 AM
  2. Multi Update By Checkbox
    By Nsquared in forum Forms
    Replies: 3
    Last Post: 02-10-2010, 03:08 PM
  3. Multi value field - Combobox help
    By stougch in forum Forms
    Replies: 0
    Last Post: 10-19-2009, 10:47 PM
  4. Multi Level Form
    By bkelly in forum Access
    Replies: 2
    Last Post: 08-28-2009, 11:15 AM
  5. Multi Page Forms?
    By Simon Sweet in forum Forms
    Replies: 0
    Last Post: 03-05-2008, 04:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums