I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another
database on my web.
I have tried with "link tables" but do not succeed. Help please!
/Ove H,
4  1819 
On 18 Sep 2004 15:14:09 -0700, ov**********@me rga.se (Ove) wrote:
This is not possible over HTTP or FTP.
Perhaps you can access the website using Windows Terminal Services?
If you just want to make changes to the data, you could of course
write an Admin interface which would allow browsing and editing the
tables. If you search the Internet, you may well find some ASP pages
pretty much ready to go.
-Tom. I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another
database on my web.
I have tried with "link tables" but do not succeed. Help please!
/Ove H,
Tom,
Could you describe what an Admin interface is and how it works.
Thanks!
Linda
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:qf******** *************** *********@4ax.c om... On 18 Sep 2004 15:14:09 -0700, ov**********@me rga.se (Ove) wrote:
This is not possible over HTTP or FTP.
Perhaps you can access the website using Windows Terminal Services?
If you just want to make changes to the data, you could of course
write an Admin interface which would allow browsing and editing the
tables. If you search the Internet, you may well find some ASP pages
pretty much ready to go.
-Tom.
I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another
database on my web.
I have tried with "link tables" but do not succeed. Help please!
/Ove H,
On Sat, 18 Sep 2004 23:41:58 GMT, "Linda" <lk****@earthli nk.net>
wrote:
Well, you would surf to www.mysite.com/admin
There you find a login page - to keep everyone but approved users out.
Once in, you would find a list of all tables, and upon selecting one,
you are presented with a grid to browse the data and to edit it.
Implementing this is very doable, especially if you can find some
starter pages on the web.
-Tom. Tom,
Could you describe what an Admin interface is and how it works.
Thanks!
Linda
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:qf******* *************** **********@4ax. com... On 18 Sep 2004 15:14:09 -0700, ov**********@me rga.se (Ove) wrote:
This is not possible over HTTP or FTP.
Perhaps you can access the website using Windows Terminal Services?
If you just want to make changes to the data, you could of course
write an Admin interface which would allow browsing and editing the
tables. If you search the Internet, you may well find some ASP pages
pretty much ready to go.
-Tom.
>I have one Access 2000 DB on my website. I want to access these tables
>from my local database so i do not need to down-/upload the database
>each time i want to make changes.
>
>Meanwhile i want a external partner to access (just read) another
>database on my web.
>
>I have tried with "link tables" but do not succeed. Help please!
>
>/Ove H,
"Ove" <ov**********@m erga.se> wrote in message
news:3a******** *************** ***@posting.goo gle.com... I have one Access 2000 DB on my website. I want to access these tables
from my local database so i do not need to down-/upload the database
each time i want to make changes.
Meanwhile i want a external partner to access (just read) another
database on my web.
I have tried with "link tables" but do not succeed. Help please!
When you link tables, you must be able to "browse" on your network to the
file of your choice. So, the way to make this work is to setup networking
between your computer, and that web server. So, you need that other computer
to appear on your local network (just like you can network a few computers
together through a hub). This is usually called a VPN (virtual private
network). When you make a VPN, then all computers will appear in "my
network". In fact, the computers can be all over the world, but appear as a
nice little happy network.
So, to "link" a front end to the back end, you have to be able to browse to
the folder via "my networks". If you can't simply browse, and look at
folders via your network neighborhood, then you can't browse to the files
when you try and link.
Of course, the problem with is approach is that your connection is 100 times
slower over the web (and I am taking a t1, or a high speed internet).
There are some solutions to this problem here: http://www.attcanada.net/~kallal.msn/Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.attcanada.net/~kallal.msn This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: EJO |
last post by:
Using an MS A2K front end running on WinXP and ODBC connections to SQL
Server 7 on Win 2K server; there are about 10 users who access the
front end via Terminal Server and use the same front end; there are
about another 10 users who run a copy of the db on their local machine.
SQL server has 2 databases, with approx. 20 tables between them (one
is for processing ckts from a remote sql server for local use, the
other is a site database).
...
|
by: Sam |
last post by:
Hey,
Basically the code below, should first create a database and then copy
the tables from one external database to this newly created database.
At the moment I am using a third access database file to perform this
task, (I would code it in VB, but we don't currently own a version).
This code works a treat if you copy the CurrentDB where the code is
running to a new database, but I need the code to access another
database, the code I...
|
by: alkhatib |
last post by:
Hi Experts,
I'm working on Win2k platform, where a process is wrinting to a log
(plain text in tabular form) .
My goal is to view this grawing log on access database, I linked a
|
by: ddsvi78 |
last post by:
I am a complete idiot when it comes to access. Now that said, I work
for a computer security company and one of our customers came to us
with an access problem.
They had been running fine for a long time. Then about a month ago
there main server that hosted all the .mdb files crashed. So they
restored everything to a new server (I believe 2003 server).
Everything was fine for 2 weeks, then one morning they came in and the
queries were...
|
by: Rob |
last post by:
Hi,
I am working on a project that requires a Windows Service which
performs the following file transfer functions.
1. It monitors a specific local directory on a Windows 2003 Server.
2. When it finds files with a specific extension, it queries a SQL
Server database to determine what workstation will be the destination
of a File.Copy.
3. It copies those files to the appropriate workstations on the LAN,
| | |
by: Daniel |
last post by:
Is it possible to retain local file system read, write, delete access while
impersonating for access to a remote drive in a different domain? I need to
be able to move files from a local computer to a remote computer. do i have
to copy them from the local computer to the remote computer then delete them
fromt the local computer after undo-ing the impersonation? Or is there a way
to retain access to both the local computer and the remote...
|
by: Anonymity25 |
last post by:
Hello,
I am continuing to update the front-end of a split DB. I update a local
copy of the FE which is tied to a standalone copy of the BE. I am
trying to automate the 'go-live' procedure for distributing the FE to
my users.
I want to:
Copy the FE from my desktop, where I work w/ the local copy, to C:\Data
(where shortcuts on all user PCs point to, as well as my live
shortcut). The new file should then refresh all linked tables so that
|
by: iitt2007 |
last post by:
I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server) using SQL scripts.
I tried following :
select * into TEMP_PLAN_CODE FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 10.0;Database=D:\Placodes.xls;HDR=YES',
'SELECT * FROM ')
but it's giving me an error :
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0'...
|
by: Brian Nelson |
last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm
just stuck!
We've had a multiuser .mdb file on a network share for years. I know
it's not ideal, but it's worked well from Access 2000 to 2003. Ever
since we upgraded to 2007, we've noticed some serious bloating.
When we were on 2003, after a fresh compact, the database would be at
about 20 MB. After normal use it would grow to about 25 MB and then
significantly...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
