By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

I would like to attach briefly to an Access 2.0 database located on a web server somewhere

P: n/a
MLH
I have a friend with a database application on a web server.
He has invited me to attach to it so I can extract data from
it periodically. I have a few questions...

1) I have a DSL connection to my ISP and I think my buddy
has one too. Can I establish an ODBC connection to his data-
base? What information would I need to gather that would
allow us to do this?

2) Can I "turn the connection on & off" at will? Are there any
drawbacks associated with leaving it on all the time.

3) If I can do this, can other people (who shouldn't be allowed
to connect) do it? If so, can we stop them?
Nov 12 '05 #1
Share this Question
Share on Google+
14 Replies


P: n/a
You cannot attach Access to an Access (Jet) database, of any version, in any
configuration, using ODBC.

I am not familiar with using ODBC drivers _across the Internet_, and fear
you can't do that, even if you are using something other than Access as a
client.

I know you can use remote access software across the Internet, so you might
investigate pcAnywhere, ReachOut, and others -- that would allow you to run
an application on that server and just do the input/view from your machine.

Almost anyone is much more knowledgeable about Virtual Private Networks than
I am, but that may be a possibility, either alone or in conjunction with
some other software -- perhaps a knowledgeable participant will step in here
and explain it to both of us.

Larry Linson
Microsoft Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:ph********************************@4ax.com...
I have a friend with a database application on a web server.
He has invited me to attach to it so I can extract data from
it periodically. I have a few questions...

1) I have a DSL connection to my ISP and I think my buddy
has one too. Can I establish an ODBC connection to his data-
base? What information would I need to gather that would
allow us to do this?

2) Can I "turn the connection on & off" at will? Are there any
drawbacks associated with leaving it on all the time.

3) If I can do this, can other people (who shouldn't be allowed
to connect) do it? If so, can we stop them?

Nov 12 '05 #2

P: n/a
MLH
Yes, something like RAdmin would do. It
appears it will have to do.
Nov 12 '05 #3

P: n/a
MLH
Here here! ASP will be the best solution. We can use it
to invoke some action queries to extract what's wanted.
I could use TransferDatabase to export any of the query
objects' data to move the remote objects' data to another
database on the remote server. When just the data I need
has been exported, I can FTP the mdb file here.
Nov 12 '05 #4

P: n/a
MLH
Could I access a Linux server for this application programmed in PHP
with MySQL as a backend. It's similar to SQL Server in a lot of ways
and with the MySQL ODBC driver, I'm told you can connect to it just
like SQL.

You can get the MyODBC driver from:

http://www.mysql.com/get/Downloads/M....exe/from/pick

I appreciate your comments.
Nov 12 '05 #5

P: n/a
MLH
Could I access a Linux server for this application programmed in PHP
with MySQL as a backend. It's similar to SQL Server in a lot of ways
and with the MySQL ODBC driver, I'm told you can connect to it just
like SQL.

You can get the MyODBC driver from:

http://www.mysql.com/get/Downloads/M....exe/from/pick

I appreciate your comments.
Nov 12 '05 #6

P: n/a
MLH
Could I access a Linux server for this application programmed in PHP
with MySQL as a backend. It's similar to SQL Server in a lot of ways
and with the MySQL ODBC driver, I'm told you can connect to it just
like SQL.

You can get the MyODBC driver from:

http://www.mysql.com/get/Downloads/M....exe/from/pick

I appreciate your comments.
Nov 12 '05 #7

P: n/a
MLH
Could I access a Linux server for this application programmed in PHP
with MySQL as a backend. It's similar to SQL Server in a lot of ways
and with the MySQL ODBC driver, I'm told you can connect to it just
like SQL.

You can get the MyODBC driver from:

http://www.mysql.com/get/Downloads/M....exe/from/pick

I appreciate your comments.
Nov 12 '05 #8

P: n/a
"MLH" wrote
Could I access a Linux server for
this application programmed in PHP
with MySQL as a backend. It's similar
to SQL Server in a lot of ways and with
the MySQL ODBC driver, I'm told you
can connect to it just like SQL.


I have not personally done so, but there have been numerous reports in
various newsgroups from people who have successfully used MySQL as a server
with an Access client. You still face the problem of connecting across the
Internet, however. Client-Server is a LAN thing, not an Internet thing, but
this is where Virtual Private Network software may be what you need.

If you mean, can you create with PHP a website that allows you to access,
read, and update a MySQL database from your browser, you can certainly do
that -- no ODBC, no Access needed.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
Nov 12 '05 #9

P: n/a
MLH
I have not personally done so, but there have been numerous reports in
various newsgroups from people who have successfully used MySQL as a server
with an Access client. You still face the problem of connecting across the
Internet, however. Client-Server is a LAN thing, not an Internet thing, but
this is where Virtual Private Network software may be what you need.

If you mean, can you create with PHP a website that allows you to access,
read, and update a MySQL database from your browser, you can certainly do
that -- no ODBC, no Access needed.


I gave it a shot, downloading and installing the driver. With Access
97, it works great! I'm extremely pleased with the speed and ease
of use. What I haven't been able to figure out yet is how to get to
it from Access 2.0. With 97, all I do is double click the remotely
attached table & up pops MySQL ODBC 3.51 driver DSN configuration
window. I just fill in name/pass/IP addr and - boom - I'm in there.
Its a peach of a program. I enjoy DBA rights & can push/pull data
with ease. I don't know how to get to it from Access 2.0 though.
Sure would appreciate some suggestions there.
Nov 12 '05 #10

P: n/a
MLH
Further explanation...

Once I got that ODBC driver installed, I tested Access 97 by going to
File > Get External Data >Link Table. Then I did this...

Choose ODBC from the file type, then when the ODBC window comes up
you'll need to create a new system connection:

Select the MySQL driver (usually second from bottom of list)
Name it whatever you want
server/host: 123.456.789.10
dbase: MyDBaseName (case sensitive)
user: UserName
pw: MyPassWordXXX

That's all it took. I don't know how to do the equivalent from within
Access 2.0.

Nov 12 '05 #11

P: n/a
MLH
What I've tried in Access 2.0 is to open a query in design view
and select the "Query" item from the menubar. Then choose
"SQL Specific" and "Pass-Through". Then, in the properties
box for the query object, I invoke the builder button for the
"ODBC Connect String" property. I'm then prompted to
specify an SQL Data Source. That's where I lose it. I
can't seem to input the parms (see prev post) needed.

Error: ODBC call failed... [MicroSoft] [ODBC DLL] Datasource not
found and no default ODBC driver specified.

I've tried stuff like the following for the ODBCConnectStr Property...
ODBC;DSN=ABCD;SERVER=123.456.789.10;UID=UserName;P WD=MyPass
where ABCD is the dBase name on the remote server.

Somehow, my syntax just isn't getting through. Should I be passing
something else for the DNS and SERVER assignments???
Nov 12 '05 #12

P: n/a
MLH
Larry, here's a snippet from Access 2.0 help
(not that you need it, mind you - others may appreciate it).
My problem is that I just don't know how to tell if, when I
installed Access 2.0, I chose to include ODBC support???

=============> Begin Snippet <===============
Before you can use an SQL database for importing, exporting, or
attaching, you must install the appropriate ODBC driver for this type
of database, and set up an ODBC
data source for the data.

You can install the SQL Server driver using the Microsoft Access Setup
program. You can also add, modify, and delete ODBC drivers and data
sources at a later time
using the ODBC Control Panel option (called the ODBC Administrator if
you are using Microsoft Windows NT).

Installing the ODBC Files

To include ODBC support on your workstation and install the SQL Server
driver, you must choose the Complete/Custom installation option in the
Microsoft Access Setup program and then choose the ODBC Support
option. For more information on setting up Microsoft Access on your
computer or on a network server, see Chapter 1, "Setting Up Microsoft
Access," in the User's Guide.
=============> End Snippet <===============

Nov 12 '05 #13

P: n/a
MLH
If I click Start, Run "c:\Access\Setup\Setup.exe", I can see
that ODBC Support is checked. Clicking "Change Option",
I can see that "SQL Server ODBC Driver" (1090K) was installed
and "MS Access 2.0 ODBC Driver" (1025K) was installed.

I really do believe that my chosen setup during installation
should be complete, as far as enabling ODBC support goes.
I don't know what to do from here.
Nov 12 '05 #14

P: n/a
Access 2.0 is "sixteen-bit" software, originally intended for the Windows
3.1 environment, and likely requires a 16-bit interface API for an ODBC
driver. I suspect your MyODBC driver, if it works with Access 97 is a
"thirty-two bit" interface, but I am not certain that is what the problem
is.

I can't remember the site where I once downloaded MySQL and MyODBC (which I
then didn't ever get around to trying), but such a site or a MySQL newsgroup
would be a good place to pursue issues about MyODBC. It would just be
happenstance if you encounter someone here who's tried using Access 2.0 with
current MySQL.

Larry Linson
Microsoft Access MVP

"MLH" <CR**@NorthState.net> wrote in message
news:o9********************************@4ax.com...
If I click Start, Run "c:\Access\Setup\Setup.exe", I can see
that ODBC Support is checked. Clicking "Change Option",
I can see that "SQL Server ODBC Driver" (1090K) was installed
and "MS Access 2.0 ODBC Driver" (1025K) was installed.

I really do believe that my chosen setup during installation
should be complete, as far as enabling ODBC support goes.
I don't know what to do from here.

Nov 12 '05 #15

This discussion thread is closed

Replies have been disabled for this discussion.