Search results

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...

Depending on how many table objects you have. I would say it's still a little slow. I have an Azure SQL DB I'm working on at the moment - it has 203 tables it opens instantly in both the object explorer and the Explorer Details window. I never use the diagrams so can't comment. Add new column...

Your loop is now creating all the products into one text file, which if I have understood your request, is not what you wanted and not what I suggested. If you need to send them one at a time, your loop needs to include the http: section. I'm not sure I can say this again without sounding like...

Yes, and your loop sends one record at a time doesn't it? Please, please, please, step through your code and watch what it does!!!! Edit: You simply need to move where your loop statement goes to after this line Response = .ResponseText End With

If you always send all the products you don't need the list box, just use your original query without the parameters to restrict its output and loop through it as @CJ_London suggested. The process should simply be Open your recordset of ALL product ID's Loop round it. Finish You already...

Do you ever walk your code to see what is happening? Ask yourself where the follow lines output get used: strWhere = "[ProductID] = " & selectedProductID At no point are you doing anything with this.

@BlueSpruce You have a strong opinion of how this site should operate and what it's apparent "problems" are for someone that has only been here for 5 months. Whilst I agree that some of the technical posts had become too political, there has always been a history of solid debate available...

Be aware that you won't get an elegant capturable error message from Access about the index violation. You'll have to check in the form beforehand for duplication via VBA on a SQL Linked table.