Connect to web database - Microsoft Access / VBA

How can I connect to my online database? I have all the paths etc... I
can't even think where to begin, what would be great would be a front end on
my PC connected via ftp to my backend at my ISP.

Or is this just ridiculous and impossible??

Jon

Nov 12 '05 #1

Subscribe Reply

4985

Larry Linson

FTP -- File Transfer Program is for transferring files (that is, uploading
to a website or downloading from a website), and it does that very well. It
has no provision for connecting your front-end database to a back-end
database at the website.

Unless you have some very exceptional, very, very high-speed connections, it
is not feasible to use a split Access database across the Internet.

There are a number of ways to use that database, but your Access front-end
isn't one of them.

Larry Linson
Microsoft Access MVP

"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message
news:bn******** **@sparta.btint ernet.com...

How can I connect to my online database? I have all the paths etc... I
can't even think where to begin, what would be great would be a front end on my PC connected via ftp to my backend at my ISP.

Or is this just ridiculous and impossible??

Jon

Nov 12 '05 #2

That confirms that then - thanks...
Without the ins and out of it could you say what those 'number of ways' are
please?

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:aa******** **********@nwrd dc02.gnilink.ne t...

FTP -- File Transfer Program is for transferring files (that is, uploading
to a website or downloading from a website), and it does that very well. It has no provision for connecting your front-end database to a back-end
database at the website.

Unless you have some very exceptional, very, very high-speed connections, it is not feasible to use a split Access database across the Internet.

There are a number of ways to use that database, but your Access front-end
isn't one of them.

Larry Linson
Microsoft Access MVP

"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message
news:bn******** **@sparta.btint ernet.com...
How can I connect to my online database? I have all the paths etc... I
can't even think where to begin, what would be great would be a front
end on
my PC connected via ftp to my backend at my ISP.

Or is this just ridiculous and impossible??

Jon

Nov 12 '05 #3

Iain Miller

"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message
news:bn******** **@titan.btinte rnet.com...

That confirms that then - thanks...
Without the ins and out of it could you say what those 'number of ways' are please?

Some kind of thin client application - Citrix ?

Nov 12 '05 #4

Similar topics

4801

Connect to MySQL

by: Mr Dygi | last post by:

Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " . mysql_error()); echo "Connected successfully"; mysql_close($link);

PHP

4791

Reuse Connect dialog box on forms 6i run time to connect to another database

by: DAVID | last post by:

Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality on forms run time again? I mean, I want to make a window with three screen items for username, password and service name. And on run time after connecting to the database I use this window to reconnect to an other database. So when I give the appropriate information, I will connect to the

Oracle Database

6057

Specify port no to connect to Informix Database through ODBC

by: Lee | last post by:

Hi, I'm developing a socket program to connect to Informix database through the ODBC. In here i called my socket program as "tap" . My tap will listen for data from unix through port 1070. After checking of the data, tap will then insert the data to the informix database. I know we can point the tap to one specified port in Informix database through the services file. My question is how should i know to which port my tap program send out...

C / C++

5589

HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server

by: Scott Holland | last post by:

HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server -- I am experienced in ORACLE and a novice at DB2. What tools would be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to connect to a database on a remote box (either AIX or AS/400)? I have read that DB2 Connect appears to be the ticket for the Db2 server if it is on AS/400 or OS/390. What if it is on AIX? Does the same tool...

DB2 Database

6459

Connect to remote server using db2 and Perl

by: banz | last post by:

Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to define the servername / hostname in my Perl Progrem.. Here is the code:

DB2 Database

4558

best way to connect to a database?

by: Jassim Rahma | last post by:

I would like to know what is the best way to onnect to connect to a database in general which provides you with full functionality & fast access? Best Regards, Jassim Rahma *** Sent via Developersdex http://www.developersdex.com ***

C# / C Sharp

2040

how to connect to an Access DB from a webfarm?

by: GNoter | last post by:

Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2; they are not part of a domain. I have a third server, Server3, which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well as on the internal intranet. I can connect via the intranet because the DB file is on the same box from which the intranet is being served...

.NET Framework

2317

unable to connect to sql db

by: Steve | last post by:

I moved my database from one server to another SQL server. I did a backup and restore of the database. I can connect to the database on server A from my asp.net app but when I try to connect to my database server B, I'm gettting 'login failed for user 'username' I've added the username to the database on server B, I can open up SMS and connect to the database that way, but I can't connect from my asp.net web app. any suggestions on what...

ASP.NET

9785

how to use db2 connect server as a gateway to connect to mainframe db2 database

by: jeffhan | last post by:

we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect server and client, so client could access the database through the connect server? like that: db2client <--db2 connect server <--db2 mainframe database

DB2 Database

3120

db2 connect 4 minut delay after adding partitions

by: danfan46 | last post by:

Hi! I have a previous post on the subject that connect takes a long time. I uninstalled db2 completely. Installed V9.5 Installed fixpack 1 created das created an instance installed database sample.

DB2 Database

8196

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8705

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8637

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8504

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6125

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5574

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4092

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

1808

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1511

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General