Search results

David - Thanks for the help. This is what worked for me: Public Function GetStrConnection() As String GetStrConnection = "Provider=SQLOLEDB;Data Source=MyServer;" & _ "Initial Catalog=MyDataBase;UID=SA;PWD=Password" End Function

I am pretty new to this. I am trying to put together a vba adodb connection string to a remote server. It is the first time I am using adodb in this context. I can get msysobj.connect but how do I format that information into a connection object connection string?

:o:o Computer lock up. Booted and Form works now. Thanks Paul.

Thanks for the response Paul. AllowAdditons is set to True. The query is a select query calling fields in the single table where a record is to be added. SELECT tblStudentRecord.CourseID, tblStudentRecord.CourseDate, tblStudentRecord.Location, tblStudentRecord.Track...

Somehow my form quit working. (?) The form has a series of textboxes that load from code and an add record button that should add a record to the table. When any connected textbox attempts to load, error code 3326 appears. Somehow the dynaset recordset has change to snapshot. The form's...