Hi,
My app sets a variable, mPath, to the PATH of my Access database from an .INI file

Now I want to take the variable, mPath and alter the datPrimaryRS.ConnectString property at runtime to dynamically set the path to my database file
(In other words I can move the database to different directories and just change the INI file).

What is a good way to do this? Can the ConnectString property be altered at runtime?

thanx,
John Morga