2. ASPRunnerPro General questions
  3. Help - MSAccess Update Mystery
This topic is locked

Help - MSAccess Update Mystery

 		8/30/2004 12:01:54
ASPRunnerPro General questions
author

Let me try to explain this as clearly as possible:
-I'm running WinXP Pro with a local IIS 5.1

-the database is somewhere under \inetpub\wwwroot

-the build executes w/o any problem, and the admin app functions as it should
But:
-When I add or edit a record through the generated runner pages, after some time, (navigating, refreshing, etc) the record simply disappears (if it was added) or reverts back to it's initial value (if it was edited)

-Also any values inserted directly into the db take a loong time to show up in the runner pages.
I'm guessing this isn't directly a runner problem, probably an IIS or MSaccess issue (maybe at the connection object level?)
What am I doing wrong? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=781&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
Sergey Kornilov admin 8/30/2004

Jose,
if you use Server.MapPath option in ASPRunner your database file will be copied from it's original location to DB subfolder in ASPRunner's output folder (overwriting your changes). If you don't need to move files to the remote Web server you don't have to use Server.MapPath option.
J
 		jokka 8/31/2004

Hmmmm...ok, but...
I'm using the local IIS only as a testing server. The app will be eventually moved to a remote server. Does this mean that (let me see if I got it straight):

a) I don't use Server.MapPath locally

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=2393&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' /> Edit the connection string on the remote server to use Server.MapPath
Yes? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=2393&image=2&table=forumreplies' class='bbc_emoticon' alt=':huh:' />
J
Sergey Kornilov admin 8/31/2004

J,
if you plan to move this application to remote Web server I would recommend to use Server.MapPath option. Just remember you have two copies of this database file on your local box.