Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Database Design (2k)

    Bit of a general question here.. rather that specific code...

    What do people do when they have the requirement to CREATE records in 2 different locations...

    My current setup is a front end on individual machines, and a back end on the server.

    If 2 users create records at the same time, i believe that creates an 'opportunity' to crash, and this has happened to us.

    Now i could create some sort of complicated code, that only allows 1 person at a time to create records, but thats not what the users want.

    So.. the questions i have are:-

    a) Is there a way in access to allow dual entry to a recordset.

    [img]/forums/images/smilies/cool.gif[/img]Is there a better package than access that allows this functionality. or, perhaps, what do people do when they grow out of access, and go up in the world to a better database package without access's quibbles.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Database Design (2k)

    a) Perhaps I've been lucky, but many of my databases are used by multiple users doing data entry simultaneously without serious problems. Admittedly, the number of users cresting new records is never large, but then, Access isn't intended to work with large numbers of users.

    [img]/forums/images/smilies/cool.gif[/img] SQL Server is the "big brother" of Access. It can handle a larger number of users and higher data throughput, and it has robust security. SQL Server is a server-based database management system, it does not have an interface for end users. You can use an Access frontend, or a compiled application, or a web interface to view, enter and edit data.

    Oracle is another well-known server-based database management system; it is very powerful but requires qualified personnel to keep it running.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Database Design (2k)

    Hans..

    By design, do you believe Access is designed to allowed multiple users to enter data at the same time ?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Database Design (2k)

    Yes, in a limited number. It works well with up to 5 people doing data entry and, say, up to 10 others merely viewing data. Larger numbers are possible, but performance goes down quickly.

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

    Re: Access Database Design (2k)

    I'm not Hans, but I've been programming databases for nearly 30 years and have worked with Access since it was introduced in 1992. <img src=/S/granny.gif border=0 alt=granny width=20 height=20> Yes, it is designed for multiple simultaneous users. What prompts your question?

    There is a great deal of misinformation out there (particularly in IT departments) about Access. It is a rich and powerful tool, but it can also be use to write badly designed applications, just like any other language. If you search this forum, you'll find plenty of testimonials from professional developers who create and maintain Access systems with tens or hundreds of users. Every situation depends on the specifics, so a general answer doesn't really give you very much.
    Charlotte

  6. #6
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Database Design (2k)

    This article from FMS Inc has a good examination of some of the issues raised here.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access Database Design (2k)

    >>If 2 users create records at the same time, i believe that creates an 'opportunity' to crash, and this has happened to us.<<

    Exactly what do you mean by "crash"? That is, did Access come to a halt on either or both machines, or perhaps one of the records just didn't get added? And does that routinely happen or did it just happen once?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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