Problem Updating to MS Access Database in Windows 7 machine connected through unc path
Posted on 2015-02-05
I have a application coded in VB 2008 & MS Access for database.
I have used UNC Path in my application to connect to Access data file.
Everything was working fine till I was using Windows XP as OS for my Database server.
But after updating my OS to Windows 7 from Windows XP I started receiving Oledb Exceptions saying "Operations must use an updateable query" while Updating of record.
The application is running on several PC's in the network using common Access database file & also they have windows xp on some machine & windows 7 on some other machines.
There is no change in the base application code but only change in Operation system of PC where the database file is on.
If I shift the data file (access file) to another PC that is running on Windows XP & modify my UNC connection string to point to that Pc, the application again starts working fine on all pc's.
I have tried to change sharing rights to allow read / write to all users (on windows 7 machine).
Also tried to run the application using option "Run As Administrator" but nothing turned right.