Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Sharing Problem (2003)

    I have a sharing problem, which I don't know if it can be resolved with the database as it is. The database is on a network, and shared by two people at the moment. A table which they retrieve their information from, is created by a make table query. I understand that they both won't be able to access data while the table is being updated. Once the table is created, should they be able to use the database normally. They reported a problem that they were getting missing information (the where both entering data into a form which had allowed them to use different serial no's). They both logged off, and when I went on the information is there. The database is set to share but they are having problems. Is this because of the 'make table query'? We have someone working on getting the tables on an SQL server, and connecting using ODBC, which I am told will be a more convenient method. But until that happens, we have to sort these glitches out.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing Problem (2003)

    Is this a single database or split front end and back end? The preferred arrangement is a separate front end on each workstation with the back end on the network. You haven't explained the circumstances around the maketable query, so it is difficult to give you any advice. Is the maketable for a temporary table of some kind?
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Problem (2003)

    It's a single database, and the table is a temporary one, which needs to be updated to include retrieved data from another source.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sharing Problem (2003)

    Do you then use that temporary table later on?

    For a start I would split the database. This is mandatory, because when a form or report etc corrupts then you lose all your data as well in an unsplit database.

    Secondly I would make the table a permanent one, just delete all the data in it prior to running the make table query (but change the make table query to an append query). This way you don't get a problem with one use accessing the table and the other user not able to.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing Problem (2003)

    Actually, a better approach is to make the table local to the front end and give each user his own copy of the front end. They can make and delete local tables to their hearts content without affecting any other users.
    Charlotte

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sharing Problem (2003)

    The problem with that is she wants both users to view the make table contents, so creating a table on a split front end will not do the trick.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sharing Problem (2003)

    If the make table query is run on each front end, the results should be the same. Design modifications mean the user needs an exclusive lock. They can only get that with an unshared front end. It isn't extraordinary to have each user run the same routine to create the table on his own front end. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Sharing Problem (2003)

    You are quite right of course. As long as both users create the table on their own front end.

Posting Permissions

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