Control Panel Forum Hosting Help 6 Months free Hosting (New!) Resources

Total members: 76761
Average new registrations per day (in last 7 days): 80

New Registration: Open

Register Now

Home » Tips » How to use MS Access database

General	Hosting Features	Upgrade Options	Server Issues
Coding Questions	Security & Permissions	Site Promotion

How to use MS Access database

04 Nov, 2005

Summary
Our free web hosting allows using MS Access database. Learn how to connect to the MS Access database.

You can use File Manager to upload your database files to any location under your member folder. You must specify the physical location of the file in your connection string in order to successfully connect to MS Access from your ASP.NET 2.0 code.

However, we strongly reccommend to upload your MS Access database files to the folder "database". This is a special folder designed with some special security settings. Since this folder is outside your webroot, nobody can download your database using a URL in your application.

Also, the "Database Manager" will allow you to manage your databases only if it is placed in your "database" folder.

If your database size is beyond the File Upload limits, you may try to truncate the un used space in your database. To do this, open your MS Access database in your machine, go to Tools > Database Utilities > Compact and Repair Database. This may help you reduce the size of the mdb file.

If your database file size is still beyond the file upload limits, you may zip the database file and upload to the database folder. After you upload the zip file, post a request to un zip it through the forum. Our service team can help you un zip the file. However, this option is available only for members in level 2 or above.

Related Topics:

Connection strings
How to use SQL Server 2005 Express database