Database Discussion - a 165 MB Access database

Print Page | Close Window

a 165 MB Access database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13142
Printed Date: 29 March 2026 at 9:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: a 165 MB Access database

Posted By: zMaestro
Subject: a 165 MB Access database
Date Posted: 29 December 2004 at 6:15pm

I brought a database of a huge book I've to put online, it is an access (.mdb) database. I've a few questions (hope to find someone to answer them during the Christmas holidays

)

It was an Access 97 database, when I converted to access 2000 its size was doubled!!! it was 85 MB on Access 97, and then it became 165 MB after converting to Access 2000 even after compacting and repairing it. Is this normal?
Is it wise to use it as .mdb or I have to change to MsSQL, or I must change to MsSQL?

Thanks :)

Replies:

Posted By: ljamal
Date Posted: 29 December 2004 at 9:21pm

I'd change it to MSSQL

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: WebWiz-Bruce
Date Posted: 30 December 2004 at 6:16am

Access 2000 databases are usually larger than 97 databases, but it is worth changing as in my experience access 97 often becomes corrupted when used as a web site backend.

If the database is not going to be opened very often and the server is has enough speed and resources to load in a 165mb access database to memory it should be OK.

If the database is to be accessed often, or on a shared hosting environment then you should look at using MS SQL Server or mySQL

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dbob
Date Posted: 04 January 2005 at 10:54am

Hello, I have downloaded the Search engine from Web Wiz. Its brilliamt, becuase now I have taken the first steps to knowing asp and mySQL databases.

I want to convert the MS Access db which came with the zip download.

Firstly, are there any suggestions on a way that i can convert MS access to mySQL?

Secondly, Will i be able to replace the ms access with mysql without needing to change the asp in any massive way?

Thanks

Posted By: Mart
Date Posted: 04 January 2005 at 11:24am

I would use MSSQL Server for that db, as for every db call the server must load the 165mb access database into its memory.... which is very expensive

Posted By: WebWiz-Bruce
Date Posted: 04 January 2005 at 11:24am

Converting from Access to mySQL is normally done by hand, unless you can find a tool to do it, by recreating the database in mySQL.

Most of the applications on this site I have written using ADO updates, mySQL doesn't support this so you would need to change allot of the code.

If you want to look at a database that is better then MS Access and mySQL and is more compatible with ASP and often only requires that you change the connection string in the ASP code, then look at MS SQL Server 2000.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dbob
Date Posted: 05 January 2005 at 7:41am

mmm....thanks. That is very specific, which helps. It feels cool that the app maker is giving advice.

MS SQL Server 2000 is server technology right.....i mean mySQL is a lang for producing datadbases......

I'll research the basics. But....

I host a mySQL DB on a MS SQL Server right?

I'll look into it, and i'll prob be back

Thanks for now

Posted By: dbob
Date Posted: 05 January 2005 at 7:53am

OK, im back.

Let me try and cut this down into simple parts.

I have a MS Access DB. I want to migrate over to mySQL.

Say that i do this, then I will want to host the mySQL db on a server that provides MS SQL 2000.

boRg, what I need to do is: - create a mySQL database with the most recent release. And, then ensure that I can host the db, as i have said, on MS SQL...??

Posted By: dbob
Date Posted: 05 January 2005 at 11:40am

oh, MS SQL SERVER 2000 software is expensive, since i am only learning. so it is a software, that much is clear.

Posted By: JohnKn
Date Posted: 05 January 2005 at 4:37pm

http://www.dbtools.com.br/EN/ is a great tool for managing mySQL databases and has import wizards to convert Access databases to mySQL very easily.

SQL = "structured query language" the language sql based servers use
MS SQL = Microsoft sql database server
mySQL = open source database server

Both MS SQL and mySQL use the SQL language to greater or lesser extant but they're totally seperate products dwdws. If your host only supports MS SQL that you'll need to "upsize" it to MS SQL, not mySQL. That can be done either though Access or by using microsofts Enterprise manager. There are likely other tools to do it, but those are the ones I'm aware of.

To zMaestro I would take borgs advice and convert that large Access db to either mySQL or MS SQL especially if you expect a lot of traffic on your site. The db will likely get even larger after upsizing to MS SQL, at least my Web Wiz db did.