Solved

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

Posted on 2015-02-05
3
9 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Loop not working 29 47
SQL Exceptions 3 39
Capture logon name 13 46
Not seen Link button 5 17
Navigation is an important part of web design from a usability perspective. But it is often a pain when it comes to a developer’s perspective. By navigation, it often means menuing. This is less theory and more practical of how to get a specific gro…
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now