Can a MS Access front-end database be connected to the new SQL Express LocalDB backend on the same machine?
If the answer is YES, where do I find information about the driver/connection string?
This is what I’m trying to accomplish. I have a project that uses MS Access to collect data using stationary PCs located far from the actual data collection site. The use of Tablet PCs with the use of wireless network has been suggested to make data entry
more efficient so data collection is done at the point of inspection. The problem is that MS Access was not build to transmit data/be used in a wireless network environment, so my idea was to use the same MS Access front end (to save time by not building anther
FE and keep same interface for user) with a LocalDB as back end on the Tablet PC and have the LocalDB either at time interval send the data to synch to a network replica backend for everybody use.
If answer is NO, suggest a feasible approach with any other ...
Go to the complete details ...