September 10, 2012 at 2:23 pm
I used the Access upsize wizard to split my database. I still wish to use the Access for the frontend and I don't want to have to go to all the computers to setup the ODBC connection.
I have been trying to add some code to the autoexec macro/module in access and the connection fails.
Here is one of my tries, but I have done it a gazillion other ways also without success.
oConn.Open "ODBC;Driver={SQL Server};" & _
"Server=xxxxMSQL01;" & _
"Database=sublistL;" & _
"Trusted_Connection=Yes"
Can anyone help?
Thanks. [Smile]
September 10, 2012 at 2:28 pm
have you seen/read this article?
http://support.microsoft.com/kb/892490
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 10, 2012 at 2:50 pm
I think when I first saw it it was too hard for me to understand. Thought there would be another easier way. But now that I have been trying to do this for days, it doesn't seem so impossible.
About 2/3 of the way down in the article it says,
"When you use the AutoExec macro, call the CreateDSNConnection function, and then pass parameters that are similar to the following from the RunCode action.
CreateDSNConnection ("(local)", "pubs", "", "")"
What does that mean? Am I supposed to replace local and pubs with something else?
Thanks.:-)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply