Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Location
    GA.
    Posts
    23

    Access 2013 run-time

    I am using Access 2013 to develop my program and I am using Sagkey Access 2013 installer to distribute it.
    The program works great on the developing computer but after I distribute it to my clients they
    get Errors ( Function is not available in expressions in query expression )


    Any query that has an Expression or Function in it will not run..
    I'm sure that it is a Reference somewhere but I don't know what Reference handles Functions and Expressions in query.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Are you using any custom functions other than the default stuff in the VBA window, if you are you'd likely have to copy and register the drivers to have your application work. Especially if you're using early bindings rather than late bindings.

  3. #3
    Join Date
    Jul 2010
    Location
    GA.
    Posts
    23
    Quote Originally Posted by rpeare View Post
    Are you using any custom functions other than the default stuff in the VBA window, if you are you'd likely have to copy and register the drivers to have your application work. Especially if you're using early bindings rather than late bindings.
    I can take a copy of the .accdb program and put it on the client computer
    and run it with run-time and it runs great.
    But if I save the program as a .accde and run it on the client computer
    that is when I get errors..

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    If your clients only have the runtime components installed why do you need to distribute the file as an accde file? It seems the simplest solution would be to just distribute the accdb file. I have never encountered this behavior so I am afraid I am not much help.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-13-2015, 02:14 PM
  2. Replies: 1
    Last Post: 06-25-2015, 05:24 AM
  3. Export From Access 2013 To Excel 2013
    By Esmatullaharifi in forum Programming
    Replies: 8
    Last Post: 04-17-2015, 09:40 PM
  4. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  5. Replies: 6
    Last Post: 10-24-2013, 04:58 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