Search results

  1. E

    Question Slow access 2003 search over ODBC SQL Server linked tables

    Ok, one example: Customers form. I have a form for adding/updating/deleting customers. Form display customer data. I have navigation buttons to move forward/backward. If I want to navigate to the customer #1025 in order to update its mail address, I focus on Id field, press Ctrl+F and search...
  2. E

    Question Slow access 2003 search over ODBC SQL Server linked tables

    Yes, that's why I cannot understand why it's so slow. I can access (via LAN) to the SQL Server, and query with no problem. The only time it seems to be slow is when trying to search doing Ctrl+F
  3. E

    Question Slow access 2003 search over ODBC SQL Server linked tables

    Hello, Thanks for your reply. Depends on the form, but for example, I'm testing a form that navigate through a table of 5,000 records.
  4. E

    Question Slow access 2003 search over ODBC SQL Server linked tables

    Hello. I have an Access 2003 database with linked tables (via ODBC) to a SQL Server 2005 database. The application (Access) and the DB (SQL Server) are on different machines. The application (Access forms) works fine: opening, queries, etc. The problem is when you want to navigate to a...
  5. E

    Subforms: Link master fields

    Hi, I'm using Access 2003 I have two tables: T_order and T_order_line. I have one form for browsing T_order records. In this form, I have a subform with data in T_order_line. The subform is linked with the form using "Link master fields" and "Link secondary fields" (the keys in both tables)...
Back
Top Bottom