Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    USA
    Posts
    20

    Unanswered: Help with split database

    I'm using access 2003 with a split database. I've been using it over a year with no problems. I've created it with the wizzard. I have back up the front and back end and formatted my computer many of times and replace the file no problem.

    I just had to replace my hard drive. (ouch)

    My problem is that on my networked computers using the same front end that they had before hand when they are accessing the back end and they click on the arrow (control) to add a new record the arrow is greyed out! (They can view existing files only) On the host computer it is ok(it's not greyed out). The second problem is if someone has the database open, then no one else can open the database- get message saying the the file is in use.

    Everybody has the same front end on there own computer (they are not accessing the front end from the host / which is what it seems in a sense).

    I have even tried on the host computer- to go into the front end and delete the links to the back end table. then did a import of all tables out of the backend. then deleted the backend then did a new datbase split. Made sure that the networked computer were linked correctly to the host backend
    Same results.

    Anybody... Please Help..

    rham

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Security on the back end Is it set write
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    20
    Do I go to tools then to Security on the back end to check? (I'm not for sure.)

    Thanks

    rham

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'm guessing Steve (Myle) is suggesting that you check the netwrok permissions for the file / drive are set to read / write.....
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2003
    Location
    USA
    Posts
    20
    Thanks to all..

    It was the network permissions.

    again thanks

    rham

Posting Permissions

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