Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    23

    Errors when they generate their reports at the same


    We have an application in Access 2000. The application and the data base are on the server, accesed through the network. There is a group of employees that accesed it at the same time to prepare their warehouse's reports. We have problems when they prepare their reports at the same time, they get errors in their reports. How can we correct this situation without leaving the data base in the network and installing a copy of the application on each computer? :?:

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    To get your users' reports to stop tripping over each other, you need to get them running in separate instances. Right now, they are really running in the same instance.

    It is a long-standing best practice in Access to split the application between a back-end with the data tables and a front-end with the code, macros, forms, queries, and reports in a front-end, and to deploy separate front-end instances for each user.

    If you are very concerned with maintaining the front-ends (which I can see if you expect there to be a fair amount of revision/new development in the near term), consider using a product like this:

    http://www.frontend-loader.com/

    It facilitates version control, and makes sure that your users are always working from the most up-to-date front-end file.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. dialog box errors in report
    By Jane in forum Programming
    Replies: 0
    Last Post: 11-20-2008, 01:06 PM
  2. Access 2002 Front-End Inconsistent Errors
    By janetb in forum Security
    Replies: 1
    Last Post: 07-28-2008, 12:17 PM
  3. Generate Image
    By dbman in forum Import/Export Data
    Replies: 0
    Last Post: 01-31-2008, 10:46 PM
  4. Need Help on reports
    By MeehPhill in forum Reports
    Replies: 3
    Last Post: 07-31-2006, 11:51 AM
  5. Replies: 11
    Last Post: 03-16-2006, 12:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums