Hello all,
Currently we are implementing an Access database which has to send some (not
much) data over a WAN. We are using an Access front end and an Access back
end. Basicly the front end runs local, but at the end of the session the
front end needs to write the data to the back end on the WAN.
The responsible IT manager asked me to use a ODBC linkage between the
database, since this sends smalles packages of data (which minimizes the
time out failure) instead of linking it directly (he told me that when a
drive mapping is done, the virus scanning causes to much data traffic). I
don't know if these assumptions are correct.
Since i'm no network specialist: Is it possible to create a ODBC on the
server and link it on the front end side? And more important: how does it
work? Has any body some ideas or literature for this kind of operation. When
I create a ODBC (system or/and DNS) and I want to link it in my Access
database I get a error that now data can be linked through a ODBC (it also
mentioned ISAM in it's error description, i don;t have it on me currently).
When I use my ODBC in Excel it works great, so the ODBC is fine, it only
doesn't work on a Acces front end?
I'm aware that an Access database is not the ideal backend source for this
kind of operation, but for now it has to do...in the nearby future we will
implement a DBMS.
Any help would be gladly appreciated,
Remco Groot Beumer
Holland
12  4324 
Access cannot use ODBC to communicate between MDB files.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Remco Groot Beumer" <in**@rgbplus.n l> wrote in message
news:c5******** **@news3.tilbu1 .nb.home.nl... Hello all,
Currently we are implementing an Access database which has to send some
(not much) data over a WAN. We are using an Access front end and an Access back
end. Basicly the front end runs local, but at the end of the session the
front end needs to write the data to the back end on the WAN.
The responsible IT manager asked me to use a ODBC linkage between the
database, since this sends smalles packages of data (which minimizes the
time out failure) instead of linking it directly (he told me that when a
drive mapping is done, the virus scanning causes to much data traffic). I
don't know if these assumptions are correct.
Since i'm no network specialist: Is it possible to create a ODBC on the
server and link it on the front end side? And more important: how does it
work? Has any body some ideas or literature for this kind of operation.
When I create a ODBC (system or/and DNS) and I want to link it in my Access
database I get a error that now data can be linked through a ODBC (it also
mentioned ISAM in it's error description, i don;t have it on me
currently). When I use my ODBC in Excel it works great, so the ODBC is fine, it only
doesn't work on a Acces front end?
I'm aware that an Access database is not the ideal backend source for this
kind of operation, but for now it has to do...in the nearby future we will
implement a DBMS.
Any help would be gladly appreciated,
Remco Groot Beumer
Holland
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
"rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
If you're willing to do everything through VBA, then yes, you can do that
(you can even query Access 2000 databases from Access 97 that way). That
means, though, that you're severely limited in terms of what you can do in
the Access front-end.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:bp******** ***********@new s01.bloor.is.ne t.cable.rogers. com... "rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
If you're willing to do everything through VBA, then yes, you can do that
(you can even query Access 2000 databases from Access 97 that way). That
means, though, that you're severely limited in terms of what you can do in
the Access front-end.
Well, the op only wanted to write data to the backend via ODBC so
ADO would be a solution. I guess not everything can be GUI driven
and automagical.
"Remco Groot Beumer" <in**@rgbplus.n l> wrote in
news:c5******** **@news3.tilbu1 .nb.home.nl: Currently we are implementing an Access database which has to send
some (not much) data over a WAN. We are using an Access front end
and an Access back end. Basicly the front end runs local, but at
the end of the session the front end needs to write the data to
the back end on the WAN. The responsible IT manager asked me to
use a ODBC linkage between the database, since this sends smalles
packages of data (which minimizes the time out failure) instead of
linking it directly (he told me that when a drive mapping is done,
the virus scanning causes to much data traffic). I don't know if
these assumptions are correct. Since i'm no network specialist: Is
it possible to create a ODBC on the server and link it on the
front end side? And more important: how does it work? Has any body
some ideas or literature for this kind of operation. When I create
a ODBC (system or/and DNS) and I want to link it in my Access
database I get a error that now data can be linked through a ODBC
(it also mentioned ISAM in it's error description, i don;t have it
on me currently). When I use my ODBC in Excel it works great, so
the ODBC is fine, it only doesn't work on a Acces front end?
I'm aware that an Access database is not the ideal backend source
for this kind of operation, but for now it has to do...in the
nearby future we will implement a DBMS.
Plain old ODBC won't work. ADO might work, but on a WAN, I wouldn't
recommend it.
Replication is another option as it actually matches the problem
description your boss gave you. However, Jet replication is *not*
for the faint of heart -- it has a steep learning curve and for
synchronizing over a WAN, you'd definitely need to use indirect
replication, which requires the Developer Edition (which comes with
Replication Manager and the low-level tools for implementing
indirect replication).
Another option would be to simply export the data required, get it
to the remote machine and then let that machine import it.
BTW, the "mapped drive letter" issue is a read herring, as you don't
have to map a drive letter to get access to files on your network.
UNC paths (of the form \\ServerName\Sh areName\File.md b) work just
fine. But on a WAN, that would nonetheless be a disaster waiting to
happen (though it depends on the total bandwidth -- anything
approaching 10mbps that is reliable would probably be safe).
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
I'm puzzled. How can I communicate from one .mdb to another .mdb via ODBC,
even using ADO?
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:Ye******** ******@newssvr1 5.news.prodigy. com... "rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
I'm puzzled. How can I communicate from one .mdb to another .mdb via
ODBC, even using ADO?
Carl Prothman has all sorts of ADO connection strings posted at http://www.able-consulting.com/ado_conn.htm including some that use ODBC
rather than Ole DB. As I indicated elsewhere in this thread, I've
successfully used this approach to read data from an Access 2000 database
from Access 97. It is, however, quite limited in terms of what you can do.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:JM******** ***********@new s01.bloor.is.ne t.cable.rogers. com... "Randy Harris" <ra***@SpamFree .com> wrote in message
news:Ye******** ******@newssvr1 5.news.prodigy. com... "rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in
message news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com...
> Access cannot use ODBC to communicate between MDB files.
>
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
I'm puzzled. How can I communicate from one .mdb to another .mdb via
ODBC, even using ADO?
Carl Prothman has all sorts of ADO connection strings posted at
http://www.able-consulting.com/ado_conn.htm including some that use ODBC
rather than Ole DB. As I indicated elsewhere in this thread, I've
successfully used this approach to read data from an Access 2000 database
from Access 97. It is, however, quite limited in terms of what you can do.
Sorry, I'm still trying to understand. I searched Carl's site, all of the
examples show local access to the .mdb (even when the .mdb is on a network
share), except for ASP server and MS Remote. He has this posted there as
well:
if MDB is located on a remote machine
- Or use an XML Web Service via SOAP Toolkit or ASP.NET
- Or upgrade to SQL Server and use an IP connection string
- Or use an ADO URL with a remote ASP web page
- Or use a MS Remote or RDS connection string
Is there a means of accessing data in a .mdb from a remote system other than
by use of a web server?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"rkc" <rk*@yabba.dabb a.do.rochester. rr.bomb> wrote in message
news:Vb******** ***********@twi ster.nyroc.rr.c om...
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:r5******** ************@tw ister01.bloor.i s.net.cable.rog ers.com... Access cannot use ODBC to communicate between MDB files.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
Can you not use ADO from within an .mdb file to communicate with
another .mdb file via ODBC?
Yes, you can setup and use a odbc connection string. However, you are NOT
communicating across the network using odbc. What happens is the following:
ADO---->ADO ODBC DRIVER---> DAO JET engine -->jet opens file
\\servername\my data.mdb
Note how JET is STILL getting a fully qualified path name to the back end.
So, yea..you are using odbc to connect to JET...but then jet is simply
opening the file across the network. This simply means that yes..you are
using odbc to connect to JET..but then jet uses the standard file share
ACROSS the network. (you are NOT sending sql across the network..since ONLY
a file share exists on the other end!).
So, no..you can't use odbc to connect to access database on another
computer. You can certainly specify a odbc connection...bu t then you are
telling JET in a different way to open the same file.
In all cases..you are still using a file share..and the file is being opened
ACROSS the network. There is NO performance advantage to this over a simple
linked table as a file share. Either way...jet opens the file across the
connection. Either way, the JET library and code resides on the CLIENT
COMPUTER.
So, the virus software..and all other stuff that occurs will STILL occur!
You can read the following article of mine as to why you can't use a wan: http://www.attcanada.net/~kallal.msn/Wan/Wans.html
--
Albert D. Kallal (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: Tom Jones |
last post by:
I need to access databases on both win2k and Linux systems but I have to set
up the DSNs under program control ... no uses using GUIs ...
Has anyone done this? if so can we discuss it either in here or offline?
thanks
Tom
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Remco Groot Beumer |
last post by:
Hello all,
Currently we are implementing an Access database which has to send some (not
much) data over a WAN. We are using an Access front end and an Access back
end. Basicly the front end runs local, but at the end of the session the
front end needs to write the data to the back end on the WAN.
The responsible IT manager asked me to use a ODBC linkage between the
database, since this sends smalles packages of data (which minimizes the...
|
by: Abhi |
last post by:
FYI:
This message is for the benefit of MS Access Community. I found that
this prblem has been encounterd by many but there is hardly any place
where a complete solution is posted. So I thought I should give back
to the community by posting our findings.
Thanks you all for all your help till now by posting problems and
their solutions.
~Abhijit
|
by: mattias192 |
last post by:
I cannot make sense of the ODBC error messages my VBA application
throws at me. I connect to an Access database of about 500MB in size.
First, there is the "Not enough space on temporary disk". This happens
when I insert many rows to my Access database. If I increase the ODBC
Buffer size from 2048kB to 8192kB the inserts seem to work fine.
When I try deleting the rows (still from my VBA application) it
complains about that...
| | |
by: byrocat |
last post by:
Up until now, I've been working with V& DB2 UDB databases, using
Embarcadero DBArtisan as my GUI tool. I also have other tools that I
use in my day-to-day job so running directly on the server via the CLP
is not a viable option.
I've just had a number of V8 DB2 UDB databases added to my task list.
Of course #1, the old V7 DB2 ODBC client software doesn't connect to
V7 databases.
|
by: Phil Reynolds |
last post by:
We are using SQL Server as a back end to an Access front end on a LAN using
ODBC linked tables. Users are periodically getting the "data has been
changed by another user" error, and it's causing them to have to re-enter a
lot of data.
The ODBC refresh interval has been left at the default (1500 sec) on all
computers. I'm wondering if maybe changing that to a much smaller number
(150 seconds?) would help alleviate the problem. Also, I'm...
|
by: Gary |
last post by:
Hello guys!
Bear with me, I am a newbie.
She is the Data Warehouse manager. She has about 50 users to use the
Oracle database from M$ Access via ODBC connection. All those users
have only SELECT privileges on certain tables. I built all the roles
and users for them and they work fine.
Then she asked "Why do YOU let them see all those system tables?",
|
by: mikerudy |
last post by:
I have an 3rd-party application that uses a SQL back-end, but uses
Access 2000 (linked tables all using the same DSN) as an
intermediary. We recently upgraded from SQL 7 to SQL 2005, which went
fine. Now, however, we want to setup SQL Mirroring to provide
automatic failover.
The mirroring works fine. In my test environment, the mirror server
becomes active automatically when the service is stopped on the
principal server. I can see...
|
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: 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,...
| | |
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...
|
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...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
