Recent content by Spalle

Okay, I see I'm not the only one with this problem. Thank you all for your help! I think I'll try to find a workaround, or I might just close the frontend.

Hello everyone, I am currently working with a SQL Server backend that is connected to a Microsoft Access frontend. The frontend dynamically creates tables and queries as needed, so these objects are typically not stored permanently. I set it up this way to ensure that not all users share the...

Yes of course :) Credit goes primarily to arnelgp

Okey i got it working, thank you all very much :)

It doesn't have to be this complicated! I have a linked table in the database where the field is an OLE field; there's no need for a server connection here. Do you know of a simpler approach?

Yes, this saves the screenshot. That was the initial step. Now, I need to save this screenshot into a table. How can I accomplish that?

The code is no longer functioning properly, at least not for me. The initial issue arose when the screenshot tool was triggered to open unexpectedly. I managed to address this by incorporating segments from my previous code. However, the second problem persists in the form of an error.

Hello, i want to save a Screenshot to an OLE Field (varbinary on the server). I have come this far: Private Declare PtrSafe Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Const KEYEVENTF_KEYUP = &H2 Private Const...

Yes that was the Problem, thank you :)

I can show you the code

Alright, I've managed to find a workaround for the error. I believe the issue stemmed from my connection to the database using Microsoft Authentication, whereas my coworkers used a password. To address this, I created a loop that iterates through all tables, deletes them, and then recreates and...

Yes of course, It says: Error while connecting SQLState: S1000 SQLServer Error:0 Microsoft ODBC SQL Server Driver(Cannot generate SSPI Context i think it is this error on english

Hello Everyone, I am currently facing an issue with the ODBC connection to my SQL Server. While it functions perfectly on my personal computer, it encounters difficulties on my coworkers' PCs. They have successfully set up the ODBC connection on their machines, and creating a new database and...

Haha, i will do my best not to go crazy :)

Thank you both very much 😊