Microsoft Access ASP

  • Thread starter Thread starter Clyde Thorne
  • Start date Start date
C

Clyde Thorne

I have FrontPage 2000. Until recently, I would import my MS Access database
to my web site. But during my last database update, my file is now 234MB,
and FrontPage quits responding during my import of files. Does FrontPage
have a limitation on file sizes for import? If not, does anyone know why
Frontpage quits during import of the database?

clyde
 
What speed is your Connection? I've imported and exported .mdb files of over
2 MB to my web site.

--
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
-----Original Message-----
I have FrontPage 2000. Until recently, I would import my
MS Access database to my web site. But during my last
database update, my file is now 234MB, and FrontPage
quits responding during my import of files. Does
FrontPage have a limitation on file sizes for import?
If not, does anyone know why Frontpage quits during
import of the database?
Click to expand...

It's more of a timeout issue than a file size issue.
Howver, you're likely to have trouble with a 234MB Access
file no matter what you do.

The first thing to try is the Access "Compact and Repair"
command. If that doesn't solve the problem, you options
are:

o Purge old data from the database.
o Eliminate any pictures or ActiveX controls stored
in Memo fields.
o Convert to SQL Server.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Thanks Jim,
I'll try purging the files. I'm not importing pictures or active X, just
data. But I do know of some data that I can get rid of to reduce the file.
clyde
 
Thanks Jim,
I'll try purging the files. I'm not importing pictures or active X, just
data. But I do know of some data that I can get rid of to reduce the file.
clyde
Click to expand...


FYI - there's a known issue with Access d/b's growing exponentially.
If you don't do the "compact and repair" previously mentioned then
a d/b with a lot of action will get very big, very fast.
 
Back
Top