Thanks, all. I do try, as do my fellow advocates. It's a great job, and I hope we continue to do it for a long time.

You can look for filestream on tables, which is not supported in Azure  SQL database. The list of things not supported is here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features

I haven't dealt with Access attachments, but I'd agree a separate table is needed. These might be docs in the file system, with a pointer in the Access db. FileStream...

My apologies. I started to reply yesterday and got sidetracked.

Here's my view. I'm not a lawyer, auditor, or regulatory reviewer. Your job is to be compliant with SOX auditing. From...

The formatting of lines was a render issue. Old coding v new coding, and it took time to fix. Despite what you see here, this isn't a high priority item...

I'm sorry you find these hard to use. We've adopted different choices for software over the years, so old posts might reference things that no long exist. It's not practical...

the listener is the SQL Browser. Not on by default, but if you connect to 1433, and you have a local instance running on 1433, that shouldn't matter. You are...

The native client replaces older drivers. This is a few MB in size. Not worth uninstalling. You might not use it now, but you may at some point.

One last thing, you noted "The database should not lose user accounts or logins after the restore from prod backup". Logins are an instance (server) level object, so database restores...

Apologies, corrected the reference.

• Stairway to T-SQL - https://www.sqlservercentral.com/stairways/stairway-to-t-sql-dml
• Stairway to T-SQL: Beyond the Basics - https://www.sqlservercentral.com/stairways/stairway-to-t-sql-beyond-the-basics
• Stairway to Advanced T-SQL - https://www.sqlservercentral.com/stairways/stairway-to-advanced-t-sql

Does this help? https://stackoverflow.com/questions/33998229/vba-mac-connect-to-sql-server-with-actualtech-odbc-driver

Are there always 3 (or less) rows for an employee? Or are there random non-sales/non-office items?

You're really trying to pivot here. You might look at Pivot, though this isn't necessarily...

Out of credits?

Maybe you should write a few questions, Thomas 😉