CurrentProject.Connection Error

[Konstantin Loguinov]

Guys,

I'm about to throw my computer out of the window.

I have an Access database that works fine on multiple computers. However, it
gives me an error on a computer and I can't figure out what's going on. The
error is "The expression you entered refers to an object that is closed or
doesn't exist". The line that gives me the error is

Set cn = CurrentProject.Connection

I checked all references and everything seems to be checked including MS
ActiveX Data Object.

Where should I look next?

Thanks!

Konstantin

 

[M.L. Sco Scofield]

Try:

1 - Uncheck a checked reference
2 - Close the references dialog
3 - Reopen the references dialog
4 - Recheck the reference you unchecked
5 - Close the references dialog
6 - Recompile your project

This is easy to do and frequently solves the problem.

Let us know if this works.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Norman Yuan]

I think what you get is what exactly happend: the CurrentProject.Connection
is closed, probably because that computer cannot connect to the SQL
Server/MSDE specified in the Access project file. You should check the
connection on that computer.