User Profile

Collapse

Profile Sidebar

Collapse
Peggy Frazier
Peggy Frazier
Last Activity: Apr 26 '11, 11:54 PM
Joined: Apr 20 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Peggy Frazier
    replied to Trouble using select query with linked table using ODBC to link.
    in Access
    I really need to get this going as quickly as possible. Does anyone know of tutorials on writing SQL strings? Or can you provide a resource (s) that I can work with to get the SQL written? Many thanks!
    See more | Go to post

      Leave a comment:

    • Peggy Frazier
      replied to Trouble using select query with linked table using ODBC to link.
      in Access
      Thanks for responding! I could see that Access was trying to bring all the data in locally when I tried a smaller table.

      I looked up information on pass through queries but could not figure how to write the query. If I want to pull all fields from the table, do I have to list them individually or is there a way to write the query to pull all?

      The database is Quikbooks Point of Sale and I do not know the type....
      See more | Go to post

        Leave a comment:

      • Peggy Frazier
        started a topic Trouble using select query with linked table using ODBC to link.
        in Access

        Trouble using select query with linked table using ODBC to link.

        I am using Microsoft Access 2010 and attempting to use a query to pull select data from a linked database. The link is via ODBC.

        My connection with the database is fine, I have successfully pulled data from smaller tables. The table I am querying contains approx 50k records. When I write a query to pull all records, Access crashes.

        I have attempted to use criteria to pull smaller chunks of data (i.e. by date) but...
        See more | Go to post
        No activity results to display
        Show More
        Working...