Sad Der
accessd666 at yahoo.com
Tue Apr 3 06:25:05 CDT 2007
I need this because we need to set/check the databaseconnection from outside the database e.g. an ini file. If it isn't possible to reset the connection to another sql server, than we've got a problem.... As I said before. Throughout the code the CurrentProject.Connection is used to set the connectstring. I feel a Find/Replace comming on... Not something I would like to do because I have to test all changes. Sander PS: There are few changes (1-3) on the database per day but these can have major financial conseq. E.g. values below €100.000 are neglected!! --- Gustav Brock <Gustav at cactus.dk> wrote: > Hi Sander > > I don't think you can cut the connection belonging > to CurrentProject ... that would be like kicking > your own feet away. > I guess you need to create a new Connection object > and then use that for whatever your purpose is. > > /gustav > > >>> accessd666 at yahoo.com 03-04-2007 11:24:39 >>> > Hi, > > I need to reset the > CurrentProject.Connection.ConnectionString value for > my ADP (2002) > > When I try: > CurrentProject.Connection.ConnectionString = > strConnString > > I get the error: > Operation is not allowed when the object is open. > > This is true because the following returns false: > ?CurrentProject.Connection.State = adStateClosed > > So before setting the new connectstring property I > try > to close the connection but none of the below seem > to > work, although they do NOT return an error! > Application.CurrentProject.CloseConnection > CurrentProject.CloseConnection > CurrentProject.Connection.Close > set CurrentProject.Connection = nothing (?? just > trying) > > Goal: How can I set a new connect string? > > Regards, > Sander > PS: I asked this before and got some good answers. > Throughout the app several functions are used that > use > CurrentProject.Connection. These are called hundreds > of times!! I do not want to modify that code. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html