Hopeed not to ask such a stupid question, but has anyone used an Access DB file on a remote Linux host without ODBC support (or MySQL).

Can it be done, and what does the conn string look like?

Many thanks, (hope right forum!).

Sorry to answer my own question. Again.
Thanks Tim Green for recent replies to earlier Q's.

"However, to answer your question. If your Web Host has ODBC Support compiled into PHP, and if they have UnixODBC installed, then it should be quite possible to connect to an access database via a DSN.
However, if they don't have UnixODBC support then it will be fairly difficult (and really beyond the scope of this forum) to sort that issue out. If, however, you MUST have access running at all costs, it is really up to you to impress on your host provider that they need to install UnixODBC (or equivalent).
When a PHP Script creates/reads/modifies a file with a .dat extension, more often than not these are simple CSV text files. Given the dat extension to make them more identifiable.

Sooo...I could use a .csv file, and what's the connection look like?

"You should read the ADODB documentation (check out the readme.htm file in your adodb directory in your website root). Alternatively visit adodb-csvlib.inc.php for more information."

alexC