Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Location
    Budapest - Hungary
    Posts
    12

    Cool Unanswered: Database with clients in different Countries

    Hi,
    My favorite User has an idea to create MS Access Client/Server database. He needs more then 35 tables, 25 reports and couple of forms to edit transaction records (15000 record / year ).

    The server side of this program will be in Hungary and clients will be in Nederland, Germany and Hungery too. The number of users will be 25 and average of concurent loggin will be 4-6 user.

    My suggestion was that, He should create SQL 2000 database and create MS Access 97 client, which will be use server side stored procedures to manage any data manipulation or data selection.

    Could you send me some information about similar project or about performance tuning in this case? Do you have any idea to use some other tools? They have a very short time to develop this application.

    Thanks,
    Attila

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Sounds like you need to go a little more robust than Access.
    I suggest SQL Server with a web front end.

  3. #3
    Join Date
    May 2002
    Location
    Budapest - Hungary
    Posts
    12

    Smile

    Thanks a lot for your help. I agree with you.

  4. #4
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    81
    How would you set up the web front end? Html? XML? Any good aps to design webpages connected to an sql server? How would reports be generated?

    If you had larger distances - say one office in the US, one in the UK and one in HK - could you use just one sql server placed say in UK? Would this require some "super connections" or could a normal, say 2 mbit/s, internet connection do?

  5. #5
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Ideally, the web server should be in the same location as the database server. The power of using a web front end is in that the database calls are done by the web server. So it doesn't matter where the users are. The users send 'instructions' to the web server through their browser.

    The language used for creating the web pages depends on your web server software, and what you prefer to use. Just HTML cannot do database calls, so you can't use that, but HTML tags are still used in the chosen language.

    The most pouplar options are: CGI, PHP or ASP (only for NT/Win2000 servers)

    Hope this clarifies it for you....

Posting Permissions

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