Client Server Database

[vaikz]

I've been task to make a client/server program. On the server side, there will be a centralized database. On the client side is an access program. These client's is on different locations, about a 100's. Here's what I want to do:

Clients side:


1. Client's program "ms access" can remotely update it's data, example: Products table, from the centralized database.
2. Client's program can make an entry of products sales locally.
3. At the end of the day, client's connect to the server to upload the product sales.

Questions:
1. Can access do this? if can, how? or give links how to get started.
2. on the server side, what is the best free database software that can met on this kind of design. Can you give any recommendation.
3. How to connect to a remote database and upload data from access?

Thanks in advance.

[Matrix]

PHP and mysql would be more suitable for your project.

[vaikz]

PHP and mysql would be more suitable for your project.

That's for my server, right?
Is it ok if I'm going to use ms access on my client's side? Do you have any idea how to connect access to mysql?

[Matrix]

If you use PHP, it would be a pure web application and the client can be any browsers. Take this forum as an example, the clients do everything through a browser, thus no client side deployment.

If you use Access, you can use ODBC to connect to MySQL, Google 'connect access to mysql'.

[vaikz]

If you use PHP, it would be a pure web application and the client can be any browsers. Take this forum as an example, the clients do everything through a browser, thus no client side deployment.

If you use Access, you can use ODBC to connect to MySQL, Google 'connect access to mysql'.

Thanks for that, Matrix. I think, I'll just use access on my clients side since they are not always connected to the internet. They will only connect to the server to update the data on the products and then send the sales data to the server at the end of the day.