Results 1 to 3 of 3

Thread: Network Use

  1. #1
    Join Date
    Aug 2004
    Posts
    43

    Unanswered: Network Use

    Hi guys (and gals), I'm brand-new to the forum!

    I have 2 questions
    FIRST - I created an access db and installed it on a server. When I try and access the db from a remote location (over the internet) it runs VERY VERY slow. Any ideas??

    SECOND - When creating a form with an autonumber field, the autonumber "appears" once the user hits a key. I'm trying to create a button that allow the user to "cancel" their record and close the page. (Basically a cancel button that won't save the record that the user has started). Any ideas??

    Thanks for your help. I hope that someday I'll be able to get-ya back! ;-)

    Ryan Olivier

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    The standard Access database setup, even on a local area network (Back end/front end configuration) runs slowly with more than one user. I can imagine how slow it must be over the internet. The answer to that is an SQL server for both problems.

    Autonumber is always assigned when you create a record, just cancel it and don't worry about it. The next saved record will skip the cancelled autonumber.

  3. #3
    Join Date
    Aug 2004
    Posts
    43

    Macros

    I'm not really worried about the autonumber, (This will sound stupid), I can't even figure out how to cancel it so that it doesn't save the information. I'm not that hot on VBA, and have been trying to find a macro-function combination that will close the form without saving the information.

    Anybody know?

Posting Permissions

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