Moved passwords to a global module to make them easier to update
Added a TimerInterval change to the Main Menu On Load event
You will need the dbSeeChanges option if you use a Recordset to a linked table on SQL Server
More with SQL Server not liking Yes/No fields. Not only will you not be able to delete them as in Addendum 1, but they could potentially lock your whole table. So, I'll show you how to remove NULL values with an update query (instead of just deleting them like I did in Addendum 1), set the Allow Nulls property on the server, set the default value on the server and in your Access forms, and other stuff.
How to change text throughout the table with the REPLACE and CAST functions in SQL
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
Access SQL Server Lessons.