link table - Microsoft Access / VBA

bsn

--
Hello NG

Is it possible, to link a table, between 2 Access databases, when the
databases is on an extern webserver...

Hilsen
Bjarne
"Every day new surprises"

Jan 13 '07 #1

Subscribe Post Reply

1187

Rick Brandt

"bsn" <bsnSNABELAoncableDOTdkwrote in message
news:45*********************@dread11.news.tele.dk. ..

>

--
Hello NG

Is it possible, to link a table, between 2 Access databases, when the
databases is on an extern webserver...

No. You need to able to actually see and open the file as on a local drive or
network. None of the internet protocols allow that.

If you can set up a VPN to the remote server that would solve this first
technical hurdle, but generally a WAN connection is way too slow to use Access
like that effectively. Not to mention that a WAN connection is less reliable
and would end up corrupting the file.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Jan 13 '07 #2

bsn

"Rick Brandt" <ri*********@hotmail.comskrev

>Hello NG

Is it possible, to link a table, between 2 Access databases, when the
databases is on an extern webserver...

No. You need to able to actually see and open the file as on a local
drive or network. None of the internet protocols allow that.

Ok, then I have to solve it with ASP...

Thanks
Bjarne

Jan 13 '07 #3

Similar topics

onChange of listbox to update link?

by: John Doe | last post by:

I have a PHP page that generates a list box with several options in it. I would like to have a "view" link next to the list box. When the user changes the contents of the list box, I would like...

Javascript

empty table cell to be used as link

by: Greg N. | last post by:

Hi folks, I have a table cell with a background image, something like <td background=landscape.jpg height=200></td> The sole purpose of this code is to display the image inside that table...

Javascript

Link SQL table through VB Code

by: Bruce Lawrence | last post by:

I have an Access97 database and I would like to link a SQL table to it without having to create a manual ODBC connection on every system that needs to use this database. This is what I have so...

Microsoft Access / VBA

Windows Forms, Data Grid, and Link Buttons

by: Paul Yanzick | last post by:

Hello, I have a Windows form with a datagrid control, and would like one column to appear as a hyperlink, so when clicking on it, it will open IE and go to the web. Unfortunately, I cannot find...

C# / C Sharp

Update a counter when a link is clicked

by: Ian Davies | last post by:

Hello I have seen some tutorials to put a update a counter field in a record. I have the counter field in a table that also has a field for a path to file. I display the records in a table on...

PHP

Inlavid Operation ereror when refresh table link

by: Lisa | last post by:

I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...

Microsoft Access / VBA

Making a whole table a link

by: Martin Eyles | last post by:

Hi, I want to make a whole table a link, so that clicking anywhere on it takes you to another page. Unfortunately the way I initially thought of doing this involved invalid html. I have tried a...

HTML / CSS

Showing details for one specific record / Drag and drop files to get a link to them

by: Timbo | last post by:

Hi there, I’m not used to working in VB and I think this situation calls for excactly that. I use Access 97 SR-2. My first table is a table containing all the Tickets I got. The field ”Ticket”...

Microsoft Access / VBA

Link the FE to the BE using Code and Path/File

by: ApexData | last post by:

Hello I currently Link the FE/BE using the LinkTables Option and the Linked Table Manager. Any time I need to move the BE to another location, I have to go through this process over again. I...

Microsoft Access / VBA

Is there a way to manual type the FE/BE link?

by: perryche | last post by:

Is this possible? Instead of using the link wizard, can the FE/BE link be established any other way that users can simply type the link path? Thanks, Perry

Microsoft Access / VBA

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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...

Windows Server

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

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...

General

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...

Microsoft Access / VBA

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...

C# / C Sharp