Reputation: 15
i would like to build an inventory manager application that would have two versions : 1. Would run on the desktop 2. Would run on windows mobile 6
I would like to have both these versions store and read data from a database that can be stored centrally either on a webserver or somewhere on the LAN.
I would like to know can i use Access as my backend database or sql server ? will windows mobile app be able to access it and read and write to it ?
Note : I would prefer to create only one database that will just store the details in the tables and do not need any other functionality. All functions such as save,edit,delete,search,filter etc with be done from the FRONT-END VB.NET interface ONLY
If you suggestion involves the use of 2 databases such as one for desktop version and one for windows mobile then please also tell me how would i sync the data between them.
Thanks!
Upvotes: 0
Views: 1034
Reputation: 41759
I both your devices are always connected, you can use SQL Server with both.
Upvotes: 1