Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    U.K.
    Posts
    3

    Unanswered: Large distribution of A2K mde file

    We have developed an Access 2000 front end with several linked tables connected to a SQL Server 2000 database.

    The front-end is to go on a network and will be accessed by up to 100 users.

    The front end will be used for data entry and reporting. The PC's will be running XP.

    Should the front-end be on the network or would it be better to have a copy local to each PC ?

    If the mde front-end was on the network what performance issues are there with having multiple users ?

    Thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    why would you want static stuff like forms, code, etc. crawling down your network instead of sitting on the client where they belong?

    you've solved the 100 users problem for the data by moving it to sql serving ...wouldn't it be a tragedy to recreate a new problem with the front-end?

    izy

  3. #3
    Join Date
    Oct 2003
    Location
    U.K.
    Posts
    3
    Thanks izy.

    Putting the front-end on the client was always the most intellectually satisfying.

    I was thinking about the maintenance - updating the front-end when things change - but I guess the network should be able to handle distributing updates.

Posting Permissions

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