Maintain Record Location When Navigating Through Forms

  • Hi,

    I am using an Access Project file as the front end to a SQL Server 2000 Database.  

    There are a dozen or so forms that allow users to manage their work.  I have created some global vb methods for navigation from form to form. The navigation methods transfer properties from the closed form to the newly opened form:  record source, filter, order by, and record location.

    As the database has grown larger there has been a slow down in navigation.  It some times takes up to 2 seconds to move from form to form and the users are getting frustrated.  Part of the slow down also is the fact that each form reconnnects to the record source on open.

    I am using this type of navigational method because I am trying to emulate the user's previous system which was FileMaker Pro.

    My question: is there a better way of accomplishing the navigation and property maintainance?

    Thanks very much,

    Harold

     

     

     

     

     

  • This was removed by the editor as SPAM

  • Are there any reason why you cannot simply switch to unbound forms? If not, are you binding your forms to tables or to views? If you can make a view and bind your form to the view. try not to use as much dynamic SQL and instead use more saved views and stored procedures.

    David

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply