Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1

    Exclamation Unanswered: MS Access Database sharing a single file over network

    Hi all...
    I finally gotten around to test my program over the network and now it’s telling me that the file is already in use on the other computer (the office side, the Lab side trying to edit something) and vise-versa.

    Im using JET 4.0. If i only use one then it works just fine, adds, edits and updates.. but when i have both running on the network then it wont add, edit or update anything, just has the error of the file already being used.

    Ive tried a lot right now…. Including…

    Changes .Mode to:
    .Mode = adModeReadWrite
    .Mode = adModeShareDenyNone

    Also I have changed the rst.Open to….

    adOpenDynamic, adLockOptimistic

    Still am getting the error….Seems when I start the Lab program first then the Office side, it doesn’t give an “already in use” error at the beginning… but it still will not let me update anything regardless.

    I have seen stuff about "splitting" my Access mdb file.. Only thing is i have two tables and nothing else... thats fine for the "backend" file sence it only needs to have the tables and thats it... but then they tell me to make a "front-end" one with everything else in it (queries, forms, etc etc) but i do not have anything else, just the 2 tables and thats it.

    A step by step on making a split access thing would be nice for me and which one i need to use when calling up the database in Visual Basic...

    Any help would be great,
    David

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    simple experiment to try: make yourself a front end empty database.

    from this empty front-end: File ¦ GetExternalData ¦ Link to both of your back-end tables.

    talk to the front-end(s) with forms, code, queries etc

    izy

  3. #3
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1
    K, i have tryed doing this:

    change the code (for the Office side) to:
    Code:
        With conn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
            .ConnectionString = "C:\windows\database\frontenddb.mdb"
            .Mode = adModeReadWrite
            .Open
        End With
    changed the code (for the Lab side) to:
    Code:
        With conn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
            .ConnectionString = "C:\windows\database\frontenddb.mdb"
            .Mode = adModeReadWrite
            .Open
        End With
    But when i do that, it only writes to each hard drive.... aka doesnt show the input on the other computer that was entered.

    I also tryed this
    change the code (for the Office side) to:
    Code:
        With conn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
            .ConnectionString = "C:\windows\database\frontenddb.mdb"
            .Mode = adModeReadWrite
            .Open
        End With
    changed the code (for the Lab side) to:
    Code:
        With conn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
            .ConnectionString = "\\Davetest\c\windows\database\frontenddb.mdb"
            .Mode = adModeReadWrite
            .Open
        End With
    That one gives me a "already in use" error when running the Lab side when the Office side is running.

    The db file frontenddb.mdb has a black arrow pointing at my 2 tables in Access. Now it says they are linked to "C:\windows\database\backenddb.mdb" for both tables that i have. Shoulnt this be "\\Davetest\c\windows\database\backenddb.mdb" for the lab side since its on the network?

    David
    Last edited by StealthRT; 07-26-03 at 17:03.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •