SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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?
 
That sounds like a plan. Just make sure you setup your indexes
appropriately, the Peformance analyzer is not bad in making suggestions
regarding indexes. Also if in the long run you have problems with
performance it is relatively easy to upsize to SQL server.

Good Luck!
 
Hi Paul,

Assuming all the users are on the LAN that sounds well within Access's
capabilities.
 
Back
Top