jdsouza
Board Regular
- Joined
- Jul 19, 2012
- Messages
- 105
I have an Excel project which uses MS ACCESS for data storage. Works fine.
The issue is that ...
The project is used by multiple persons in multiple locations, making synchronization of data tedious (each one has to export what they have done via proprietary files and similarly import changes made by others). I would like to shift the database file to a web server (may need to change to MySQL from Access). The Excel file coding has to be changed for connection string for this purpose.
Can someone help me with the syntax for connecting the Excel based software connection string for/from the present local hard disk resident MS Access file to an MS Access file (or possibly MySql file) resident on a web server? If MySql is to be used, migration is another thing which I am not familiar with.
The issue is that ...
The project is used by multiple persons in multiple locations, making synchronization of data tedious (each one has to export what they have done via proprietary files and similarly import changes made by others). I would like to shift the database file to a web server (may need to change to MySQL from Access). The Excel file coding has to be changed for connection string for this purpose.
Can someone help me with the syntax for connecting the Excel based software connection string for/from the present local hard disk resident MS Access file to an MS Access file (or possibly MySql file) resident on a web server? If MySql is to be used, migration is another thing which I am not familiar with.
