ADP Connection properties "ZRexRider" <jerryg[ at ]ptd.net> 02.12.2005 19:05:33 Hi, I have a function that checks the ADP SQL connection using: CurrentProject.Connection.State I trap the error and return FALSE. I would like to present the user with some detailed information regarding the connection string that was used to attempt the connection. I find that I cannot use: CurrentProject.Connection.ConnectionString Since it seems to go out and try to connect to the DB again. However, I can go to the MS Access Menu (File|Connection) and view some values in the "Data Link Properties". Is there a way that I can access those properties so I can include their values in my error message"? Thanks

Re: ADP Connection properties "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> 03.12.2005 13:22:05 Hello, You wrote on 2 Dec 2005 11:05:33 -0800: Z> connection. I find that I cannot use: Z> CurrentProject.Connection.ConnectionString Z> Since it seems to go out and try to connect to the DB again. Z> However, I can go to the MS Access Menu (File|Connection) and view Z> some values in the "Data Link Properties". Z> Is there a way that I can access those properties so I can include Z> their values in my error message"? currentproject.baseconnectionstring Regards

Re: ADP Connection properties "ZRexRider" <jerryg[ at ]ptd.net> 06.12.2005 00:20:14 exactly! Thanks