Thanks John,
There wasn't a lock file present in the folder. I was able to make one code change and when I went to make a second change, I got the "do not have exclusive access" warning.
I also found a post referring to Adobe PDFMaker (which I have) causing a problem. I followed the instructions for that but, the problem still exists.
I have also tried the /decompile switch without success.
Darrell
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Darrell-
>
>
>
> First try: With the database closed, look in the folder where the database
> resides, and if there's a .laccdb file (or .ldb if older format), delete it.
>
>
>
> If you don't find the file, then come back again for another guess!
>
>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of D
> Sent: Tuesday, July 03, 2012 5:53 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Do Not Have Exclusive Access to Database
>
>
>
>
>
> Greetings All,
>
> My work computer was updated to Windows 7 and Office 2007 last week. The first
> few days everything was working fine. Now, whenever I attempt to make changes in
> a database I get a warnig that I "do not have exclusive access to the database
> at this time. If you proceed to make changes, you may not be able to them
> later." Also, while debugging at times, I will receive "The database has been
> placed in a state by user 'Admin' on machine 'PCND1164N8J' that prevents it from
> being opened or locked." when assigning the database object to a variable or
> attempting to execute an action query through code. Needless to say, that
> machine name is my computer, this is a stand-alone copy of the database on my
> local drive for development, and I am the only user in the database at the time.
>
> Does anyone have any ideas as to what may be causing this behaviour?
>
> Darrell
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar