Recent content by Minty

@tvanstiphout bear in mind this was already a SQL server backend, so some of the usual issues with moving to a SQL backend should have already been overcome. However, the difference in connectivity performance between an on-prem SQL server and an Azure one is pretty significant, hence wanting...

We do lots of Azure SQL back end work. Can you post up the actual code used to open the reports, and if possible the SQL of the Access source queries?

To confirm / expound on @sonic8 answer, SQL will cast numbers automatically based on the initial supplied values. SELECT 1/CAST(1.95 as decimal(28,16)) AS WTF, 1/1.95 as Uncast WTF Uncast 0.512820512820512820512 0.512820 Does that make sense?

If you are using SQL server Ver 2019 then I would update everyone to at least ODBC driver 17 and preferably version 18. Even if it doesn't fix the immediate problem, it is much more stable and handles dropped or interrupted connections in a much more elegant fashion. This could be a network...

I'd like to claim some hand in the taking of it, but just nicked of the interwebs I'm afraid.

More like this I suspect Opps double post - the first one didn't register as uploaded. Welcome aboard Neil

More like this type of thing I suspect

The major benefit of SSMA if you are migrating a current live system is to store all the parameters and datatype mappings and easily repeat the operation, during the development phase. It also moves larges chunks of data pretty quickly and provides good reports when things don't work. We had a...

Rather than use the wizard try just specifying a custom paper size. Labels are always a pain to use in Access, until you get them right!

What Version of SQL server and what ODBC driver are you using to connect to it?

Personally, it all depends on whether someone else is likely to look at it later... If they are I tend to be a bit more formal. I do like using AS in a larger query, but also don't bother when I'm debugging and it's going to get thrown away. I also always use EXEC when calling stuff from an...

You can run a T-SQL command on a SQL server without SSMS ever being installed. Just run a passthrough query from MS Access. To reiterate - SSMS is a no different from using Visual Studio to manipulate objects in a (MS) SQL Server database. It's a developer tool for MSSQL Server objects.

SSMS wouldn't be deployed anywhere near a normal end user. I have multiple clients some with multiple databases and none of them have SSMS installed, and wouldn't know what to do with it if they did. It's a developer / DBA tool. It's not uncommon for a whole IT team to only have one person...

You can protect/lock an SP or a function from being viewed in SMSS with a password and encryption. However, an end user with an Access FE to that data isn't able to see those or how they work to produce their results, they are simply data returned as data e.g. views or tables? You are using...

Thank you for continuing to put up with us Jon. Merry Christmas All! 🎄🤶