Results 1 to 3 of 3
  1. #1
    Avizan05 is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    8

    Exclamation Error on Refresh


    Click image for larger version. 

Name:	Error1.jpg 
Views:	15 
Size:	37.7 KB 
ID:	16580

    Hi All,

    I am new to access. I have developed an application using access 2013 and deployed it in my working place(with some help from our forum members).
    I have split the database and shared to FE to multiple PC and keep the FE in main PC(my work place doesnt have server and so i have shared using LAN - Cisco 892 router).Multi User is working fine but when i refresh the form using the refresh button on the form(which uses Build-In Macro to refresh). I am getting the Error Message(I have Attached it) and Application Close. But other functions like open of forms and search function are working fine. I am not sure why this happens.
    Note: None of the system have Access 2013. So i have used runtime Access 2013.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    If the macro was created with 2013 then there should not be a problem using 2013 to run the macro, runtime or otherwise. Perhaps it is not the Refresh but something else the macro is doing that is not available during runtime. For instance, you cannot open a form in design view or open a query object during run time. These actions require the full version of Access and access to design time features.

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    164
    Look like a Access Library issue. Open VBA module window , in tools Refrences Select Microsoft Active X Data object 2.7 and Microsoft access 12 object.
    If not work than Try it on a system having Access 2013 on both client and sever side.

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

Similar Threads

  1. Replies: 13
    Last Post: 02-04-2013, 04:08 AM
  2. Replies: 1
    Last Post: 07-13-2012, 09:13 AM
  3. Replies: 4
    Last Post: 03-26-2012, 12:45 PM
  4. Access 2010 Refresh VS Refresh ALL
    By Snwboarder1982 in forum Access
    Replies: 1
    Last Post: 09-09-2011, 04:07 PM
  5. Error excel refresh from access
    By goyal in forum Access
    Replies: 0
    Last Post: 06-10-2009, 10:59 AM

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