We have deployed a VB6 (FRONT END including sql queries in VB6 Coding) with DB as MS Access 2003 project in multiuser operation under LAN network (having OS as windows xp professional in all computer. There is about 4 LAN users accessing this Application.) at our client. For reports we have used crystal report x1

Currently both db and vb6 (executable) is located in shared folder of a LAN Computer. And all network users has shortcut path of vb6 application. So this is network sharing set up.

My query is do we need to split the MS ACCESS Database (which currently has only tables) and deploy vb6 exe on each client along with front end DB of ms access having all tables link to Back end shared DB after splitting database?

In our project we have some master tables which are rarely updated so can we include this master tables in each user's front end DB ? Will it provide performance gain ? However in sql queries master tables has to refer other transaction tables via joins. Transaction tables has to be reside on back end part of DB.

So can anybody advice for our project is splitting ACCESS DB will help in performance or we should keep it as network share set up.

What is right way of implementing VB6 as front end & MS access as back end under multiuser environment.

Is it necessary to deploy vb6 exe on each client ? If so how we can do that ? Is by System DSN of File DSN can we do it ? What is right approach of set up.