Hi rustyshock,
To my knowledge, there are two ways in which you can get remote access
to a SQL datasource using MS Access on Windows 98. Problem is, they
aren't easy.
The first and easier one is to set up a Personal Web Server and give
the database a web interface with ASP pages, from which you can run
SQL statements and get the results over the internet.
Personal Web Server Setup:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306898&ID=KB;EN-US;Q306898
ASP Pages Source Code Example:
http://www.webwizguide.info/asp/tutorials/connecting_to_a_database_pt2.asp
The second way you can get remote access is to create a ODBC
datasource for the database and then setup a ODBC Server.
You'll have to download and install Microsoft Data Access Components (MDAC) from
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
Then you'll have to create the ODBC data souce. This is done via the
Control Panel -> ODBC Data Sources. In that applet, you'll have to
create the datasource in the "System DSN" part. Please take note on
how do you name the data source, because it's going to be important
for the next step.
Once that is completed, you'll have to download and install an ODBC
server. I recommend ODBC Socket server, it's free and includes a COM
Client.
ODBC Servers
Shareware: http://www.easysoft.com/products/2006/main.phtml
Free: http://odbcsock.sourceforge.net/
When the ODBC Server setup is complete and the server is running, you
can now connect to the server using standard clients that support XML.
Using the data source name, the IP address and port, the clients can
now connect to the database and interact with it using standard sql
statements.
Cheeres
- Mike
You might wonder why is this a complicated issue. The answer is:
neither Windows 98 nor Access 97 are intended to be used as servers
for remote access, and when they're stressed enough (as in multiple
remote requests) they tend to fail and crash. |
