Search results

Interesting. Even with more than 20 simultaneous connections? This would mean that the limit of 20 connections (which also seems to apply to file services) is no longer valid. Or maybe is only of a legal nature...? Express would be sufficient too for me, I wasn't pointing out a higher version...

@CJ_London : Thank you, I came across the topic again through the mentioned thread and thus came to my question. If it should help to answer my question, I will of course be happy to provide some context: The aim is to use a Microsoft Access application, which requires file and SQL server...

I am writing this question to clarify for myself whether what I assumed so far is really (still?) true. Required services of the 'quasi server' would be file services (SMB) and Microsoft SQL Server (ODBC). The clients would use the services of this 'quasi server' from a Microsoft Access...

Maybe a question of an active firewall on the server (which seems to be a desktop pc)?

From Word 2013 on and newer it is part of Word itself: Field codes: DisplayBarcode (and QR-Codes).

Yes, that is correct.

How is your invoice build? Is it a printed/exported Microsoft Access report, or is it a Microsoft Word document which you create via VBA? In case it is a Microsoft Word document you can do this right easy in Word.

So 'practically' 64-bit it is free too...

Yes. Both, 32-bit and 64-bit versions are free. But 64-bit shows a 5 second nag screen.

Just for info: You can create a COM add-in quite easy with twinBASIC (compared to .NET or other solutions): https://nolongerset.com/create-com-addin-with-twinbasic/

So you want to script all ForeignKeys of all tables in your original database (because in the customers database they are missing)? This seems to be right easy, with the only disadvantage that the script also contains the creation of the tables. However, since the ForeignKeys are at the end of...

In the menu of SSMS (I use 19.3) click "Tools", then "Options", expand "SQL Server Object Explorer" and then select "Scripting". There are the options you're looking for which set the defaults for the mentioned wizard. I think there is no necessarity for screenshots.

Sounds to me like the data contained in the report causes this behaviour in these particular cases.

It should be mentioned that a breaking change comes with the ODBC driver 18 for SQL Server. The connection is now encrypted by default (just in case it doesn't work right away):

Maybe a mouse button has started bouncing recently?

This is usually the case, but I found an 'exception' to this rule a few weeks ago: If the code that is executed by the button contains a 'DoEvents', it is quite possible that the code behind the button is executed more than once 'quasi in parallel'. The first click on the button runs up to the...

Thanks for this really helpful discovery.

Did you check the "SQL Server Configuration Manager" on your SQL Server? Take a look into "SQL Server Network Configuration", choose your SQL Server Instance and activate TCP/IP. Then restart your SQL Server Instance Service and try again.

Thanks for your feedback. I unfortunately overlooked the fact that the thread is so old.

@KitaYama : I expect your performance issue was solved before? Would be interested to know the reason. ;)