2. ASPRunnerPro General questions
  3. Does Not Update Access DB
This topic is locked

Does Not Update Access DB

 		4/10/2008 2:05:50 AM
ASPRunnerPro General questions
S
 swanside author

Hello.
I got a trial version of ASPRunner to try to access my MSAccess database.
I can see everything but it does not make any changes.
WHen I start my project, I can see the data, I can edit and save and see the changes in the project.
I then open up the database in access and the changes have not taken place?
Any ideas please?
Thanks
J
 		Jane 4/10/2008

Hi,
I suppose you use Use Server.MapPath option on the Database file tab. In this case ASPRunner creates a copy of database in the Output folder and ASP pages work with this database file copy which means you won't see changes in original database file.
To work with original database uncheck Use Server.MapPath option.
Sergey Kornilov admin 4/10/2008

Here is the article with more detailed explanation:

http://xlinesoft.com/asprunnerpro/articles...se_strategy.htm
S
 		swanside author 4/10/2008

Hi,

I suppose you use Use Server.MapPath option on the Database file tab. In this case ASPRunner creates a copy of database in the Output folder and ASP pages work with this database file copy which means you won't see changes in original database file.
To work with original database uncheck Use Server.MapPath option.


Here is the article with more detailed explanation:

http://xlinesoft.com/asprunnerpro/articles...se_strategy.htm


Thanks for the info guys, It works better, but I still can not get past the IFNULL statements.
Sergey Kornilov admin 4/11/2008

I think you need to check functions
IIF() http://www.webcheatsheet.com/SQL/access_functions/iif.php

and

IsNull() http://www.webcheatsheet.com/SQL/access_functions/isnull.php