MS Access Runtime with SQL Server Express
Posted on 2015-01-05
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?
Any help is much appreciated.