file opens invisibly

P

Pete Merenda

When I launch (double click) my Access file from Windows Explorer, I get an
hourglass, the .ldb appears in the folder -- but Access does not open at all.
In fact I can't close the file without re-booting.

Should I assume it's corrupt? Any ideas for repair? It's a back-up, yes,
but has a couple of unique items I'd like to access.
 
P

Pete Merenda

I understand the .ldb. Again, the .ldb appears in windows explorer, thereby
indicating that the file is open, however neither the Access application nor
the file launches -- despite the .ldb being open. Any ideas why?
 
K

KARL DEWEY

Try holding down the shift key when opening to stop an autoexec from
functioning.
 
A

Arvin Meyer [MVP]

Yes, you exited prematurely, with an error. Access didn't close properly and
thus didn't clean up after itself.

It is also possible that there's code that isn't cleaning up after itself
and is leaving an open recordset. If that's the case, pressing Ctrl+Alt+Del
will bring up the Task Manager and you'll see msaccess.exe in the open
processes tab. You'll then need to correct your code to explicitly close all
recordsets and refer to all boolean controls with explicit syntax:

Not:
If chkBox1 Then
but:
If chkBox1 = True Then
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top