Solved

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

Posted on 2015-02-05
3
11 Views
Last Modified: 2016-06-23
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
0
Comment
Question by:sandeep jakhotya
3 Comments
 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 40593263
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
 

Accepted Solution

by:
sandeep jakhotya earned 0 total points
ID: 40595333
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

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question