Project Locked error message

[Dale Fye]

Everything was going along great this AM. Had to go to a meeting, so I
closed the application I was working on and went to the meeting. When I
returned, I got this "Project Locked" message when I tried to go into the VBA
editor.

I made several copies of the file, and have a backup from yesterday, but
have 3 hours of work in this and would rather not have to go back and
recreate several forms, reports, and queries. I then tried:

1. a compact and repair, no good.
2. JetComp, still no good
3. decompile, still no good
4. import into new db, still no good. Get a messag that I need a password
to import forms.

I thought I had seen a message about this a while back, but have not been
able to locate in the newsgroup or via Google.

Any help would be greatly appreciated.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Roger Carlson]

Two wild stabs:
1) Is it possible someone else has it open?
2) Go into Task Manger and see if Access is still open as a Process. If it
is, End the process.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[a a r o n . k e m p f]

good stuff.

Yes-- Access has bugs-- where it is quite easy to have a secondary
copy of the application _open_ but invisible.
This is a classic DAO bug (not cleaning up variables-- which is _NOT_
a requirement of VB it is only a requirement for DAO-- a _VERY_ buggy
library); and it has not been fixed in the past decade.

This is just yet another symptom that 'everyone needs to move from
DAO'.

If an object library-- is too buggy for real world usage-- then upsize
to SQL Server and ADO.

Thanks

-Aaron

 

[Dale Fye]

Thanks for the reply, Roger.

1. No, it's sitting on my C: drive
2. Nope, that's not it either

I think it may have to do with a corrupt digital signature (they make us
digitally sign almost everything that will run code around here, including
working copies). I've given up and am starting over from last nights backup,
but would appreciate any more suggestions anyone has.

--
Dale

email address is invalid
Please reply to newsgroup only.

 

[Roger Carlson]

Since the original post said nothing about DAO, I can't imagine why you're
blathering about it.

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com

message
good stuff.

Yes-- Access has bugs-- where it is quite easy to have a secondary
copy of the application _open_ but invisible.
This is a classic DAO bug (not cleaning up variables-- which is _NOT_
a requirement of VB it is only a requirement for DAO-- a _VERY_ buggy
library); and it has not been fixed in the past decade.

This is just yet another symptom that 'everyone needs to move from
DAO'.

If an object library-- is too buggy for real world usage-- then upsize
to SQL Server and ADO.

Thanks

-Aaron

 

[olhos bonitos]

Everything was going along great this AM. Had to go to a meeting, so I
closed the application I was working on and went to the meeting. When I
returned, I got this "Project Locked" message when I tried to go into the
VBA
editor.

I made several copies of the file, and have a backup from yesterday, but
have 3 hours of work in this and would rather not have to go back and
recreate several forms, reports, and queries. I then tried:

1. a compact and repair, no good.
2. JetComp, still no good
3. decompile, still no good
4. import into new db, still no good. Get a messag that I need a password
to import forms.

I thought I had seen a message about this a while back, but have not been
able to locate in the newsgroup or via Google.

Any help would be greatly appreciated.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[a a r o n . k e m p f]

uh.. because the 'I have a hidden instance of Access' is a DAO_BUG!!!

if your library is too buggy for real world usage-- then graduate to
ADO.

-Aaron

 

[Dale Fye]

Thanks, Chris.

I'll keep this in mind.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.