Solved

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

Posted on 2015-02-05
3
23 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 34

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
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.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

626 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