How do I access my website database (MS Access 2k on Win 2k) from my computer using ODBC? I want a local Access database with linked ODBC tables in it. I am already accessing another SQL Server over the Internet, but the process seems to be different.
The closest thing I can find on the web is accessing an Access database over a network, but I can't find anything about accessing one over the internet.
Access is a file based DB thus it's not possible to access it via TCP/IP directly. Even the ODBC driver (which is soley for non-MS apps) only supports direct file access. Ether wrap your access db with some web frontend or get a "real" database server.