Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    11

    Unanswered: MS Access database

    Hi,
    I've writen an vb application wich uses an access db. I am working on remote machines by accessing the data from access db which is stays on server. the remote systems access the db with the application I've wrote, in the same time they are performing modifications like adding, updating and deleting records. The problem is that sometime the windows crashes on the computer accessing my remote db. I think the problem is that the access db is on the server and more remote apps trying to modify it in the same time, and access doesn't support this so good. Please give me some advises to try to avoid this problem. I am using permanent open connection and recordset. Is there any solution for avoid this problem?

    Thank you very much!

  2. #2
    Join Date
    May 2006
    Posts
    1

    Share db

    Share db in data and application part.

  3. #3
    Join Date
    May 2006
    Posts
    11

    MS Access Databas accessing

    Can anyone help?

  4. #4
    Join Date
    May 2006
    Posts
    11

    MS Access database

    I used map drive for share database

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sabitha BS
    Can anyone help?
    sure, but you know what, you will have a better chance getting an answer in the appropriate forum

    this forum is New Members & Introductions and very few people look in here to see if there are any unanswered microsoft access questions

    i'm going to move your thread to the access forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    May 2006
    Posts
    11
    Thanx for ur help

  7. #7
    Join Date
    May 2006
    Posts
    11
    No one knows this solution?

  8. #8
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    I have only limited knowledge about the implecations of networks. I've been running several shared access d/b's for years without any problems. But basic points to note (if you're not already aware):
    - I only have 4/5 users (I understand Access has a problem with too many users say 10+)
    - D/B's must be split into front/back end. If you try and share the same front end it will work but it will ultimately end in tears. So distribute the front end locally
    - Only allow users to edit data through forms
    - use pessimistic locking which ensures that only one user at a time can edit the record.
    - you mention recordsets. I'm not sure how you lock records with recordsets (but I'm sure somebody does!).

    Is your problem with crashing replicated on other users PC's ? If not then I would question your windows setup rather than the Access d/b.

    hth
    Chris

Posting Permissions

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