I have access 2007 database on my system in c: drive. I am doing some queries in this access db and then from MS Excel - I am using data connections - from microsoft query - I am trying to export ms access query data to excel. So, when I go and refresh it, it has to sync data with MS Access.
It is working fine on my PC. I created workgroups on this db too. When I try to send this excel sheet to users, when they try to login, it is looking for database with the path on my system and then returning error. Here is the error:
C:\testdb\db.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are conencted to the server on which the file resides.