Results 1 to 2 of 2
  1. #1
    superfury is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jun 2011
    Posts
    12

    Question Access 2010: Frontend with VBA and backend change breaks VBA form calls (onLoad etc)?

    When I have a frontend with VBA (for table additions etc) and a backend (all tables except Switchboard Items), when i change from my test-backend (USB) to the realtime-backend (Network drive/directory) the tables work, but all VBA calls (events like onLoad etc.) break (i get an error message). The only way I can fix it atm is by using the Compress and repair database, which restores the links between VBA and the forms etc.



    What causes this to happen? Is it a known bug in Access 2010?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    What is the error message?
    Do you relink the tables? You must else how could the tables work?
    I don't have 2010.

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

Similar Threads

  1. Passwording frontend / backend Access 2010
    By erkwong in forum Security
    Replies: 0
    Last Post: 01-30-2012, 01:28 PM
  2. Replies: 1
    Last Post: 01-12-2012, 09:43 AM
  3. Replies: 1
    Last Post: 01-01-2012, 12:08 AM
  4. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  5. Record Check on Form OnLoad
    By tramp82 in forum Forms
    Replies: 10
    Last Post: 10-19-2011, 07:19 PM

Tags for this Thread

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