Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    U.S.
    Posts
    26

    Unanswered: SQL Server or just use Access

    Im not sure if my company needs SQL server?? We currently have our database in approach and want to convert it to access. The largest db file in approach is 11mb. Will Access be able to handle that kind of file size?? i know it handles 2gb but so does SQL Server. What the advantage of using SQL Server as far as file size goes.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb File size

    Access can use ODBC links to several back-ends, so file size is never usually a problem.

    Perhaps more importantly the question is about what environment - How many concurrant users / You budget etc.

    Thats my opinion anyway!

    Here's a good paper you may find interesting

    http://www.fmsinc.com/tpapers/genaccess/DBOD.asp
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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