Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: linked tables and dao recordset


    i'm switching my access db to use linked tables and mysql as a backend.

    But since i'm using linked tables my vba code (with some custom querys) is not running anymore, any idea what could be the problem?

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    With no code to look at and no explanation of what the problem actually is, I doubt anyone would have an idea.

    Perhaps you could detail the actual problem just a little more than not at all, perhaps someone can help?!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    When you link a table to a backend such as MySQL or SQL Server, a lot of times the table links in as "dbo_xxxx". You may need to rename the linked table after linking it in or redo your coding to capture the dbo_.

    I personally create all my MSAccess tables as dbo_xxxx in anticipation that when I eventually link in the actual SQL Server tables, I won't then need to rename the linked table or redo all my code.

    Otherwise it could be a multitude of other problems (your code, permissions, etc...) and as StarTrekker stated, you'll need to give us more info.
    Last edited by pkstormy; 03-30-09 at 14:51.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts