Results 1 to 3 of 3
  1. #1
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Apr 2014
    Posts
    410

    After Refreshing Linked Table the data will no longer display with date formulas / criteria

    So not sure why this is but the linked SQL Views NOT refreshed still works with the Date format ####-##-##.

    I believe it used to be ##/##/#### as the data formula / criteria such as Month(Date) or DateSerial or DatePart worked but now it doesn't only after refreshing the links.
    I think they have changed the date format on the SQL tables. I'm seeing the ####-##-## in the SQL View results.

    Strange thing is another Access file linked to the same SQL Views still works but AFTER refreshing them in another database it does not.

    Any ideas / suggestions?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What are SQL tables? If I recall correctly, an Access Date type does not play well with SQL Server Date type. Your queries should format dates as text and in the proper format.

  3. #3
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Apr 2014
    Posts
    410
    ?
    What are SQL tables?
    sorry, I don't understand your question.

    I am using Access to link to SQL Views, where the SQL Views are queries of SQL Tables.

    For instance, SQL Table named attribute.PersonMembership, lookup.MemberTypes.
    SQL View links the two tables that produce member types for the memberships by personid as an example.

    There's a PaymentDate and an EndDate (when the membership ends for the person for a member type).

    The PaymentDate and EndDate, I believe were formatted as ##/##/#### since any of the data formulas in Access query worked.
    And it still does work EXCEPT when the Linked Tables are updated.

    I don't understand how this is possible.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-30-2015, 10:38 AM
  2. Replies: 5
    Last Post: 02-10-2015, 04:37 PM
  3. linked in table need refreshing in backend?
    By vientito in forum Programming
    Replies: 3
    Last Post: 10-16-2014, 08:33 AM
  4. Linked tables and refreshing
    By offie in forum Import/Export Data
    Replies: 1
    Last Post: 06-20-2013, 01:42 PM
  5. sub form no longer linked to combo box
    By gbmarlysis in forum Forms
    Replies: 1
    Last Post: 03-04-2012, 12:25 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