Access.Lockfile.9 - why???

[Jan Szymczuk]

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one date
field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I now
do not have exclusive rights to my own database! I have noticed that a
lockfile.9 file has also created. Please can you tell me how to remedy this
as I really like your calender option.

Jan

[Allen Browne]

The error message does not relate to the calendar control. It has no rights
attached, so it is not the cause of the message.

Access creates an ldb file when you open your database in non-exclusive mode
(shared). It should delete this file when it closes. If it crashes, the file
may be left there, containing spurious information. While Access is not
running, delete the ldb if you see it. Then try again.

You could also compact your database:
Tools | Database Utilities | Compact.

Hopefully that will get you going.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cq**********@hercules.btinternet.com...

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one date
field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I now
do not have exclusive rights to my own database! I have noticed that a
lockfile.9 file has also created. Please can you tell me how to remedy
this as I really like your calender option.

Jan

[Tom van Stiphout]

On Fri, 24 Dec 2004 16:53:44 +0000 (UTC), "Jan Szymczuk"
<sz******@btinternet.com> wrote:

Start Access (version 2000 and up) and don't select a db. File/Open.
Select your db, and click the down arrow next to the Open button and
select Open Exclusive.

Alternatively create a shortcut to your db which includes the
/exclusive argument.

-Tom.

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one date
field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I now
do not have exclusive rights to my own database! I have noticed that a
lockfile.9 file has also created. Please can you tell me how to remedy this
as I really like your calender option.

Jan

[Wayne Morgan]

Tom,

You are correct; however, but aware of the following.
http://support.microsoft.com/default...b;en-us;304528

--
Wayne Morgan
MS Access MVP
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:c5********************************@4ax.com...

On Fri, 24 Dec 2004 16:53:44 +0000 (UTC), "Jan Szymczuk"
<sz******@btinternet.com> wrote:

Start Access (version 2000 and up) and don't select a db. File/Open.
Select your db, and click the down arrow next to the Open button and
select Open Exclusive.

Alternatively create a shortcut to your db which includes the
/exclusive argument.

-Tom.

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one date
field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I now
do not have exclusive rights to my own database! I have noticed that a
lockfile.9 file has also created. Please can you tell me how to remedy
this
as I really like your calender option.

Jan

[Jan Szymczuk]

Hi Allen,
I have compacted and repaired my databaes as you suggested, I can run the
downloaded calender db from your website, ok, the problem I repeatedly have
is that when I import the two forms and the module from your calender db
over into my database I always recieve the following error...

The expression on Open you entered as the event property setting produced
the following error:Error accessing file. Network connection may have been
lost.

* The expression may or may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro.....

PS I am opening up my db in exclusive mode..

Jan
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

The error message does not relate to the calendar control. It has no
rights attached, so it is not the cause of the message.

Access creates an ldb file when you open your database in non-exclusive
mode (shared). It should delete this file when it closes. If it crashes,
the file may be left there, containing spurious information. While Access
is not running, delete the ldb if you see it. Then try again.

You could also compact your database:
Tools | Database Utilities | Compact.

Hopefully that will get you going.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cq**********@hercules.btinternet.com...

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one
date field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I
now do not have exclusive rights to my own database! I have noticed that
a lockfile.9 file has also created. Please can you tell me how to remedy
this as I really like your calender option.

Jan

[Wayne Morgan]

Jan,

If you don't have Office 2000 SP3 installed, you may have just run into a
nasty bug. For more information, see this article.

http://support.microsoft.com/default...b;en-us;304548

To fix this problem, the SaveAsText option for all objects will help. You
will find information on doing that here.
http://www.granite.ab.ca/access/corr...uptobjects.htm
http://www.access-programmers.co.uk/...p/t-66320.html
http://www.dbforums.com/t1080847.html
--
Wayne Morgan
MS Access MVP
"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cr**********@sparta.btinternet.com...

Hi Allen,
I have compacted and repaired my databaes as you suggested, I can run the
downloaded calender db from your website, ok, the problem I repeatedly
have is that when I import the two forms and the module from your calender
db over into my database I always recieve the following error...

The expression on Open you entered as the event property setting produced
the following error:Error accessing file. Network connection may have been
lost.

* The expression may or may not result in the name of a macro, the name of
a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or
macro.....

PS I am opening up my db in exclusive mode..

Jan
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

The error message does not relate to the calendar control. It has no
rights attached, so it is not the cause of the message.

Access creates an ldb file when you open your database in non-exclusive
mode (shared). It should delete this file when it closes. If it crashes,
the file may be left there, containing spurious information. While Access
is not running, delete the ldb if you see it. Then try again.

You could also compact your database:
Tools | Database Utilities | Compact.

Hopefully that will get you going.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cq**********@hercules.btinternet.com...

I'm creating a database in Access 2000 in XP Pro (SP2), I have
downloaded Allen Browne's pop up calender for use in my database, and
imported the forms: frmCalender, frmExample and the Module ajbCalender.
I have one date field (Date) on my main Access Input Records form, I
renamed it to txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I
now do not have exclusive rights to my own database! I have noticed that
a lockfile.9 file has also created. Please can you tell me how to remedy
this as I really like your calender option.

Jan

[Jan Szymczuk]

Thanks guys, especially you Wayne,

I have now run all three Office service packs in the correct order and
everything is running as sweet as a nut

Jan
"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cq**********@hercules.btinternet.com...

I'm creating a database in Access 2000 in XP Pro (SP2), I have downloaded
Allen Browne's pop up calender for use in my database, and imported the
forms: frmCalender, frmExample and the Module ajbCalender. I have one date
field (Date) on my main Access Input Records form, I renamed it to
txtStartDate and set the click button property to:
=CalendarFor([txtStartDate], "Select the date")but then I cannot save my
form (Input Records) with this new button, as Access informs me that I now
do not have exclusive rights to my own database! I have noticed that a
lockfile.9 file has also created. Please can you tell me how to remedy
this as I really like your calender option.

Jan