Sugestion on how to start pls
Hi,
So I have to make an app the will have a few hundred clients (hopefully) and that has to use a database. Not all clients have 100% connection to the internet and I cannot acces all clients computers. So I have to make something with a local database that shouldn't be to hard to install like SQL server and stuff. The data base should be able to handle easely 20-30.000 entries.
What do you suggest I should use? Access? My app will be in C#. I've tried to make a sample app with C# and access but connection seems a bit hard and I'm afraid that the connection will not work on every station.
Can anybody suggest anything else?
Thank you!
Re: Sugestion on how to start pls
Hi all.
If the environment will be multi-user, I advise not to use Access, because it doesn't work fine with more than one connection.
Unless new releases had resolved this problem.
Re: Sugestion on how to start pls
no, it's single user. I will send him new databases with updates on a regulary bases.
Re: Sugestion on how to start pls
Quote:
Originally Posted by vma
no, it's single user. I will send him new databases with updates on a regulary bases.
OK, in this case Access might be a right choice.
But in my opnion sending the updated MDB files to all clients is a very "poor" solution, prone to error. I suggest to take a look at data replication techniques: they're available with Access, but probably SqlServer (and Oracle) implement these advanced database features in a better way.
