Re: Issue of visual basic client /server

Hi Timothy,

             I understand your scenario. You are using Access as backend. It will be an Access file. At a time, more than one person can access the Access file which will be used as Database in your scenario. But if the number of users which will access your file at same time will increased in this scenario, your system will crash. That is the disadavanatge of using Access as database. It supports limited no of users and  less capacity to store data as comapred to SQL Server.

            If  in your application, more no of user access the file at one time then you should go for SQL server. If the users are limited then you can use Access as database.

           Hope that it will clear your idea.

Regards

Ashutosh