Adding to the ConnectionString - HOW ?

[Koorosh]

Hi everyone

I am trying to append a string to my access project's connection string.

CurrentProject.Connection.ConnectionString=
CurrentProject.Connection.ConnectionString & "Jet OLEDB:System
database=C:\workgroupInfo.mdw;"

I keep getting an error message saying: can't do this while the object is
open. I then add code to close the project's connection before appending to
its connectionstring. I still get an error message saying that the close
operation failed.

What gives?

Where in the project, and how do I append to the CurrentProject.Connection's
connectionstring?

 

[Douglas J. Steele]

AFAIK, the only way is to use a shortcut that provides the necessary
information. Once you've opened the database, it's too late.

 

[Koorosh]

Could you elaborate please? Thanks

AFAIK, the only way is to use a shortcut that provides the necessary
information. Once you've opened the database, it's too late.

 

[Koorosh]

Could you elaborate please? How can this be done through a shortcut?

Thanks

 

[Douglas J. Steele]

See http://office.microsoft.com/en-us/access/HP051888101033.aspx for how to
use command line options when starting Access. (Don't worry if you're not
using Access 2003: it's the same for all versions)

The specific option you need is /wrkgrp "G:\Folder Name\workgrp.mdw"