How to embed ODBC settings in a file?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Michael Brown
    New Member
    • Jan 2011
    • 6
    #1

    How to embed ODBC settings in a file?

    Hi,
    I have designed an application in Access and I'm linked to existing tables via ODBC connection. It is likely that the users of this application will not have the ODBC connection set up on their computers, it is also likely would not have the rights to do so.

    Is there a way I could embed the connection setting in my .mdb file or any other file for that matter?

    Let me know if any extra information is required.
    Tags: access, database, embed, odbc
    • jimatqsi
      Moderator Top Contributor
      • Oct 2006
      • 1290
      #2
      Yes, I believe the key is in the making of the ODBC connection, not in the programming in Access. When you make an ODBC you have to choose whether it is a File ODBC, a System ODBC or a User ODBC. Each is described on the screen as you make them. I believe what you want is a File ODBC.

      Jim

        Comment

        • Michael Brown
          New Member
          • Jan 2011
          • 6
          #3
          Hi Jim,
          Thank you for your answer, it has helped me considerably.

          - Michael

            Comment

            Previous template Next
            Working...