Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server Speed benchmarking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-04 : 22:21:58
Peter writes "Hi,

I am a VB Programmer who has been given a project to develop by my employer. I have been instructed to write a front-end Access db that will connect to a database - about 20-30 users over a 10 or 100 Mb (not sure) LAN. I would like to use SQL Server as the database, but my boss is sure that there will be little difference between SQL Server and Access. The db will be holding ~250,000 new records each month and will be primed with 3-4 years' worth of data!

Please help me as I cannot back up what I believe - or am i wrong anyway. My boss wants 'proof'!!

Any help would be appreciated.

Thanx

Peter"

chadmat
The Chadinator

1974 Posts

Posted - 2002-03-04 : 22:28:26
See:

http://www.microsoft.com/sql/techinfo/planning/SQLAccess.asp

I would suggest SQL with that type of growth. Also, with 20-30 users, you may run into concurrency problems with access depending on what they are doing.

-Chad

Go to Top of Page
   

- Advertisement -