Re: SQL

From: paul (paul_at_discussions.microsoft.com)
Date: 10/14/04


Date: Thu, 14 Oct 2004 06:19:05 -0700

Dan, thanks thats useful. I do expect more than 5 concurrent read only users
but less than 5 read/write users. in total more than 5 if that makes sense.
the size of the dBase will be less than 10MB.

the data model is not complicated at all.

ive already split my dbase in to a be-fe configuration and limited the
number of users that have the fe. ideally, i want upto 30 read only users and
5 or so read write users, will access cope?

"solex" wrote:

> Paul,
> It depends on your requirements. IMO, you should use SQL Server if you
> expect to have a large amount of data >250 MB, have a complex data model
> and/or you expect to have more the 5 concurrent users.
> Dan
>
>
> "paul" <paul@discussions.microsoft.com> wrote in message
> news:3E63F631-C469-4C77-BE38-A0BDE841E32D@microsoft.com...
> > ive been told that creating a database using SQL is far better than using
> > access. can an access database be easily converted to SQL and if so what
> are
> > the benefits?
>
>
>



Relevant Pages

  • Re: SQL upsizing
    ... I agree with Dan, but make not mistake, if your application requires to use ... a SQL database MS, MySQL or ORACLE, then your programming habit must change. ... > Where are the 15 years worth of articles? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: IIS & SQL, NT authentication for Web
    ... Hi Dan. ... | Subject: Re: IIS & SQL, NT authentication for Web ... | I guess I wanted to confirm that, yes a user should Authenticate to SQL ... as your Internet users won't have Windows NT accounts on your ...
    (microsoft.public.sqlserver.security)
  • Re: Using * as a literal in query criteria
    ... Should this be reported to Microsoft? ... Dan R ... "Michel Walsh" wrote: ... It seems there is a problem between Jet and MS SQL Server (at the ODBC ...
    (microsoft.public.access.queries)
  • Re: xp_cmdshell
    ... Thanks Dan ... > Only members of the sysadmin server role can execute xp_cmdshell by ... > encapsulates the xp_cmdshell commands. ... > The OS security context for non-sysadmin users is limited to the SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Retrieving SERIAL identifiers in a concurrent environment
    ... is that concurrency-proof (is it isolated from concurrent ... This contains the return code of any sql statement and item SQLERRD ... Retrieving SERIAL identifiers in a concurrent environment ... FIRST 1 ID FROM myTable ORDER BY ID DESC" SQL statement just after the INSERT statement. ...
    (comp.databases.informix)