Re: [CFTALKTor] Disk Space

[Mike]

I do compact and repair the database it dosen't decrease in size.  I guess I will have to look for another host.     ----- Original Message ----- From: Andrew Clark To: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:08 AM Subject: RE: [CFTALKTor] Disk Space Presumably you do compact , but, if not, this could save you a high % It seems intermedia charge $50 extra / month for MSSQL for only 10MB so not sure you could save anyway Plus I think you may not find converting to SQL quite as easy as Byron suggests I also suggest you check out alternative hosts as there are plenty of options out there   Andrew Clark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: 20 March 2002 07:46 To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Disk Space 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