Splitted Ms Access on internet

[Koen]

Hello,

 

For several years I'm a Ms Acces user. I'm running an application on my PC with splitted database on the same station. The problem is, that I only can use him at home. In the future, I would like to use the application on different PC's with te same database on internet. I have also knowledge of SQL en I can convert my Access tables to SQL tables.

 

Is there anyone who can explane how I should start this operation, step by step.

 

Tanks in advance

Koen

[Wizard]

I'm not a big expert on databases, but from a quick google search, this and this should help.

[Ashoat]

You'll need to install MySQL server on your computer. I'm not sure, but I think MySQL is only available on Linux. You'll need to setup remote access on your computer to HelioHost. If you use a router, you'll need to do a port forward of the MySQL port (generally 3306) over to the computer running the MySQL server.

[AverageJoe]

I used XAMPP to install mysql and php and configure it for me on windows. I don't use it anymore (I have mysql on debian now). It has good documentation and you should be able to easily set it up.

 

Hope it helps

 

Joe

[Wizard]

You'll need to install MySQL server on your computer. I'm not sure, but I think MySQL is only available on Linux. You'll need to setup remote access on your computer to HelioHost. If you use a router, you'll need to do a port forward of the MySQL port (generally 3306) over to the computer running the MySQL server.

They have MySQL for Windows, except only the older versions are free. The newest versions are like $200.

[Ashoat]

Lol... I guess it makes sense. The newest versions for Linux/Apache are still free though, right?

[Koen]

I read the google search from Wizard, it was interesting but I didn't found the information how to use Access as front end to a SQL database on the internet.

 

I have installed MsSQL server on my local machine. So I can use Access as front end to the local SQL database. Therefore I found the tool "Microsoft SQL Server Migration Assistant for Access".

 

Is there someone who knows how I can migrate my database to the SQL server on Heliohost and then use ms access as front end.

Please explain how I setup a remote access on my computer to HelioHost. I use a router.

 

 

Regards,

Koen

 

[Ashoat]

We don't offer MS SQL... sorry. You'll need to convert to either MySQL or PostgreSQL. Try exporting your MS SQL database, and then try importing it as a MySQL database. Since MS SQL's syntax is stricter, MySQL should be alright in importing. There might be some differences though - you'll have to deal with those.

[Kyougi]

Lol... I guess it makes sense. The newest versions for Linux/Apache are still free though, right?

MySQL is free for both Windows and Linux, as well as a variety of other OSes. Only the subscription-based MySQL Enterprise, which provides support and training along with a few enterprise-level tools, costs money. MySQL is licensed under the GNU GPL, so there really isn't any worry.

[Koen]

I found the solution. MySQL has a connector "MySQL Connector/ODBC 5.1" http://dev.mysql.com/downloads/connector/odbc/5.1.html#win32 With this tool it is possible to use MsAcces with MYSQL. I must say, in spite of some differences, everything is working great.

[Ashoat]

That's good to know, as some of our scripting languages/platforms (namely ASP.NET, but perhaps Perl and Ruby as well) don't have built-in MySQL libraries. They probably have ODBC libraries though.

[Koen]

there are more connectors:

 

Connector/ODBC: Standardized database driver Windows, Linux, Mac OS X, and Unix platforms.

Connector/J: Standardized database driver for Java platforms and development.

Connector/Net: Standardized database driver for .NET platforms and development.

Connector/MXJ: MBean for embedding the MySQL server in Java applications.

MySQL native driver for PHP - mysqlnd: The MySQL native driver for PHP is an additional, alternative way to connect from PHP 6 to the MySQL

Server 4.1 or newer.

 

look on the page: Connectors on Downloads. http://dev.mysql.com/downloads/connector/

[Trippin]

I'm sorry I'm probably not contributing to the subject, but I wanted to say another option instead of xampp would be to use Apache2triad. I just personally think it's a lot better and the web control panel it offers is a lot more robust.

 

I just wanted to let you know as it can be a pain to install each separately (apache, mysql, ftp, etc) and might help you test everything before you make the site live.