Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2006
    Posts
    28

    Question Unanswered: Splitting Database

    Would splitting the database allow concurrent updates? Also, I currently have the database set to open on a main form. I don't want other users to be able to view the tables. Would splitting the database allow them to view the tables?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    no
    But What you can do is on startup show a custom menu (switchborad) and get the database to hide the database window

    Hint when finish building the menu's in the menu bar put =1 this will hide the
    file->edit->view->....
    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
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    no
    But What you can do is on startup show a custom menu (switchborad) and get the database to hide the database window

    Hint when finish building the menu's in the menu bar put =1 this will hide the
    file->edit->view->....
    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.

  4. #4
    Join Date
    Jan 2006
    Posts
    28
    Is the No, for them being able to view the tables, or allow concurrent updates.

  5. #5
    Join Date
    Jan 2006
    Posts
    28
    I split my database yesterday afternoon, and this morning had several users state that they could not access it any more. I am guessing it did not allow multiple users, although I thought it did.

  6. #6
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by gerishto
    I split my database yesterday afternoon, and this morning had several users state that they could not access it any more. I am guessing it did not allow multiple users, although I thought it did.
    When you split the database, did you give the end users their copies of the Forms needed? On their workstations, they need the FrontEnd, Forms, Reports etc. and you Link those to the BackEnd (Tables). Did you use the DatabaseSplitter or do it manually?

    BUD

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    how did you split it

    if you split it on your computer did you save the data on you computer or the server

    if it was to the server eg h:\mydata\data.mdb

    has the other user got acccess to that folder and do they have read write access.
    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.

  8. #8
    Join Date
    Jan 2006
    Posts
    28
    I used the database splitter and it was set on a shared drive. I am planning on attempting the split again, because I got back with the users who received the errors, and I don't think it was related to the split.

    My main question is, does this allow concurrent updates, or even access to the database by multiple users at the same time.

Posting Permissions

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