Results 1 to 4 of 4
  1. #1
    SemiAuto40 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41

    Linking Table Manager apparent difficulty effecting query speed dramatically


    I have a split database and started having problems after a new better faster server was installed. But I can't totally blame the server because when I relocate the main table 'tbl_Sample_Login' on to another network location/drive my personal drive H: then I get the same problem!!!

    I rebuilt the query one field parameter at a time and ran itagainst the back end. All resultsreturned quickly UNTIL I added the most important parameter and that was thedate range to get the last 7 days of the rest of the stuff.

    However when I use a WHERE statement on my short date format...
    "WHERE(((tbl_Sample_Login_table.LoginDate)=Dat e()-7))"
    (where I want to get the subset of records that are from thepast 7 days only). BTW, the fieldLoginDate is a short date format.
    It seems to me as though the query itself in Access frontend is put together, converted to sql, or something at the front end Accessprogram. Is there some setting perhapsthat I could have jacked up with Access?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Could there be some TIME component messing things up? http://support.microsoft.com/kb/q130514/en-us

  3. #3
    SemiAuto40 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41
    My query is in my original post. The field in the table is a "short date". It has been working for a couple of years.. so something happened with Access or my network when they replaced the server with a better one. I have relinked the tables. I have located the main table on a network drive H: in my case and have the same dreadful performance. Other network functions and queries operate OK. This is a big deal for me.
    Thanks.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would think the WHERE clause would be something like: "WHERE(((tbl_Sample_Login_table.LoginDate)>=Da te()-7))"
    It does not explain your speed issue but I was curious.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-28-2013, 12:32 PM
  2. difficulty performing a query
    By fabiobarreto10 in forum Queries
    Replies: 2
    Last Post: 12-10-2012, 07:36 AM
  3. Speed up linking tables when front end is opened
    By snoopy2003 in forum Programming
    Replies: 6
    Last Post: 03-19-2011, 01:01 PM
  4. Linkes Table manager
    By nikoo56 in forum Access
    Replies: 1
    Last Post: 08-26-2010, 07:42 AM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 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