Search results

  1. S

    Solved Managing SQL Server Logins in MS Access Frontend

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

    Solved Managing SQL Server Logins in MS Access 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...
  3. S

    Solved Save Screenshot to Table

    Yes of course :) Credit goes primarily to arnelgp
  4. S

    Solved Save Screenshot to Table

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

    Solved Save Screenshot to Table

    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?
  6. S

    Solved Save Screenshot to Table

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

    Solved Save Screenshot to Table

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

    Solved Save Screenshot to Table

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

    Solved Problem Connecting to SQL Server

    Yes that was the Problem, thank you :)
  10. S

    Solved Problem Connecting to SQL Server

    I can show you the code
  11. S

    Solved Problem Connecting to SQL Server

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

    Solved Problem Connecting to SQL Server

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

    Solved Problem Connecting to SQL Server

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

    New Member

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

    Solved Error Loading Ribbon

    Thank you both very much 😊
  16. S

    Solved Error Loading Ribbon

    I am using the 365 Version of MS Access, but i think the function that i use for making the ACCDE is a old. Are you using this Version aswell?
  17. S

    Solved Error Loading Ribbon

    Yes, I understand now, and it's working perfectly for me. Thank you very much! :) The idea of deleting it is clever as well. My Idea was to created another ribbon in the USysTable that displays the standard and then I just switch back and forth. If you're interested, I'd be happy to help you...
  18. S

    Solved Error Loading Ribbon

    Okay, I understand what you mean haha; it seems a bit unconventional, but I get it, i explain. I want to create a completely secure ACCDE copy of the current database with a single button click and distribute it. I've set up everything in this form, which is exclusively for me (the developer) to...
  19. S

    Solved Error Loading Ribbon

    Okay, it seems like a better solution for sure, but I'm still encountering the error on the second click. However, I've found a workaround for this error buuut the Problem is still there: Dim FlexName As String FlexName = "rbbBlank" & Now() Dim XML As String XML =...
  20. S

    Solved Error Loading Ribbon

    Yes, of course. The objective is to create a completely secure ACCDE file, and as you'll see, this is the final step. I've copied over all the relevant elements to ensure the form functions correctly. However, the bug is still present.
Back
Top Bottom