server compatability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

threademporium - 19 Jul 2007 19:56 GMT

I want to route my form results to a data base, i have 'access' so I wanted
to use that . I checked with my server host whether they had microsoft data
access components - they informed they didnt as it was a linux server but
they had a window server that handle ODBC drivers or i could use MYSQL on
either server.

what is OBDC
does there answer suggest i cannot or can use 'access' on their server?
what is MYSQL?

Thanks for taking a look at my question
Dave

Reply to this Message

Douglas J. Steele - 19 Jul 2007 20:06 GMT

MySQL is a (free) server-based database management system (just as SQL
Server and Oracle are, although it's not in the same league as those two).

ODBC stands for Open Database Connectivity, and is a standard method that
allows you to use SQL queries to access data. Access is capable of using
ODBC to connect to many different DBMS, include MySQL.

How are you intending to use Access, though? Mentioning "server host" makes
me think that you're considering a web application. Access isn't appropriate
for that.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I want to route my form results to a data base, i have 'access' so I wanted
> to use that . I checked with my server host whether they had microsoft
[quoted text clipped - 9 lines]
> Thanks for taking a look at my question
> Dave

Reply to this Message

threademporium - 19 Jul 2007 20:44 GMT

I wanted to use the access database to capture results and then review data
from a customer feedback form. This in itslef is a task i set myself in order
to learn how to utilise a database within a web environment. Eventually I
want to use a database to store product information in a web environment.
I am using Frontpage tutorial books from my library - they make no mention
of this aspect of access not being suitable for the web - there are pages and
pages of info on how to use them with frontpage for all kinds of things.
Thanks for letting me know.

Dave

> MySQL is a (free) server-based database management system (just as SQL
> Server and Oracle are, although it's not in the same league as those two).
[quoted text clipped - 20 lines]
> > Thanks for taking a look at my question
> > Dave

Reply to this Message