Problem Updating to MS Access Database in Windows 7 machine connected through unc path

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.

SANDEEP
sandeep jakhotyaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sandeep jakhotyaConnect With a Mentor Author Commented:
Yes, Got the solution.
It was all because of Advanced Sharing permission of the Drive on Win 7 machine which is by default set to "Read" Only.
0
 
ste5anConnect With a Mentor Senior DeveloperCommented:
Please check the NTFS permissions and share permissions on this Win7 machine and compare it with them on the old XP machine.

btw, the error message may indicate indeed, that your query is too complex..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.