Hi everyone! I'm back!
In the past I asked about setting up an Access front-end with a SQL Server backend, and the replies I got were quite satisfactory (pbaldy's was one of them.
A few days before I tendered my resignation, my boss had given me an assignment to create a system for a financial services company (it would be the second project related to money-lending I have ever handled).
Now, the client's requirement is to have its data centrally stored in a database located on a server in the client's main office, and all branches located in different provinces will enter transaction data into that database using some interface - which I thought of at first would be a VB. The branches and the main office computers will be linked via a VPN.
But because I know that the development of a VB interface (either an ASP.NET Web interface or Windows application) takes so long, I'm considering using Microsoft Access 2007 as my development tool for the interface instead. It will use linked tables that access the SQL Server over a VPN.
Is this setup even possible? I only have limited amount of time to finish this project. Have any of you guys embarked on a similar project? I really need your response.
Details:
Backhaul speed is 2 mbps.
Client speed is 384 to 1 mbps.
Number of clients is 8 computers.
Thanks a lot!
Jan