Link Access'97 on client to remote server with phpMyAdmin

C

Conqueror

phpMyAdmin is used to administrate MySQL databases in a web based environment.
1) Do I have to manually create a copy of my Access database in MySQL on the
server?
2)Or, do I have to manually create a copy of my Access database in MySQL on
my PC, the client?
For both 1 & 2 I expected activation through "Export" on Access's menu bar,
opening some form driven by ODBC.

MySQL 3.23.52 and the latest ODBC driver are installed on my PC.

3)Should MySQL open a form driven by ODBC. Can't discover an option for that
either.

If I get the database on the server, I would like to make it accessible
through a form on my web site. In doing so, trying to immitate e-Commerce.
For web site design I am using Frontpage 2003. Microsoft explains that you
will need a server with SharePoint Services installed. This will not be the
case with Servers offering hosting facilities for web sites, as I understand.
Will this mean, even if I am able to establish communication between Access
on my PC and MySQL on the server, that I will not be able to run active
e_Commerce pages on my web site?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC link to MySQL, can write, but not edit or delete 5
Problem with Import or Linked Tables with MySql 1
How to link Access to MySQL 1
odbc connection freezes when importing 0
Access 2000/2002 to MySQL link v_e_r_y s_l_o_w 4
Access for MySQL data reports only 5

Top