Changing location of my ms access 2007 db means can't update records

simon taylor

Hi guys,
i have a problem with my MS Access db 2007 called MIS Pro, when the database is resided in my visual studio project under, MIS Project\bin\Debug\dbname..... i can easily run the application and enter some data into my db. However, when i place the actual database in a completely different location say, C:\Program Files\Free2Learn\MIS Pro\ and change the sql data source to:
Data Source =C:\Program Files\Free2Learn\Mis Pro.accdb ";
and run the application and insert data again i get an error: Operation must use an updateable query. pointing to the following line:
cmd.ExecuteNonQuery();
can somebdoy tell me why i get this error messasge when i start changing the location of the database from that of the \bin\debug folder to the new location and how i can rectify this?
I also changed the the file permissions for the folder Free2Learn to allow all the users have 'Full Control' but it still does not seem to work

2 Replies

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

Sam Hobbs15y ago
The "Program Files" folder is not for data to be modified by the user. That is different from past versions of Windows but it is done for security reasons. It is possible to get around that but it is highly suggested that you don't.

The location that should be used is somewhat dependent on whether the data is supposed to be the same for all users in a system or should be different for each user. I don't know the details of what directory to use but it is documented. If you can please clarify whether the data is supposed to be the same for all users in a system or should be different for each user then it will be possible to provide a more relevant answer, but it should be possible to find the answer in the MSDN.
0
Jean Paul15y ago
Simon..Can you please confirm that the file is not read only?
0