473,326 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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

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
14 2824
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
MLH
Yes, something like RAdmin would do. It
appears it will have to do.
Nov 12 '05 #3
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
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
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
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
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
"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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: djharrison | last post by:
Greetings, I have an Access 2000 database that I am using to connect to a SQL Server using a DSN connection. I would like to be able to have values written from the Access database to the SQL...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
8
by: John Baker | last post by:
Hi: I am URGENTLY in need of some book or web site OR tool that will help me integrate a relatively simple access application into a web page or pages. This is a time recording system (by...
9
by: Nathan Sokalski | last post by:
I am trying to connect to a Microsoft Access Database from my ASP.NET Application. I use the following code to create my connection string: cmdSelect.Connection = New...
5
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual...
2
by: Randy | last post by:
Hi,all I met one problem of connecting Access database in asp.net web program. I use ODBC link to Access, the connection string like "PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS...
1
by: raaman rai | last post by:
What is the method to access a MS Access Database located in a network server by client applications. Do we have to share the folder for the mdb file in the network as to make it accessible or do we...
2
by: HeMan_Speaks | last post by:
I m currently developing a java based application and want to know how can i make client access database located on the server?
16
by: Magda Balise | last post by:
So as everyone else I am new to PHP and I have been trying to create an amenity page for a B&B. I need folk to be able to select checkboxes and it fetches the info from the database. I posted the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.