|
|
 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
August 30th, 2004, 04:14 AM
|
|
Authorized User
|
|
Join Date: May 2004
Location: Athens, , Greece.
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
[ODBC Microsoft Access Driver] !!!Error!!!
Hello Guyz.
I`ve made some pages on ASP and the db I use is MS Access with a DSN connection. I`ve built all this on Windows 2000 Pro" and yesterday I tried to run localy these pages on my other pc where I use "Windows XP". I made the same settings as I had done on "Windows 2000 pro". Everything was working fine except "Insert, Update and Delete" records (but reading from the db was ok). The error that was coming up is the following.
Microsoft OLE DB Provider fro ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Are you familiar with this? If so please help me... cause I don`t know how to fix this problem. :(
|
August 30th, 2004, 04:26 AM
|
|
Authorized User
|
|
Join Date: Aug 2004
Location: Seunderabad, Andhra Pradesh, India.
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi
Could it be an permissions issue!! never worked on MSAccess.
may be read write permissions from administrator!!!
Go to tools, there in Security, you can click on User and Group Permissions, and then check all update, insert etc statements to true and try it over again.
Regards
sinapra
|
August 30th, 2004, 05:18 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , India.
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi
Check the field names in the Query and the Table once, The similar error caused for me also.
Gokul
|
August 30th, 2004, 07:19 AM
|
|
Authorized User
|
|
Join Date: May 2004
Location: Athens, , Greece.
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Ok... thank you guys.
Right now I`m not able to try this. But when I`ll try it I`ll let you know if it works fine or not. :)
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
