Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Acess for multi-users.

    I am new to Access. Done some 4th dimension a long time ago.
    I was wondering how multi-user works with Access. Can I create a dbase, put in on a server and have people access it?
    Do I really need SQL Server if I want more than one person on it at a time?
    What is SQL server anyway?
    [img]/S/question.gif[/img][img]/S/question.gif[/img]

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

    Re: Acess for multi-users.

    Access is inherently multi-user. However, each machine needs a license, which usually means Access installed on that machine. That's also the least network-bashing method of handling licensing. You set the database up to open shared, so that more than one person can open it at once. However, you need to know up front how many people might be in it and how they might be using it in order to know how to set it up in the first place.

    SQL Server is a database server and is nothing at all like Access and certainly nothing like 4th Dimension. If you are new to Access and relational design, don't even think about SQL Server unless you're willing to have someone else build the application.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess for multi-users.

    Thanks for your answer. We have a database project and I have to know everything about Access before Thursday. I have to suggest what we can do in house and what needs to be contracted out, so bare with me if I ask a lot of questions.
    Good to know about SQL servers.
    How about projects? I have been reading about it but it is still not clear.
    What is Microsoft Data Engine (MSDE)?

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

    Re: Acess for multi-users.

    I don't mean to be flip, but I think you'd better contract the whole thing out. Building adequate Access applications requires skill and experience, and from what you say, that doesn't exist in-house. If by Project you mean an ADP, that is even further outside your knowledge than a regular Access database since it is strictly a front-end for SQL Server/MSDE. MSDE is the Microsoft Database Engine, and is a version of SQL Server optimized for no more than 5 users. It has SQL Server capabilities but lacks the management console that is essential for administering SQL Server databases over time.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess for multi-users.

    Thanks for the advise. I need to get a sense of what the techno terms mean before I hire the expert, just to be able to talk in (almost) the same terms.
    One more thing. If I want the database to be on a web site, with people logging in and doing the data entry, printing, queries, all the regular stuff what do I need?

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

    Re: Acess for multi-users.

    Probably and ASP programmer. Definitely a web server.
    Charlotte

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess for multi-users.

    Access run-time doesn't need a licence on a workstation. The developer needs to have the office developer edition for the necessary files (and licence to distribute the run-time files).
    Run time Access also has certain options not available to the full time (specifically for development) so I think it should start a bit faster as well.

  8. #8
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess for multi-users.

    Thank you very much for all the information.

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

    Re: Acess for multi-users.

    No, Access runtime provides the license on the workstation if Access isn't installed. There still needs to be a license, one way or the other.
    Charlotte

  10. #10
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Acess for multi-users.

    I think am now clear, we had a semantics problem.
    Your 'licence' is a registry key.
    My 'licence' is something the user has paid money for.
    Is that correct?

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

    Re: Acess for multi-users.

    That pretty well sums it up.
    Charlotte

Posting Permissions

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