How many records a database can handle



Hello

I have to develop a database for a small agent (for 5-10 users). I am
thinking to use MS Access and VB.net. Could you please tell me how many
records (max) an Access database can handle. Should I choose MS Access, MS
SQL or mySQL (and why?)

Thank you very much for any help

S.Hoa


.



Relevant Pages

  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: SBS 2003 R2 backup: skipped (in use) files
    ... but my point was that an open-file agent does *not* ensure consistency across files....which a database needs. ... where transactions are atomic can be backed up with a snapshot based backup but if Backup Exec doesn't do the entire snapshot at once then it could *still* break a file based database as well. ...
    (microsoft.public.windows.server.sbs)
  • Re: Change QueryTimeout
    ... It could be transactions queued in the distribution database. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ... I cannot get to agent properties because the subscribers are ...
    (microsoft.public.sqlserver.replication)
  • Re: Steve Jobs very very interested.
    ... I just think that Agent is badly written, ... My newsreader currently has a database of over 10GB, ... A lot of developers are deathly afraid of multi-threading. ...
    (borland.public.delphi.non-technical)
  • Re: simulate virtual directory for each user
    ... > I need different virtual directory for different customer with their names ... > of that user's web pages from database. ... > After writing the agent Id to client's cookie, ... I read cookie and get agent id and bring the agent info ...
    (microsoft.public.dotnet.framework.aspnet)