Another great place to look is www.freevbcode.com. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Saiful Sent: Wednesday, January 25, 2006 9:18 PM To: [email protected] Subject: [ms_access] Re: How to read DSN
Hi Rick, can you show me the example? --- In [email protected], "Rick Justis" <[EMAIL PROTECTED]> wrote: > > The best way to do it is in your program, have it set to connect to > the db without the dsn so it wouldn't matter if it was the same or not. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Saiful > Sent: Wednesday, January 25, 2006 9:04 PM > To: [email protected] > Subject: [ms_access] How to read DSN > > Dear friends, > > I have this problem. > > I have 1 server and many pc's linked to it. Every pc's have a > different system dsn name for the same database in the server. I have > created a little msaccess program to produce a report. > > The problem arise when I want to distribute the program. Since the dsn > name is not standard, it did not work when the program try to get the > table in server. > > How can I use vba in access to read the system dsn in each pc to link > the table. > > Thanks for all your help > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
