TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
simon taylor
NA
38
69.2k
Changing location of my ms access 2007 db means can't update records
Dec 16 2010 6:13 AM
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
Reply
Answers (
2
)
Alter parameter type
Problem with stored procedure