Re: Access online

Hi Sarah,

In most instances access will fit the bill, only if you are going to have a
large database (1GB+) with loads of users would I recommend SQL/MSDE with
SQL server it will cost you, the MSDE is a cut down version of SQL server it
is free it is a good point to start because if you ever want/need to scale
up to SQL the process is very simple. How large and how complicated is the
database going to be?

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"Sarah" <Sarah@discussions.microsoft.com> wrote in message
news:C4E30BE0-6EA3-4413-B14C-D67B4345F0DD@microsoft.com...
> Sorry, I don't know much about these things but I am currently looking
> into
> putting a database online. I would like to use Access as it is the
> database I
> am most familiar with but I have been told by consultants that Access is
> too
> limited for such a purpose. Is this right? Are there any other products
> people could recommmend?

Not sure I'd recommend MSDE for a large database with loads of users. MSDE
has the same size limitation as Access (i.e.: 2 Gb), plus is throttled for 5
connections.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Alex White MCDBA MCSE" <alex@intralan.co.uk> wrote in message
news:%235qb08bSFHA.2784@TK2MSFTNGP12.phx.gbl...
> Hi Sarah,
>
> In most instances access will fit the bill, only if you are going to have
> a large database (1GB+) with loads of users would I recommend SQL/MSDE
> with SQL server it will cost you, the MSDE is a cut down version of SQL
> server it is free it is a good point to start because if you ever
> want/need to scale up to SQL the process is very simple. How large and how
> complicated is the database going to be?
>
> --
> Regards
>
> Alex White MCDBA MCSE
> http://www.intralan.co.uk
>
> "Sarah" <Sarah@discussions.microsoft.com> wrote in message
> news:C4E30BE0-6EA3-4413-B14C-D67B4345F0DD@microsoft.com...
>> Sorry, I don't know much about these things but I am currently looking
>> into
>> putting a database online. I would like to use Access as it is the
>> database I
>> am most familiar with but I have been told by consultants that Access is
>> too
>> limited for such a purpose. Is this right? Are there any other products
>> people could recommmend?
>
>

Hi Doug,

the MSDE it is a good tool to start with if you don't know what direction
you are going in, especially if you are outgrowing access, so that you can
at least see what the differences between access and SQL are. The cost of
SQL is prohibitive for small developments, and hey if you have the nice to
have problem of too many users start spending money at that point rather
than at the start of the project.

but agree the sentiment on the larger size developments.
--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:Og%23QJSeSFHA.3088@TK2MSFTNGP15.phx.gbl...
> Not sure I'd recommend MSDE for a large database with loads of users. MSDE
> has the same size limitation as Access (i.e.: 2 Gb), plus is throttled for
> 5 connections.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Alex White MCDBA MCSE" <alex@intralan.co.uk> wrote in message
> news:%235qb08bSFHA.2784@TK2MSFTNGP12.phx.gbl...
>> Hi Sarah,
>>
>> In most instances access will fit the bill, only if you are going to have
>> a large database (1GB+) with loads of users would I recommend SQL/MSDE
>> with SQL server it will cost you, the MSDE is a cut down version of SQL
>> server it is free it is a good point to start because if you ever
>> want/need to scale up to SQL the process is very simple. How large and
>> how complicated is the database going to be?
>>
>> --
>> Regards
>>
>> Alex White MCDBA MCSE
>> http://www.intralan.co.uk
>>
>> "Sarah" <Sarah@discussions.microsoft.com> wrote in message
>> news:C4E30BE0-6EA3-4413-B14C-D67B4345F0DD@microsoft.com...
>>> Sorry, I don't know much about these things but I am currently looking
>>> into
>>> putting a database online. I would like to use Access as it is the
>>> database I
>>> am most familiar with but I have been told by consultants that Access is
>>> too
>>> limited for such a purpose. Is this right? Are there any other products
>>> people could recommmend?
>>
>>
>
>