Recent content by CedarTree

  1. C

    Filtering not working but Allow Filters = True

    Hello - I have a table as a linked table connected to SQL server. If I open the table directly in Access (not in a form), I can filter/sort. But if I open it in a form (where "Allow Filter = True"), I can't filter or sort??? What am I missing? Thanks!
  2. C

    Multiple similar relationships?

    Yes I tried the drag method with no luck... it's okay for now based on other DB design items.
  3. C

    Multiple similar relationships?

    I'm trying to use the somewhat usable GUI of sql server - Access GUI is much easier but I'm building the back-end in sql server.
  4. C

    Multiple similar relationships?

    Yes, thanks. This would be an alias issue in SQL server. But can I create aliases just using the GUI of sql server or do I need to use T-SQL? Thanks.
  5. C

    Multiple similar relationships?

    Hello - any suggestions on this item please? Thanks!
  6. C

    Multiple similar relationships?

    Hello. Let's say I have a table of colors (red, white, blue, etc.) and another table that has People's names, their favorite color, and their least favorite. I can't seem to set up TWO (or more) relationships between the table of colors to the Fav field and the table of colors and the Least Fav...
  7. C

    Access + Adobe Performance

    Hello - I'm using Access VBA and the Adobe SDK to pull words from searchable PDFs. Works great (most of the time) but with larger PDFs, it seems to hit a performance wall where it will be extracting the same page for a long time. Sometimes, after 2 mins, it will move on. Other times it crashes...
  8. C

    Using DAO to connect to SQL server in Excel

    Okay -- off to ADO I go... Thanks!
  9. C

    Using DAO to connect to SQL server in Excel

    Hi-- any suggestions here please? BTW, I'm able to connect from Excel to an Access DB that has the sql server tables linked using DAO. But I'm trying to skip the middle-man of Access. THANKS!
  10. C

    Using DAO to connect to SQL server in Excel

    Hello - I have a working model to grab data into Access using DAO.recordset from a database hosted on SQL server. Connection string works great. I even have a generic function to grab the recordset as long as I pass the sql statement to the function (see below please). How do I do the same thing...
  11. C

    Connection string for MySQL

    Yes they are a web host / mysql host.
  12. C

    Connection string for MySQL

    Okay thanks will look into…
  13. C

    Connection string for MySQL

    Thank you. Yes that would be worst case but a connection string would be ideal.
  14. C

    Connection string for MySQL

    Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps...
  15. C

    Error 3407 - Record is too large

    I lessened the # of fields (removed superfluous ones and it works now). Thanks.
Top Bottom