Re: Data issue

Hi Judith

I assume you mean .LDB, not .LBL :-)

I'm certain this would have nothing to do with your experiments with rich
text.

Have you checked for the other causes as I suggested? (Access crashing or
Access still runnung in the task manager after it has apparently closed)

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


"judith" <judith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3915B269-CD91-4F30-BB1D-6BB8A606A489@xxxxxxxxxxxxxxxx
Yes it is the .lbl file. This particular application has in the past left
a
lbl on the data file even when everyone closes out of the system. As this
didnt seem to happen very often I have just ignored it. But this week
while I
was working on the front end forms file (separate ones for each user) it
happened on this file and even when I logged off the system entirely and
logged back on as another user it still said that the lbl file was being
used
by the previous user. Could it be anything to do with playing around with
the rich text format on the memo field. I will probably just ignore it and
hope it goes away as it doesnt cause too many problems. And will push to
move
the entire system up to 2007 format

Thanks

"Graham Mandeno" wrote:

Hi Judith

By "system lock file" I presume you mean the .ldb file.

The .ldb file is created when the first user opens a database for shared
access. Provided all the users close the database cleanly, then it
should
be deleted automatically when the last user closes the database.

Are there multiple users accessing the database simultaneously? Is the
database closing cleanly (no Access crash or suchlike)? Can you see
MSACCESS still running in the task manager after you close the database?

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"judith" <judith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:73A14D4E-FAF6-49C3-88BD-FE1E8EE0AA93@xxxxxxxxxxxxxxxx
Ahhh. Yes I was playing around with that field trying to set it up as
rich
text to allow formatting. And as the system is still in 2003 format
although
I am using 2007 that presumably explains why the tags showed in the
field.
I
am relieved that it is not something more sinister happening with the
data
and will refrain from playing in future! I would like to use formatting
in
memo fields and may move the system up to 2007 but have found the rich
text
field very fiddly and have had to do a lot of form rebuilding to get it
to
work.

On the system lock file. Is this related or do you have any other
suggestions that I should look at. This sytem seems to persist in
holding
a
lock file. Usually on the data but more recently on the front end
files.
It
usually takes overnight for everyone to log out and for the systems to
shut
down before the lock file is released.

Thanks, your help is much appreciated

"Graham Mandeno" wrote:

Hi Judith

<div> and </div> are HTML tags. Access 2007 uses HTML to implement
rich
text formatting.

Is the data field in your back-end formatted as rich text? Or is the
textbox where the data was entered set up to interpret the input as
rich
text?

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"judith" <judith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05425642-E9FE-4958-BFF7-4F18DDC3CF98@xxxxxxxxxxxxxxxx
A user has just entered some data in a sub form that has worked fine
for
the
last 2 years. The data appeared with <div> at the front and </div>
at
the
end
of the data item.

Possibly related. Once the front end had been closed it left a lock
file
on
the system that i could not remove as it said that it was being used
by
the
administrator.

I am using 2003 format in Access 2007. No locks set on the system
just
the
standard set up
Any suggestions please

Thanks









.

Quantcast