2. ASPRunnerPro General questions
  3. Corrupted MDB File
This topic is locked

Corrupted MDB File

 		7/30/2003 1:05:50 PM
ASPRunnerPro General questions
G
 Geohawk author

I have an MS Access db on my hard drive. When I use ASP Runner to create a web page and have it built on my web server, I noticed that a copy of my database is placed on the web server in a folder named "db". My question is which copy of the database do I use to create feature pages, the one on my hard drive or the one on the web server? If I use the copy of database in the "db" folder to create additional pages, after I build a page, the database in the folder becomes corrupted and any web pages that I previously built no longer work and I can't open the database in the "db" folder.
Thanks
Sergey Kornilov admin 7/30/2003

Hi,
you have to use original database to create additional pages. This will prevent database in DB folder fro copying to itself that may corrupt it.
Sergey Kornilov
G
 		Geohawk author 7/31/2003

Thanks for the reply. If I need to make changes (i.e., add a new table or field), do I make changes in both databases, the one on my hard drive and the copy on the web server or is the db on the web server overwritten every time I create a new page.
G
 		Geohawk author 7/31/2003

Thanks for the reply. If I need to make changes (i.e., add a new table or field), do I make changes in both databases, the one on my hard drive and the copy on the web server or is the db on the web server overwritten every time I create a new page.
Sergey Kornilov admin 8/4/2003

Hi,
database on the Web server will be overwritten every time you generate ASP pages using ASPRunner.
Sergey Kornilov
G
 		Geohawk author 8/6/2003

Is there anyway to keep this from happening?! If I make changes or add tables, any data my users have entered will be lost. Thanks
Sergey Kornilov admin 8/6/2003

Hi,
Here is what you need to do when you need to change database structure

  • download freshest copy of your database from the Web server to your local box
  • make required changes, add tables etc.
  • upload database back to the Web server
    I hope this helps.
    Sergey Kornilov