ASP and Access conflict

jrjr

A work in progress
Local time
Today, 10:09
Joined
Jul 23, 2004
Messages
291
Greetings!
I have been dabbling in ASP shopping carts. The free ones usually do not come with a good front end for data entry. I got the idea to use Access and had major troubles. I created a blank DB and linked tables to the Cart's DB on my server. I found that if the cart pages were not opened in a browser and only worked on it in Acess that all was well. If I had the DB opened in Access and pulled up the site in my browser, it really screwed up! I actually did one reinstall before I figured out that all I had to do was restart the IIS service. Then things were normal again. The same thing was true if I opened the DB right on the server without the remote linked DB. Using 2000 server with Access 2000 and Win XP with Access XP on my desktop. Any ideas why this happens and what I could to to make it work?
Thanks!!
 
you must make the ENTIRE folder that the db resides in have MODIFY rights for IUSR_machinename . This will allow IUSR to write to the ldb file when it is created as well as have it open in access.
 
Ok, thanks!
I think I only gave modify rights to the DB itself.
Makes sense that the LDB would not be written to if that is the case....
I will try that out later!
 
No, I had given 'modify' permissions to the DB folder. Should I give it to the parent folder as well? That seems a bit too loose......

Edit.... it is still in the web, needs to be moved out of the web and then it may work..... Going to try that now

Edit again...
Yes that worked. The DB needed to be moved out of the web anyway and once all the parent folders were given 'modify' Access liked it!

Thanks!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom