A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linked Tables - Do I Need DNS on end users PC?



 
 
Thread Tools Display Modes
  #1  
Old March 27th, 2010, 05:25 PM posted to microsoft.public.access.forms
Andy Davidson[_2_]
external usenet poster
 
Posts: 1
Default Linked Tables - Do I Need DNS on end users PC?

Hi All,

I'm setting up an Access 2007 database as a reporting database from
feeds from Lotus Notes/Domino Server and I'm running into a ODBC
'DNSname' Connection Failed error.

Here's the details:

Server 1 Running Domino Server/Lotus Notes

Server 2 Running Access 2007 Database for reporting from Lotus etc.
I've installed the Lotus NotesSQL Driver and created System DNS's for
each odbc feed from Lotus. I've linked in several tables from Lotus
and this is working fine. I've created reports from these tables and
it's fine; tables refresh, reports open - all is good. I've also
created some Excel spreadsheets that link (via odbc) to the Access
database and refresh and pivot table the linked tables etc. Again,
this is working fine, no errors.

The Problem

As soon as i move the linked spreadsheets off the Access server PC and
put them on end users PC's, whenever I try to refresh the data I get
the error "ODBC 'DNSname' Connection Error". Where DNSname is one of
the DNS's created on the Access Server PC.

To recap its:

Server 1 Lotus Notes
Server 2 Access backend with linked tables from Lotus using DNS's
Front End User PC with linked Excel spreadsheets pointing back to Server 2 Access backend

The front end PC's report an error with the DNS's on the server 2.
However the data open's fine on the Server 2/Access table.

As a test I imported a table into Access and it opened fine into Excel
on end user PC.

So the route should be: (Server 1) Lotus Data (Server 2) Data
linked into Access Backend (End User PC) Excel Report linked back
to Access backend - fails on any tables linked into Access / Works
fine with non-linked tables.

Should i need to setup the same DNS's on end users PC that are on the
Server 2?

I thought once the data was linked into Access, I would only need
Access odbc to sent it to Excel? So end users would only need Access
odbc? And not all the original DNS's that feed Lotus into Access
backend?

Any ideas or comments most appreciated.

Many thanks for your time,

Cheers,

Andy D.



  #2  
Old March 28th, 2010, 11:42 AM posted to microsoft.public.access.forms
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Linked Tables - Do I Need DNS on end users PC?

hi Andy,

On 27.03.2010 17:25, Andy Davidson wrote:
I thought once the data was linked into Access, I would only need
Access odbc to sent it to Excel? So end users would only need Access
odbc? And not all the original DNS's that feed Lotus into Access
backend?

It should work DSN-less:

http://www.accessmvp.com/djsteele/DSNLessLinks.html
http://connectionstrings.com/lotus-notes


mfG
-- stefan --
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.