0

I used the upsize wizard in Access 2010 to split my database with the table being on the SQL server. I entered this in the autoexec (was macro, I converted it)

Function autoexec()

oConn.Open "Driver={SQL Server};Server=JCPLMSQL01;Database=TestingConnection;Trusted_Connection=yes;"

    DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal


autoexec_Exit:
    Exit Function



End Function

I don't know enough about this to know what is wrong. The error is in the oConn.Open line.

Thanks.

2
Contributors
3
Replies
5
Views
4 Years
Discussion Span
Last Post by AndreRet
0

Which version of SQL server are you running on your server?
Also, you have no username or password in the connection...

0

It is working now. I had some permissions errors. We are using Windows authentication so I didn't think I would need the unsername and password.

Thanks for replying

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.