[AccessD] A2000:Connecting to a Back End on a web site

Hi Darren

Oh, that's a little more than an e-mail ...

The simple method is to install an engine of your choice - MSDE, SQL Server 2003 Express, MySQL, Firebird (very small) - move your data to this (the upsize wizard will do it for SQL Server) and then connect to the server database via ODBC.

Many articles and books on this exist, some authored by our fellow listmembers.

/gustav

>>> darrend at nimble.com.au 23-08-2006 09:32:54 >>>
Hi Gustav

Excellent - how do I do this? -  Any ideas?

Many thanks
 
Darren
------------------

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, 18 August 2006 12:04 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] A2000:Connecting to a Back End on a web site

Hi Darren

That depends. One option is to put the data on a SQL server engine; most of
these can be connected to - easily - via TCP/IP.

/gustav

>>> darrend at nimble.com.au 17-08-2006 15:41:14 >>>
Hi Gustav

<sigh> 

Does this mean I have to learn ASP or some other language to send and read data
over the web?

<bigger sigh>

Many thanks
 
Have a great day
 
Darren
------------------


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, 17 August 2006 11:34 PM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] A2000:Connecting to a Back End on a web site

Hi Darren

That's what I mean ... I don't think read/write is doable.

/gustav

>>> darrend at nimble.com.au 17-08-2006 15:18:54 >>>
Hi Gustav

The Plan is - FTP an MDB to my website and try to connect to it with read AND
write access using an Access Front end

Can this be done?

I seem to remember it's "read only" from that thread (though I must admit I
haven't look at the thread in detail)

Many thanks
 
Darren
------------------
T: 0424 696 433

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, 17 August 2006 4:46 PM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] A2000:Connecting to a Back End on a web site

Hi Darren

If you mean "read the data from an mdb" on your website, look up the thread 
"ADO Save recordset format adPersistADTG" from June on how to save to this
format and read it again via ADO.

Or you could download the mdb to a local folder. Look up the thread 
"Read data off a live html table" from April on how to download a file. If this
is an mdb, relink its tables after the download.

/gustav

>>> darrend at nimble.com.au 17-08-2006 05:25:36 >>>
Hi All
 
I want to put an MDB on my website and have an Access2000 Front End connect to
it
 
Is this possible?
 
Anyone got any pointers, code, links or references they'd care to share?
 
MTIA
 
Darren