|
|
Posted by Dikkie Dik on 01/21/07 13:55
> i've got a mysql database with a research data. i would like to get
> some information from that database and save it as ms access database.
>
> it will be a client feature. the client clicks a button -> and
> downloads ms access database with a certain information from the master
> mysql database.
>
> is it possible in php? how?
Not really. But if it is always the same data, and if you do not mind
others to connect with one of your databases, there's an other approach:
You could make the exported tables accessible for others using normal
user management and imports these links through ODBC from MS-Access.
You can control what data is visible and what is not by giving access to
views, separate tables or even a separate database.
Those links can be either links or imports, so once a table is linked
from MS-Access, it can remain up-to date. The downside of this approach
is that you need MyODBC (can be downloaded from the MySQL site) on every
client that wants to link to your database.
Best regards
Navigation:
[Reply to this message]
|