time of class 04:54, I am using Access 2003 front end with SQL Server Express 2005 Backend. I found the hard way that in order to access the SQL server backend through DSN(ODBC) connection that the OpenRecordset("CustomerT",dbOpenDynaset,dbseechanges) had to be in place due to an error message stating that I was accessing a sql server table with an identity column. (error 3622) Thought maybe that bit might help. Thanks Bryan
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 322.
