Hi everyone!
Can anyone help me to choose the best database engine?
What I need to do is to put a database on a remote server. Then, that database must accessed and/or updated (at the same time or not) by several pcs connected do the server, showing the results on visual basic. Each pc would be connected to a local database, which would save the results to the query to the remote database. My first choice was Microsoft Access, because it's easy to use and easy to implement with visual basic. But I've been searching, and it seems that Access can't deal with multiple accesses at the same time on the same database. Since MSDE is free, and it's based on SQL, I think it's the best choice, since it's integration with VB seems easy. What do you think?
And which database is faster? Access or MSDE.
Thanks.