Access with Mysql

[patrickstrijdonck]

Hey all,

dunno is this is the right place to post if not, im sorry and this may be moved.

I want to create an access program but i need to access it from everywhere i am in the world,... so for that i need a server that can be reached,... because the access program is seperate from the access database (at the moment) i cant access it from outside my network.

so i was thinking to put the database in a Mysql database, now my question is:

Is it possible to create a Mysql database and let access use that database, or maybe is it possible to connect to the access database on my server from outside my network?


Ty in advance

Patrick

 

[lameid]

Things to think about...

Theoretically you should be able to use MySQL. Although you will need to learn about SQL Pass-Through (SPT) queries. They send a query to the server in it's native language (SQL Variant) and returns results. There can be a significant amount of work in doing this and then I'm not sure it will give you the performance and security you want.

I guess the questions are, how fast of an Internet connection can you afford on each end and what are their respective up and down rates (ISP's advertise the down rate... up is usually much slower on DSL or cable).

What are the security requirements?

How much data are you looking at?

Another possiblitiy would be to roll your own in terms of replication... then the question you have to answer is how current do you want the information to be?

This sounds like you may want a web application of some sort instead.