Access as a datasource

Hi

Not sure I understand the "free" bit

The ISP is quoting me £10 per month per 100mb for MS SQL 2005 and presumably
that will be for each domain or am I missing something?

Ken

"jhutchdublin" <webforumsuser@macromedia.com> wrote in message
news:enuc12$54l$1@forums.macromedia.com...
> While Access is OK for web development. what Micorosoft says above is
> true.
> However, Microsoft are now giving a way something called SQL Sever 2005
> Express
> -- free. I know, you never thought you would hear the word's Microsoft and
> free
> in same sentence.
>
> You can easily update your Access Databases using the Updating Wizard and
> then
> have them as SQL Server Databases, cost nothing
>
> The only two catches I can see with SQL Server Express is the it doesn't
> understand dual core processors and can't be bigger than 4 gigabytes of
> data.
>
> I can't see why this would work for you.
>
> Don't forget please back up your databases before upsizing or doing
> anything
> else to them.
>
>
>

While Access is OK for web development. what Micorosoft says above is true. However, Microsoft are now giving a way something called SQL Sever 2005 Express -- free. I know, you never thought you would hear the word's Microsoft and free in same sentence.

You can easily update your Access Databases using the Updating Wizard and then have them as SQL Server Databases, cost nothing

The only two catches I can see with SQL Server Express is the it doesn't understand dual core processors and can't be bigger than 4 gigabytes of data.

I can't see why this would work for you.

Don't forget please back up your databases before upsizing or doing anything else to them.

Ken

Access is supposed to be able to support 256 users but in practise this
number is significantly lower. I do know from experience that we had
significant improvements in both speed and reliability in moving a site from
Access to SQL and this was on a site that would be lucky if it had 10 users
accessing the database.

Having said this on a shared server your site could be being affecting by
other sites. Initially I would see if the host is willing to place the site
in its own application pool.


--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Ken Renwick" <ken@nospamrdsweb.co.uk> wrote in message
news:enu3qf$olc$1@forums.macromedia.com...
> Hi all,
>
> I've been recently experiencing dramatic fluctuations in the speed of the
> sites I have hosted with a particular ISP. All sites are written using
> DW8, traditional ASP with an access database DSN.
>
> When I advised them of this I was advised that there was nothing they
> could do and that I should upgrade my sites to SQL Server. (at a price of
> course)
>
> They referred me to this comment from Microsoft:
>
> "...we recommend that Microsoft Access be used solely for development
> purposes and not for production. Microsoft Access was designed as a
> single-user desktop database, and not for server use. When multiple,
> concurrent users make requests of a Microsoft Access database,
> unpredictable results may occur"
>
> I could understand this if my sites were experiencing extremely heavy
> traffic but this simply isn't the case.
>
> Frankly, I'm sure the ISP is using this as an excuse to avoid looking into
> the shortcomings of their own systems. Trouble is I can't find much in the
> way of amunition to contradict them.
>
> Can anybody help please?
>
> Thanks in advance
>
> Ken
>