Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Redwood City, California, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .MDB, Compressed Folders & TermServer (2000)

    An Access 2000 application is installed in a compressed folder on a Windows 2000 SP1 Server running Terminal Services. The primary database is a little over 400MB (I don't know how much of that is tables). Is this likely to be a problem?

    In general, is it reasonable to put a shared Jet database in a compressed folder?

    In general, is it reasonable to put a shared Jet database on a server running Terminal Services?

    Thanks

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: .MDB, Compressed Folders & TermServer (2000)

    In my opinion, you don't ever want to run a database in a compressed folder - your are constantly opening and closing pages in it when anyone is running the database. On the other hand, we have had decent luck in running a database using Terminal Services - much better than you get with RAS for example.

    On the other hand, I think you want to look long and hard at any Jet database that has grown to 400MB. That usually means it is in serious need of a compact and repair. You should also look at splitting it between a front-end with queries, forms, reports and code, and a back-end with just tables. And if your tables are that large, you may want to split your tables up into different MDB files too. That size database is much more suited to SQL Server or Oracle or another powerhouse database. You can still use the Access front-end with ODBC connections to the back-end. (FYI - the maximum size an MDB file can be is 2GB in Access 2k) Hope all this helps.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Redwood City, California, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: .MDB, Compressed Folders & TermServer (2000)

    Thanks, Wendell.

    The database is in a vendor supplied application. The 400MB DB may be mostly a front-end. There are other DB's in the folder. I don't have that much visibility about what is in which DB. I know I cannot change the placement.

    I understand that it is worse to have the compressed folders for most aspects other than disk space. I don't know how much worse. I am hoping that someone would have experience to share about whether to just expect a performance hit or some kind of failure.

    Joe

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

    Re: .MDB, Compressed Folders & TermServer (2000)

    Wendell isn't talking about performance hits, he's talking about disasters due to data corruption. I've never seen any recommendations for running a database from a compressed folder.
    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
  •