Access 2007 CurrentProject.OpenConnection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

For your information Microsoft Engineer Jun Chen has confirmed the following
to be an issue with Access 2007.

Symptoms

The CurrentProject.OpenConnection method fails on repeated calls in Access
2007 with:

-2147467259 – The expression you entered refers to an object that is closed
or doesn’t exist.

Either of the following invocations cause the error:

CurrentProject. OpenConnection Ҡ(to reset the connection)
CurrentProject. OpenConnection connect string (to create a connection)

Environment

Windows XP SP2 or Windows Vista (Business), Office 2007 Professional

More Information

Whilst you are developing using the standard data link dialog or if in
production you prompt the user to logon with a custom logon dialog then you
may exprience this problem when you or the user logs on on, off and then on
again within a short space of time.

Following error -2147467259 the project will open in Read-Only mode this
occurs for both an .ADP and .ADE.

The current suggested work-around for custom logon dialog approach is to add
a small time delay before opening the connection, although, this is not
feasible if you are using the standard data link property dialog as is
usually the case when you are developing.

Hope this helps.

Guy.
 
Back
Top