Database Discussion - Limitations with Access

Print Page | Close Window

Limitations with Access

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=1131
Printed Date: 28 March 2026 at 7:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Limitations with Access

Posted By: svpworld
Subject: Limitations with Access
Date Posted: 19 March 2003 at 3:55am

I recently set up a discussion forum for my website, its only been running less than a week but already attracted over 400 members and the ms access db file is approaching 2MB.

Realistically how far could I go with access before I need to move to SQL, and does it really cost big bucks to have an SQL database? I've been quoted �30 a month on top of my site fees.

Simon

SVPworld

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 March 2003 at 3:59am

Large Access databases efect all users on the server as the database needs to be opened each time.

Often it depends on your host as to when they believe the database is adversly effecting other users on the server and ask you to move to SQL server. Whay not ask them who large they recommened.

Try US hosts for your site as many throw in SQL server for very little, whereas in the UK for some reason SQL server database cost loads around �25 a month up.

-------------
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: Morgan
Date Posted: 21 March 2003 at 11:32am

I have had success with http://www.setupsite.com - www.setupsite.com

Their e-mail is slow at times, but good response & support. They also support .NET code as well.

I'm sure Google.com will list several sites who support ASP and MS SQL.

VERY IMPORTANT!! Whatever Host you go with, make sure they allow you to be the DBA of your db. i.e. your login account is a member of the database's "db_owner" role.

-------------
Morgan

Posted By: JohnKn
Date Posted: 23 March 2003 at 8:59am

You might find this interesting: http://aerohost.com/SQL-host.htm - http://aerohost.com/SQL-host.htm .

I've been using http://www.webstrikesolutions.com - Webstrike Solutions for 2 years, they've been great. Very fast with support when needed. They support ASP, ASP.NET, PHP, Access or you can get SQL server setup for your domain.

Posted By: svpworld
Date Posted: 03 April 2003 at 1:55am

I've moved over to catalyst2, they are incredibly cheap and offer SQL (both MS and My). I'm now trying to figure out what I have to do to convert my forums to SQL, not being very familiar with the latter!

VERY IMPORTANT!! Whatever Host you go with, make sure they allow you to be the DBA of your db. i.e. your login account is a member of the database's "db_owner" role.

What exactly does this mean, and what if I am not? You got me worried now!!! I can create sql and access db's from my control panel, and ive got the sql server address.... what else to I have to checK?

Simon

Posted By: cr*piecorn
Date Posted: 16 April 2003 at 7:09am

it seems ok to me , just try to set up the forum with sql , then you will figure it out yourself , guessin oracle is the future :-D

-------------
Ruben Schepers
http://www.crapiecorn.be - http://www.crapiecorn.be