ODBC Timeout Problem
Hi, I am calling a SQL Server stored procedure from my MS Access program and am getting the ODBC timeout error. When I run the stored procedure from SSMS, it executes in less than one second. I am passing no input parameters and the results are not returned from the stored procedure - they are written to a table instead. How can I avoid the timeout error? Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command connString = <all the usual stuff> cnn.Open (connString) With cmd .ActiveConnection = cnn .CommandType = adCmdStoredProc .CommandText = "usp_GetUnbilledItems" .Execute ---Times out here. End WithHow to create SQL query against Access database?
Simple question from a n00b here. I've connected the Access application to a local copy of a database and can see the tables; now I need to make an SQL query against one of the tables. When I click on "View" in the ribbon, there's two choices: Datasheet View and Design View. I'm expecting a third choice, SQL View, but I don't see that option. Am I looking in the wrong place for SQL queries?Access and SQL Server with Column Encryption
I've been asked to turn on column encryption on our Sql Server. We use Access 2019 as the front-end connected to SQL tables. The forms are bound to the tables. I am having a heck of time getting this to work. So far I have set-up column encryption, the proper keys, certifcates and the connection string to use column encryption. I can view the encrypted columns, unencrypted in Access, but am unable to sort, update or run any queries based on the encrypted column. "....The encryption schema for the columns/variables is (encryption_type = "DETERMINISTIC", encryption_algorithm_name = "AEAD_AES_256_CBC_HMAC_SHA_@%^", column_encryption_key_name = 'CEK_Auto1", column_encryption_key_database_name = 'TEST') and the expresssion near line "1" expects it to be (encryption_type = 'PLAINTEXT') (or weaker) (#33299)"
Problem to migrate simple Access mde app and Microsoft Sql Database to another PC
Hello there, Im struggling to move an old Access app, which runs on a windows server 2003, to my Windows 10 PC, The app is run from the Server desktop via mde file and is connected to a microsoft SQLEXPRESS database installed locally on the server, I installed locally on my pc windows 10 Microsoft Sql express, and changed the hostname of my PC setting "SERVER". I can access the tables and the database seems to work, but when I launch the "example.mde" file from my computer the application fails and cannot find the database asking me for the path.. if i click continue with trusted authentication it ask me again for every move i make .. I don't know how to specify the data source or connection string for the database on the new machine, I believe this is about the ODBC driver, attached the error I get. https://i.stack.imgur.com/ZWzme.png Thanks in advance for the helpAccess 2019 #Deleted Table status (Field NVARCHAR)
Hi, There has been an issue regarding Access 2019 displaying #Deleted status on certain table, for only certain windows user profile. Based on my analysis: 1. This happen to only certain user profile. If I login into the windows using another profile and open the table, the data will be normally displayed. 2. This table are linked table with SQL server 2016, so I have check and find that the table have NVARCHAR field. I try to change the field type to VARCHAR, refresh the table link, then the data can be viewed again. Current Solution: 1. Delete the user profile and login again. Solve the problems but not sure if it will happen again in the future. 2. Installing Access Runtime. Solve the problems but at the same time i can't debug the program if there something wrong with it. Does anyone have any idea what happen because i am really lost right now.
Problem with list box selecting individual records
Hi, I'm currently building a database with a 'master' form that I want everyone to use instead of meddling around in the tables and such. I've got a couple of sub-forms opening up from here, including new record and edit record. The problem lies with edit record, as I have made a list box to display the results from a search box. The results show up fine, and all records from each client are visible. However, when I go to select a specific record, it defaults to only one record per client. As most clients have multiple instances of software/hardware, it doesn't allow me to open any of the alternative records, only one record per client. I'm using a button to open the edit data sub form, and the code I have for the on click event is: DoCmd.OpenForm "EditData", , , "[Client_Database.Client]=" & " ' " & Me.EditRecordResults.Column(0) & " ' " The EditRecordResults is the list box, and the after update code I have for the list box is: EditRecordButton.Enabled = True EditRecordButton is the same button I have the on click event for. Any ideas what could be causing this? I'm not sure if the event code causing the issue, or if access's default list box settings are limiting my options, although I don't know how to change these either. Any help would be greatly appreciated!
“Operating system is not presently configured” error with Access ODBC
I get the following error when I try to connect to Microsoft Access Database via Python. The code has been working all this time and only started popping the error today. Can someone please guide me what may be the problem occurring now? I tried doing this https://stackoverflow.com/questions/63899661/operating-system-is-not-presently-configured-error-with-access-odbc even after removing the “Office 16 Click-to-Run Extensibility Component 64-bit Registration” my problem isn't getting solved. import pyodbc as pyo import os #print(pyo.drivers()) filename='//MCISERVER1/TestData/access/Proof.mdb' full_file=os.path.abspath(os.path.join('data',filename)) print("opening access") Driver='{Microsoft Access Driver (*.mdb, *.accdb)}' access_driver=['MS Access Database'] try: cnn=pyo.connect(driver=Driver,dbq=full_file,autocommit=True) except pyodbc.Error as ex: print("Error connecting") cursor=cnn.cursor() sql="select * from [ERT ITRON] as e where e.SO='7888'" cursor.execute(sql) for row in cursor.fetchall(): print(row) print("success") cursor.close() cnn.close() print("connection closed")
Adding a New Record in a Linked Table Causes Error Message
I have connected an Access table to a table in SQL server and the table values can be updated without any problems in both SQL and Access. However, when I try to add a new record in Access, I get the error: "[SQL Server] Cannot insert explicit value for identity column in table 'Table' when IDENTITY_INSERT is set to OFF. (#544)" I have checked that the composite key and foreign keys have valid values and I can insert the same values from the SQL side with no problems. I've read that it is possible to toggle IDENTITY_INSERT, but I don't see how that is possible since there is no way in Access to edit the SQL code that links the tables together. Any ideas what might be going wrong here?
