MDB will no longer accept reuslts

D

Dave

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
 
K

Kevin Spencer

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.
 
J

Jim Buyens

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.interlacken.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)
|/---------------------------------------------------
*----------------------------------------------------
 
D

Dave

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
 
D

Dave

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

Could this the issue?

Dave
 
K

Kevin Spencer

Sounds like Jim may have your answer.

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

Kathleen Anderson [MVP - FP]

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

Jim Buyens

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.interlacken.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)
|/---------------------------------------------------
*----------------------------------------------------
 
K

Kevin Spencer

Pretty much.

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