Access does not "purge" itself automatically.  You may try downloading the database, doing a "Compact" and then uploading it again.  That will make it smaller if you have a bunch of deleted records hanging around.
 

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]

 
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
Sent: Wednesday, March 20, 2002 6:59 AM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] Disk Space

Hello All,
 
I have  problem with a simple website that I have that uses (I know, I know) Access as a database.  What started out being a 20 - 30 mb file has now somehow grow to 200 mb and is growing.  My shared hosting provider charges a lot of money for disk space.  Would converting the file to MSSQL 2000 save me diskspace? 
 
If so, I am not familiar with MSSQL is there a tool that will easily convert my database to MSSQL so that I can upload it.
 
Thanks
 
Mike

Reply via email to