Drew Wutka
DWUTKA at Marlow.com
Fri May 22 00:20:31 CDT 2009
I've used this process before. I was moving an Access BE to a SQL Server Backend, and in the process, I created a new backend .mdb that had these DSNless linked tables, so that 99% of the Front End stuff worked fine without having to have DSN's on the client machines. The only quirk I remember is that you couldn't 'relink' the tables, you had to delete the linked tables and recreate them if something changed. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, May 21, 2009 5:48 PM To: Access Developers discussion and problem solving Subject: [AccessD] Linked to SQL Server in a domain Guys, I am a tad out of my comfort zone here. I am working on a database that links to a SQL Server using ODBC. The database was "upgraded" by another company which is in the process of being fired. The links work but I do not know where the DSN file resides. I created a new database and a DSN for new tables that I created in that database and it works just fine for me, logged on to the server (which is where I work - remote desktop), but it does not work for another user that I have helping me test. Those new links to the new table gives an ODBC error when she just tries to open the tables directly in the table tab of the db window. I am assuming that is because the DSN file I used to do the link is not on her computer? Is that the way this works? How do I discover where the DSN file is for the database that existed already when I first got in? I tried looking at the TDF cnn data and it isn't referenced in there. I found this: http://support.microsoft.com/kb/892490 Which looks like the magic key. Does anyone use this code or something similar? Any comments, warnings? Unfortunately at this point I am not able to log in to any other workstation there to test this code from another workstation. I will have to get that figured out as well. Any help appreciated. -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.