Syncronise Access DB on Vista machine

Mick

I developed an app using C# and an Access DB on an XP machine. The app works fine.
I recently moved over to Vista and it seems that the operating system has cloned the DB (I can't find where).
Changes I make to the records through the app are saved to the cloned DB but I cannot work out how to update the root DB. Likewise, changes I make to the root DB manually are not reflected in the cloned DB.
Any ideas, please?

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mick15y ago
Copy to output directory = "Do not copy".
FYI I have run the release version of the exe file in the DB's root directory, and even though the .config path points to the root DB (as per posting on 3rd Jan) it still does not update the user's version of the DB.
Sam Hobbs15y ago
In your project, I assume you have a dataset, which is for the database. In the Solution Explorer, there is a xsd file, right? Right-click on the xsd file and look at the properties. What does the "Copy to Output Directory" property have?
Mick15y ago
I am pretty sure that it is Vista as the app was working fine on XP: i.e. data put into the DB went into the root DB and as far as I am aware there was no clone held for the user.
Sam Hobbs15y ago
You still did not answer my question are "you totally sure that it is Vista".
Mick15y ago
If it is Vista and Visual Studio, I presume it is possible to update the root DB with data from the user's version. Just for info, I have run the Release version of the app in the same directory as the root DB, and the DB's path is correct in the config file.
I am still missing something... any further ideas?
Sam Hobbs15y ago
It totally sounds like it is Visual Studio. It sounds like something that it does. It is likely that the only reason it is different between XP and Vista is that you created the projects differently. The behavior you describe sounds like the default for all projects with a database.
Mick15y ago
I thought at first that it was Visual Studio that was causing the problem, creating a 'development' database, but I moved the release version of the app to the directory that contains the DB and checked the connection string:
<add name="FlashLearning.Properties.Settings.dictionaryConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="dictionary.mdb""
providerName="System.Data.OleDb" />
It is definitely creating a copy of the DB somewhere, as changes to the DB made in the app are not appearing in the root DB when I open it in using Access. I was wondering if it is something to do with additional security features in Vista that did not exist in XP. But what...?
FYI, in XP the DB worked as one would expect, in Vista I had to change the directory properties to add I think it was IUSR to the permissions to get it to write any new records. I don't know if this is significant.
Sam Hobbs15y ago
Are you totally sure that it is Vista that is doing this or are you assuming? It might be that you are incorrectly assuming it is Vista. If there is any possibility that it is not Vista and is Visual Studio instead then if you had not blamed Vista then you would get getter answers.
Suthish Nair15y ago
Can you recheck the paths of both databases.