Data issue

[judith]

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

 

[Graham Mandeno]

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?

 

[Graham Mandeno]

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?

 

[judith]

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

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

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

 

[Graham Mandeno]

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

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

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

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

 

[judith]

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

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

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

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

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

 

[Graham Mandeno]

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

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

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

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

:

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

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

 

[judith]

I am used to the ldb on crashing but it usually relaeses. With this system I
rarely get crashes and it seems to have exited cleanly. I am not on site so
can't check the task manager but I suspect it may continue running. I think I
will just take the whole lot up to 2007 format. Thanks a lot for all your help

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

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

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

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

:

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

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