SQL or Ms Access

[Guest]

hi

I have to make a project with VB and a backend in which per day 10,000 data
is to be entered which will be added daily in that database.

which database i should to use???

 

[Guest]

Enter this link, it might give you an answer for what you looking

http://www.microsoft-accesssolutions.co.uk/ms-access-vs-sql-server.htm

 

[Sylvain Lafontaine]

10000 insertions on an interval of 8 hours is about one insertion each 3
seconds and if you have about 250 bytes by record, this will make about 1Gig
per year.

If you go with Access, you will clearly stretch its capability to its
maximum; even on a powerfull machine but, on the other way, nothing forbid
you to give it a try.