I have a MS Access database (mdb) that is linked to SQL Server Express 2008. There is only 1 table currently in SQL Server. I run a couple of queries that either append or update information from the table in SQL Server to the Access database.
My client has 1 full version of MS Access 2010. The rest of the people in the office use Access 2010 runtime to use the application. The person with the full version of Access can run the queries to append and update the data to the Access database. The append/update queries do not run for the people with the runtime version.
I have removed all error handling but still do not get an error message.
Is there any reason runtime would not be able to run queries that adds/updates information from SQL Server to Access?
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…