Access SQL Server Lessons
Welcome to the Access SQL Server Online Seminar. Total running time is 4 hours, 13 minutes.
- If you download a copy of my database, remember that the password in the database file is for MY online SQL server which you can't have. You need to open the database with the Shift-key bypass and then enter your own credentials for your server in the code module for the MainMenuF.
- In Access Developer 33, Lesson 4, I show how to loop through all of the linked tables in your Access database and automatically reconnect to them if they need it. This uses the TableDefs collection and table attributes which I didn't really cover much of in the Seminar.
- Addendum 1: if you have a yes/no value in Access, it will get changed to a bit value on the server. If you don't specify a default value, you won't be able to delete records. Also show how to use GETDATE() to provide default date/time at the server level.
- Addendum 2:
- 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
Please feel free to post your questions or comments below. If you have a questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!
Subscribe for Updates
If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
Comments for Access SQL Server Lessons
Back to Access SQL Server Lessons