Hi All,
I would like to share an access database with a few users spread all over the country. I have already split the database and ported the tables over to MySQL on my development computer and all is fine. I was hoping to upload the MySQL database to my web host and use an Access fe to connect to it. Now, before I go and spend many hours re-inventing the wheel, can anyone answer a few questions for me?
1: Is it possible to do what I am trying to do?
2: What is the best way to package the database for sending out to others who are not as computer literate as I am. I am aware that I will have to use Access run time for users that do not have access installed but I don't know the situation regarding the ODBC drivers.
I am using MySQl because that it what I have at the moment, if it is beneficial for me to move hosts to a MSSQL system I am happy to do so.
Thanks in advance for any info.
I would like to share an access database with a few users spread all over the country. I have already split the database and ported the tables over to MySQL on my development computer and all is fine. I was hoping to upload the MySQL database to my web host and use an Access fe to connect to it. Now, before I go and spend many hours re-inventing the wheel, can anyone answer a few questions for me?
1: Is it possible to do what I am trying to do?
2: What is the best way to package the database for sending out to others who are not as computer literate as I am. I am aware that I will have to use Access run time for users that do not have access installed but I don't know the situation regarding the ODBC drivers.
I am using MySQl because that it what I have at the moment, if it is beneficial for me to move hosts to a MSSQL system I am happy to do so.
Thanks in advance for any info.
