MDB will no longer accept reuslts

MDB will no longer accept reuslts

Post by Dave » Wed, 14 Jul 2004 05:11:26


I have a asp page feeding a MS ACCESS DB on a local machine using IIS on
Win2000Pro. It has been working fine.

However, sometimes after I open the MDB, new form data will no longer be
entered into database. There is no error message, just missing data.

The only way to get the database to update successfully again is to run
Recalculate Web via IIS.

I have the MDB set to compress upon closing.

Is there something I am missing in that I have to repeatly run Recalculate
Web in order to restore the database connection.

Thanks in advance

Dave K
 
 
 

MDB will no longer accept reuslts

Post by Kevin Spen » Wed, 14 Jul 2004 05:18:14

Are you using FTP to publish? This would cause the server extensions to
become corrupt.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 
 
 

MDB will no longer accept reuslts

Post by Jim Buyen » Wed, 14 Jul 2004 05:31:34

How did you set the MDB set to compress upon closing?

Have you tried running with tht option turned off?

Jim Buyens
Microsoft FrontPage MVP
http://www.yqcomputer.com/
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------





machine using IIS on
will no longer be
missing data.
again is to run
repeatly run Recalculate
 
 
 

MDB will no longer accept reuslts

Post by Dave » Wed, 14 Jul 2004 05:36:13

I know this may be nuts.

I am Win2000Pro as the Web Server on a local machine. I have created the
site on the root of the C: drive, i.e. C:\NTS.
I cretaed the site using IIS Virtual Directory. I then create and edit
pages directly in the C:\NTS folder. So there is no FTP taking place.

I use this local machine to host surveys at the end on a class. The students
hit the default page on my machine, take the survey and then I view the
information on my local machine.

Dave





Recalculate
 
 
 

MDB will no longer accept reuslts

Post by Dave » Wed, 14 Jul 2004 05:41:51

I went into MDB, Tools/Options/General/checked Compact on Close.

Could this the issue?

Dave
 
 
 

MDB will no longer accept reuslts

Post by Kevin Spen » Wed, 14 Jul 2004 06:46:15

Sounds like Jim may have your answer.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.



students




on
be
run
 
 
 

MDB will no longer accept reuslts

Post by Kathleen A » Wed, 14 Jul 2004 09:13:41

If it were me, I would export the database out of the web to somewhere else
on my PC and open it from there.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.yqcomputer.com/
 
 
 

MDB will no longer accept reuslts

Post by news » Wed, 14 Jul 2004 13:49:21

Well, I'm not really sure if this setting compresses the database
every time *anything* closes it, or just every time the Microsoft
Access desktop program closes it.

If the compress occurs whenever *anything* closes the database, you
may be forcing a compress every time a Web page runs. This could be
dozens of times a second. And each compress locks the database for
exclusive control, creates a new .mdb file, then deletes the original
.mdb file, then renames the new one. With all that going on, I could
believe the server extensions might lose track of the database
connection.

It's worth a try.

Jim Buyens
Microsoft FrontPage MVP
http://www.yqcomputer.com/
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
 
 

MDB will no longer accept reuslts

Post by Dave » Wed, 14 Jul 2004 23:13:38

hanks for all of the help! I have a lot of ideas to explore.

Dave

Another question
"Jim Buyens" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
news:< XXXX@XXXXX.COM >...


 
 
 

MDB will no longer accept reuslts

Post by Dave » Thu, 15 Jul 2004 02:58:11

f I have to Recalc the Web via IIS, does that indicate corrupted
extensions?

Dave

"Jim Buyens" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
news:< XXXX@XXXXX.COM >...


 
 
 

MDB will no longer accept reuslts

Post by Kevin Spen » Thu, 15 Jul 2004 03:07:33

retty much.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Dave" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...