Darren DICK
darrend at nimble.com.au
Wed Aug 23 18:45:25 CDT 2006
Hi Gustav Thanks for the replies I do appreciate this is substantially more than an email Just confirming - I am not able to FTP an MDB to my website and connect to it (with read and write access) using an Access front end - Is that the case? If I want to connect to an MDB I have FTP'd to my web site (with read/write access) I have to connect using html or asp or some web language - Is that the case? If I want to use an access front end with (read/write access) over the internet - I have to connect to a say...SQL dB - is that correct? Many thanks Have a great day 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: Wednesday, 23 August 2006 7:37 PM To: accessd at databaseadvisors.com Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com