473,734 Members | 2,859 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 ODBC Problem

I have an Access 2003 .mde sitting on an SQL Server. The tables for
the application also sit on the Server. I'm having a problem with
ODBC on only one of about 10 machines. All the other machines using my
Access 2003 .mde see the linked tables without a problem. I've
configured the User DSN (under Control Panel, Administrative Tools)
tab to match what the other machines are set to, but this didn't work.
I keep getting an error message that ODBC failed. Does anything need
to be listed under the System DSN tab? Maybe something with the
drivers? The File DSN tab has different lists on the 10 machines, so
I'm not sure what to do with this.
Nov 13 '05 #1
26 6099
If you have multiple users logging in to the same .MDE on the server, you
significantly increase the probability of corruption of that .MDE. The very
strong recommendation of Microsoft and other knowledgeable parties is that
you give each user their own copy of the client; if running WTS or Citrix to
execute the Access clients on the server, still give each user their own
copy in separate folders. That isn't the answer to your current problem, but
if you distribute the front ends, you will likely eliminate _this_ problem
(but may face some different ones).

If distributing and updating client apps seems a daunting task, MVP Tony
Toews has a Front End Updater that is free for the downloading at his (very
helpful) site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
"Dragon" <xs*******@yaho o.com> wrote in message
news:3e******** *************** *@posting.googl e.com...
I have an Access 2003 .mde sitting on an SQL Server. The tables for
the application also sit on the Server. I'm having a problem with
ODBC on only one of about 10 machines. All the other machines using my
Access 2003 .mde see the linked tables without a problem. I've
configured the User DSN (under Control Panel, Administrative Tools)
tab to match what the other machines are set to, but this didn't work.
I keep getting an error message that ODBC failed. Does anything need
to be listed under the System DSN tab? Maybe something with the
drivers? The File DSN tab has different lists on the 10 machines, so
I'm not sure what to do with this.

Nov 13 '05 #2
Make sure that you have the same ODBCE DRIVERs on each machine.

A DSN contains the connection information. You can use
connection information stored in the mde (a DSN'less connection),
in a file (a file dsn) or in the registry somewhere.

The actual connection information used by Access will be a
combination of information from currently open connections,
information stored in the database, and the DSN if one is used.

You will only have currently open connections if you try to
add or change a connection while the mde is in use, so that
shouldn't matter.

If the users have different DSN's, or the content of the DSN's
is different, then they need to have their own copies of the
MDE. Otherwise the connection information will get confused,
because the stored connection information in the database will
get mixed up with the different DSN information.

If the connection information is different in any way, each
user should have their own copy of the MDE, which can be re-
linked to use the correct connection information.

User DSN's and File DSN's are stored differently. Each DSN
contains connection information. If you are using a DSN, you
certainly need to work out which DSN you are using. Is it a
file DSN? Or a User DSN? The DSN's which you are NOT using
don't matter. The one DSN that you ARE using (if you are
using a DSN) should be identical on all machines. Even if
you are using separate copies of the MDE, and re-linking on
each PC, you still should make sure that you don't have multiple
different copies of the DSN, because that is sure to confuse
you!

(david)

"Dragon" <xs*******@yaho o.com> wrote in message
news:3e******** *************** *@posting.googl e.com...
I have an Access 2003 .mde sitting on an SQL Server. The tables for
the application also sit on the Server. I'm having a problem with
ODBC on only one of about 10 machines. All the other machines using my
Access 2003 .mde see the linked tables without a problem. I've
configured the User DSN (under Control Panel, Administrative Tools)
tab to match what the other machines are set to, but this didn't work.
I keep getting an error message that ODBC failed. Does anything need
to be listed under the System DSN tab? Maybe something with the
drivers? The File DSN tab has different lists on the 10 machines, so
I'm not sure what to do with this.

Nov 13 '05 #3
"Sherwood Wang" <Sh****@waynesw orld.net> wrote
*Sherwood Wang MVP*
(is also sys eng, bs, ms)


(is sockpuppet of resident troll XMVP. is not Microsoft MVP. is source of
much bs.)
Nov 13 '05 #4

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:kY54d.241$ gu5.103@trnddc0 9...
"Sherwood Wang" <Sh****@waynesw orld.net> wrote
*Sherwood Wang MVP*
(is also sys eng, bs, ms)


(is sockpuppet of resident troll XMVP. is not Microsoft MVP. is source of
much bs.)

ok you make joke on my english mr larry linson. ok you say i not me. ok
you say i not mvp.

NOT ok give bad stupid advice to poor people! you idiot saying what you say
in thread about ts running many many many copy accesss mde. so very stupid
advise from phony mr larry linson bfd. all sockepuppets can eat you lunch!

*Sherwood Wang MVP*
Nov 13 '05 #5
Don, it is bad enough that you try to distract the participants from the
business of the newsgroup, but when you try to mislead them, using whatever
alias is your choice of the moment, that is, indeed, WRONG and, indeed, not
OK.

Pull your head out of the dark and get a life.
"Sherwood Wang" <Sh****@waynesw orld.net> wrote in message
news:1095824557 .xdnZALwb1D+LNh E7NmwKIw@terane ws...

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:kY54d.241$ gu5.103@trnddc0 9...
"Sherwood Wang" <Sh****@waynesw orld.net> wrote
*Sherwood Wang MVP*
(is also sys eng, bs, ms)
(is sockpuppet of resident troll XMVP. is not Microsoft MVP. is source of much bs.)

ok you make joke on my english mr larry linson. ok you say i not me. ok
you say i not mvp.

NOT ok give bad stupid advice to poor people! you idiot saying what you

say in thread about ts running many many many copy accesss mde. so very stupid advise from phony mr larry linson bfd. all sockepuppets can eat you lunch!
*Sherwood Wang MVP*

Nov 13 '05 #6
xs*******@yahoo .com (Dragon) wrote:
I have an Access 2003 .mde sitting on an SQL Server. The tables for
the application also sit on the Server. I'm having a problem with
ODBC on only one of about 10 machines. All the other machines using my
Access 2003 .mde see the linked tables without a problem. I've
configured the User DSN (under Control Panel, Administrative Tools)
tab to match what the other machines are set to, but this didn't work.


Not that this is likely to help you with your immediate problem but ...

I much prefer DSN-Less connections as it is one less thing for someone to have to
configure and one less thing for the users to screw up.

Using DSN-Less Connections
http://members.rogers.com/douglas.j....LessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafa...m&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/...BC_DSNLess.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #7

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:zf24d.5091 $Co1.5001@trndd c02...
If you have multiple users logging in to the same .MDE on the server, you
significantly increase the probability of corruption of that .MDE. The
very
strong recommendation of Microsoft and other knowledgeable parties is that
you give each user their own copy of the client; if running WTS or Citrix
to
execute the Access clients on the server, still give each user their own
copy in separate folders. That isn't the answer to your current problem,
but
if you distribute the front ends, you will likely eliminate _this_ problem
(but may face some different ones).

If distributing and updating client apps seems a daunting task, MVP Tony
Toews has a Front End Updater that is free for the downloading at his
(very
helpful) site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

Larry:

The part you wrote about running multiple client front ends on WTS or Citrix
is wrong. After all, that's why people buy WTS or Citrix--so they don't
have to run multiple copies! Also, I think Tony stole that front end
updater from me.

Arvin

Nov 13 '05 #8
Message-ID: <1095889669.GX6 nk50cdPbsA0kLZE bI1w@teranews>
X-Abuse-Report: http://www.usenetabuse.com
This message is a forgery by the troll.
The part you wrote about running multiple client front ends on WTS or Citrix
is wrong. After all, that's why people buy WTS or Citrix--so they don't
have to run multiple copies!
Wrong.
Also, I think Tony stole that front end
updater from me.


Absolutely wrong!

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #9

"Arvin Meyer" <No****@NoSpam. net> wrote in message
news:1095889669 .GX6nk50cdPbsA0 kLZEbI1w@terane ws...

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:zf24d.5091 $Co1.5001@trndd c02...
If you have multiple users logging in to the same .MDE on the server, you
significantly increase the probability of corruption of that .MDE. The
very
strong recommendation of Microsoft and other knowledgeable parties is
that
you give each user their own copy of the client; if running WTS or Citrix
to
execute the Access clients on the server, still give each user their own
copy in separate folders. That isn't the answer to your current problem,
but
if you distribute the front ends, you will likely eliminate _this_
problem
(but may face some different ones).

If distributing and updating client apps seems a daunting task, MVP Tony
Toews has a Front End Updater that is free for the downloading at his
(very
helpful) site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

Larry:

The part you wrote about running multiple client front ends on WTS or
Citrix is wrong. After all, that's why people buy WTS or Citrix--so they
don't have to run multiple copies! Also, I think Tony stole that front
end updater from me.

Arvin


mr arvin meyer so very much thank you! is a problem in ng with bad advice
yes? is most come from larry and tony i see. everybody is troll if when
they get caught wrong! is like tune somebody write on them--

Here comes Larry without a clue
Here comes Tony and Davey too
It's finger flip flippin' time
They think they're smart
And that's a real bad start

is so very true ok?

*Sherwood Wang MVP*



Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
3762
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
3
2752
by: Steve Farber | last post by:
I'm not especially new to databases and I have used ODBC before with other data sources, but I cannot seem to get Access 2003 to talk to MySQL 4.0.15. I have MySQL running with new tables defined, but I cannot get a connection to those tables via ODBC using MyODBC 3.51. Can anyone point the way? Many thanks,
0
1622
by: greg_s_007 | last post by:
Just wanted to share a solution I found to this common problem that I have not yet seen posted. I am in the process of migrating an application from NT/IIS 4.0/SQL 6.5 to Win2003. The SQL server and ASP web application are on separate servers in an NT domain. While migrating the web app to a Windows 2003 server (which is not in the domain), I was unable to connect to the database via ODBC using named pipes.
3
3083
by: Mike Wilson | last post by:
Is there a way to open an OLE DB database from within Access? I would like to use the Access GUI with its table and query explorer to examine a database only available through an OLEDB provider interface. I have seen several references on how to open an OLE DB database through VBA/ADO code but I wouldn't know how to go from there to actually have the database available in the Access GUI...
0
2059
by: vginders | last post by:
Hello, We have a legacy application which relies on an Access 97 database (upgrading is nog an option atm). As we are setting up a new server (Windows 2003), we started experiencing problems running that application after installing all required updates (Windows, Office, ..) It did work before updating, with a basic OS + application installation. Somewhere an update dit break things, but we do not know which one.
2
2709
by: David | last post by:
Hi, Has anyone had this problem ? I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11 standard log. I created my tables in MS Access, then exported them via ODBC to an externally hosted MySQL database (fasthosts) . I then import-linked
15
4637
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
18
9148
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft page "How to: Connect to Data in an Access Database"
3
2102
by: Salad | last post by:
With the database window open I click on Help, then click on "About Microsoft Office Access". A dialog window is presented and there are 4 buttons at the bottom right of the form. One is SystemInfo and when I press that I get a Summary dialog box of particulars. One of the options is Office 2003 Applications. If I press on the plus sign O2003Apps, I can drill down and select Access 2003 and drill down to its selections. In the...
0
9452
Oralloy
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...
0
9184
tracyyun
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...
0
8187
agi2029
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...
1
6737
isladogs
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...
0
6033
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();...
0
4551
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...
0
4813
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3262
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
3
2180
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.