| Author |
 Topic  |
|
|
bohunt
Starting Member
10 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
gary b
Junior Member
USA
267 Posts |
 Posted - 18 November 2007 : 10:23:50
|
Do a search for 'updateable query'. This is a server permissions issue and has been discussed in numerous topics.
If you can't find the solution within the search results, post back for additional help.
gary b
< |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 November 2007 : 11:14:28
|
Or you could start with the "FAQs for Using Snitz with Access" forum, and spot the stickied topic called "FAQ: What is Operation Must Use An Updatable Query".
Just for future reference, searching for the error message and/or the error code will often turn up a thread or two. If your search for the error code and/or the error message don't turn up anything, make sure you let us know that you at least searched.< |
|
|
|
bohunt
Starting Member
10 Posts |
Posted - 19 November 2007 : 15:52:10
|
| Sorry.. but thanks!< |
|
|
|
AYAN
Starting Member
2 Posts |
Posted - 14 December 2007 : 11:09:03
|
Hi all,
PLZ can any one can help me to send me the ready config file using access data base because I can't change the file.
Reagards< |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 14 December 2007 : 11:10:49
|
Can I ask why you cannot edit the config file?
Also you should really start your own topic instead of posting on someone else's< |
Edited by - JJenson on 14 December 2007 11:11:20 |
|
|
|
AYAN
Starting Member
2 Posts |
Posted - 14 December 2007 : 11:33:04
|
Dear JJenson ;
I readed the instructions of install the data base and forum, but really I don't recognize which statments must be change and which must drop.
Thanx alot , I hope to do my self but I failed twice.
regards
< |
Edited by - AYAN on 14 December 2007 11:41:32 |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 14 December 2007 : 12:06:06
|
| Ok please start your own topic cause this really doesn't have anything to do with this one.< |
|
|
|
Flashspot
Starting Member
United States
6 Posts |
Posted - 20 June 2008 : 12:18:13
|
| Just a note for those who encounter this issue in the future. Go into your Enterprise Manager (SQL Server 2000) or Management Studio (SQL Server 2005) and locate the User that needs access to the forum (likely NT AUTHORITY\IUSR), change that's User's Role's for the forum's database to db_owner then run the setup. Assuming this was successful then go back and remove the db_owner status for that User, leaving just db_datareader and db_writer.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 June 2008 : 12:24:24
|
quote:
Originally posted by Flashspot
Just a note for those who encounter this issue in the future. Go into your Enterprise Manager (SQL Server 2000) or Management Studio (SQL Server 2005) and locate the User that needs access to the forum (likely NT AUTHORITY\IUSR), change that's User's Role's for the forum's database to db_owner then run the setup. Assuming this was successful then go back and remove the db_owner status for that User, leaving just db_datareader and db_writer.
Really? How will that affect an Access database?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 June 2008 : 12:42:45
|
| plus the user that has access to your forum db should be your sql user not the IUSR account, there is absolutely no reason to make the iusr account dbowner on your database< |
|
|
|
Flashspot
Starting Member
United States
6 Posts |
Posted - 26 June 2008 : 16:58:46
|
| It has no bearing on an Access db since Access doesn't have database-level Users. This is only applicable to SQL Server 2005 (and presumably, SQL Server 2008.)< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
