How 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 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.
