Search results

@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! 🎄🤶

Have you got any of the form formating set that will mess with anything you set - also try the load event.

I agree with @DaveMD that a windowing function in SQL server and suitable indexes would probably speed this up further. The windowing functions are an absolute winner for this type of query. If you run the current query directly in SQL server, you would be able see the execution plan which...

In my experience (especially with large tables) the joins will be more efficient than the In() clause. If you look at the query plans you will probably see a difference in how it is gathering the results.

My laptop generally sits at about 25-30% memory usage. But some programs will resource hog. A local SQL Server itself is notorious for grabbing as much memory a it can.

Just to confirm I am using the following version : SQL Server Management Studio 22.0.0+103.11205.157 SQL Server Management Objects (SMO) 17.100.87.0+faf3df03cb29335d001e03431e8b1fc042928c03 Microsoft T-SQL Parser...