Results 1 to 2 of 2
  1. #1
    BI4K12 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    1

    Question Date picker


    I have 2 applications that link to SQL tables. The only difference is that 1 is local to my PC and the other is accessed via VPN. The application via VPN will not work with the date picker. Fields that are date or datetime will not display the date picker even though Design mode show date picker selected.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    Access is not designed to work across a WAN.

    If your VPN is of sufficient bandwidth & speed that Access thinks it is on a LAN it might work.

    To trouble shoot - temporarily locate that non-working table on the local PC - - and see if it does then work. If it does - then you can be 100% certain it is the vpn and not any other issue.

    There probably isn't any fix. You might consider some work around that writes the distant table to a local table as part of initial application start up or something like that.

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

Similar Threads

  1. Date Picker?
    By gazzieh in forum Forms
    Replies: 9
    Last Post: 02-09-2013, 09:35 AM
  2. Time picker for Access 2003
    By Thiyagu in forum Access
    Replies: 1
    Last Post: 03-24-2010, 06:36 AM
  3. Access 2003 - how install MS Date Picker
    By alexcalgary in forum Forms
    Replies: 3
    Last Post: 05-20-2009, 09:12 AM
  4. Access Runtime 2007 Date Time Picker Vista not working
    By sailinxtc in forum Programming
    Replies: 0
    Last Post: 09-17-2008, 12:56 PM
  5. Microsoft Date and Time Picker 6.0
    By That Crazy Hockey Dood in forum Forms
    Replies: 0
    Last Post: 07-25-2007, 03:22 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