UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Dsn, Any Version    
 
   
access2009eg
post Aug 19 2019, 07:20 PM
Post#1



Posts: 1,121
Joined: 19-February 08



Hello Friends;

If I have access as front end and SQL server as backend on network

I create for example this file MyConnection.dsn on one computer

every computer on the network should have this file MyConnection.dsn

how ms access recognize this file? put in my documents or something else

how to attach this file to access

I don't do this task before?
Thank you






--------------------
I would like to Thank you for your help
Go to the top of the page
 
DanielPineault
post Aug 19 2019, 07:26 PM
Post#2


UtterAccess VIP
Posts: 6,853
Joined: 30-June 11



I'd suggest you review http://www.accessmvp.com/DJSteele/DSNLessLinks.html and/or https://support.microsoft.com/en-ca/help/89...inked-tables-in

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
theDBguy
post Aug 19 2019, 08:18 PM
Post#3


Access Wiki and Forums Moderator
Posts: 76,316
Joined: 19-June 07
From: SunnySandyEggo


Hi. If I remember correctly, if you use a file DSN to link an Access database to a SQL Server backend, then you won't need to distribute the file DSN to your users. Of course, one way to check it is to give your working database frontend to one of the users for testing. Please let us know what you find out.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
DanielPineault
post Aug 19 2019, 08:25 PM
Post#4


UtterAccess VIP
Posts: 6,853
Joined: 30-June 11



Your memory does not deceive you theDBguy!

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
theDBguy
post Aug 19 2019, 08:27 PM
Post#5


Access Wiki and Forums Moderator
Posts: 76,316
Joined: 19-June 07
From: SunnySandyEggo


QUOTE (Daniel)
Your memory does not deceive you theDBguy!
It's just I don't have a way to do any testing at the moment, but that's what I seem to recall from reading one of Albert's posts here. Thanks!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Aug 19 2019, 11:29 PM
Post#6


UA Admin
Posts: 35,683
Joined: 20-June 02
From: Newcastle, WA


Access stores the connection information internally.

You can verify that with this SQL:


SQL
SELECT Connect
FROM MSysObjects WHERE CONNECT IS NOT NULL
ORDER BY CONNECT

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
isladogs
post Aug 20 2019, 01:26 AM
Post#7


UtterAccess VIP
Posts: 1,607
Joined: 4-June 18
From: Somerset, UK


I'd also recommend dsn less connections.
As well as the link already provided have a look at post 18 in this thread linking access to SQL server where I explained my approach with code. The method works equally well linking Access backends

--------------------
Go to the top of the page
 
dale.fye
post Aug 20 2019, 06:51 AM
Post#8



Posts: 160
Joined: 28-March 18
From: Virginia


And I have created an LTM add-in for Access and SQL Server, for use by developers, which eliminates the need to create the File or System DSN entirely. My code creates the links to SQL Server tables using a DSN-less connection from the get go.

It replaces the built-in Linked Table Manager for versions of Access through 2019.

--------------------
Dale Fye
Microsoft Access MVP 2013-2016
Developing Solutions, LLC
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th September 2019 - 09:58 PM