Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Joliette, Quebec, Canada
    Thanked 0 Times in 0 Posts

    Access limitations (2000)

    I am near a threshold for access my data base, I have to reboot just to modify a query or report. I have compacted and made a new front end data base that imported the original data , queries, etc. Any other suggestions would be helpful. I am thinking of converting my backends to MSDE... would that help ( I have 4 back ends with some 40 tables in all).

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Access limitations (2000)

    You don't indicate what specification limit you are encountering - is it size, number of objects, or some other limit? If it is size, splitting it into a front-end/back-end arrangement should help some, but if the majority of your space is consumed by tables, then that would be a temporary fix at best. Your comment about 4 back-ends would suggest that size may well be the culprit. Unfortunately, going to an MSDE won't help with that limit, as the MSDE size is essentially the same. SQL Server Standard Edition would be your best bet (assuming you have several users) - it would give you a number of advantages, and if you used ODBC linked tables, you wouldn't need to make substantial changes to your front-end.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 37 Times in 36 Posts

    Re: Access limitations (2000)

    I'm not sure I understand what you did. You said you created a new frontend database by importing the data and queries? Do you actually have a split database; that is, a backend with the data and a frontend with forms, reports, and queries?

    How big is your database/databases? I don't understand the comment about having to reboot before modifying a query. If you indeed have a split database schema, then the size of the backend shouldn't matter at all in opening a query in design mode; nor will moving to a different backend database (MSDE or SQL server) provide any help. What error message are you getting that prevents you from opening the query?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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