If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Solution To Insert Records Into Msacess Using Vbscript

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-28-04, 18:00
jenzien jenzien is offline
Registered User
 
Join Date: Feb 2004
Posts: 9
Solution To Insert Records Into Msacess Using Vbscript

Remember that updateable query problem I was having? Well I've finally solved it Thanks to much help, And I'd thought I'd post the solution for all you Windows Xp Pro users!
1. First of all, you must make sure that the write permission is assigned to your website under IIS
2. Then change the security settings for the folder which your database is contained in via the security tab. To get the security tab up you must goto windows explorer, click on tool>>folder options, view tab and unclick the use simple file sharing option and click on ok
3. Right-click on the folder containing your database, click on properties then select security tab, please add new user, the user name should be IUSR_PCNAME, where PCNAME is the name you have given to your computer, e.g mine is GLADIATOR so user is IUSR_GLADIATOR, assign read and write permissions to this user, once finished click on ok.

Hope this helps out other users!
Reply With Quote
  #2 (permalink)  
Old 03-09-04, 17:16
odar001 odar001 is offline
Registered User
 
Join Date: Mar 2004
Posts: 1
Re: Solution To Insert Records Into Msacess Using Vbscript

Quote:
Originally posted by jenzien
Remember that updateable query problem I was having? Well I've finally solved it Thanks to much help, And I'd thought I'd post the solution for all you Windows Xp Pro users!
1. First of all, you must make sure that the write permission is assigned to your website under IIS
2. Then change the security settings for the folder which your database is contained in via the security tab. To get the security tab up you must goto windows explorer, click on tool>>folder options, view tab and unclick the use simple file sharing option and click on ok
3. Right-click on the folder containing your database, click on properties then select security tab, please add new user, the user name should be IUSR_PCNAME, where PCNAME is the name you have given to your computer, e.g mine is GLADIATOR so user is IUSR_GLADIATOR, assign read and write permissions to this user, once finished click on ok.

Hope this helps out other users!
hey mate, don't know you but i really have to thank you for this information cause it solved my problem!!!!!!!!!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On