I have a data-entry program that uses access as a front-end and SQL Server as the back-end via a linked table that uses ODBC specified on my machine ... the program and forms and everything works well; but thinking ahead, if I want to give this program to someone who does not have an ODBC for the linked table set up on their machine but does have all the proper security settings, how would I somehow embed something equivelant to the connection string that ODBC uses in the code of the form for this to work ... I haven't a clue how to create this type of connection string and attach it somehow to the code behind the form so that a physical ODBC setting won't be needed. Any help would be appreciated!
Thank you,
Joe
Thank you,
Joe
