Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-02-05
3
Medium Priority
?
26 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 35

Assisted Solution

by:ste5an
ste5an earned 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
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 goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

721 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