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.
