Access records reverting to earlier data

[Caroline]

We keep our mailing lists on Access. As far as I know the database was
created using Access 2000, which was upgraded to 2003 after I came into post
and we're now using 2007.

Sometimes addresses will revert to earlier addresses. This was a problem for
the previous admin worker as well so I've started trying to get people to
fill in a form for changes so I can date when I amend the database and try
and keep track of this problem more effectively, but this isn't going well.

Does anyone know what could be causing this? Has anyone else had this problem?

 

[KARL DEWEY]

Sometimes addresses will revert to earlier addresses.
When you update an address do you enter a new records or make changes in the
current record?
If you make changes in the current record there is no way that the data will
revert to 'earlier addresses.'
If you are entering a new address then you are just pulling the wrong one.
You need to add a DateTime field with default set to Now() to mark the date
and time the record is created. Then use criteria to pull only the latest
records.

 

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

I'd assume that you're pointing to the wrong backend.

In other words-- JET is too complex for what you're trying to do.

Thanks

-Aaron

 

[Caroline]

Could you explain further? What is JET?

The database is made up of two tables, one with contact details the other is
the mailing lists they are on - if record one is on mailing lists 1 2 & 5
then it has three entries in the second table. Printing is done with a query
and a macro - there is a 'print' button on a form, it pops up a window asking
which mailing list (and a few other options) you tell it and it prints them
out to match our labels.

I don't use the form to change records as I think it's hideously badly
designed and doesn't include all the fields that I need to put data in, so
I'm amending the records in the table.

I know the problem makes no sense and it shouldn't happen, but somehow it is

 

[John W. Vinson]

Could you explain further? What is JET?

Access' builtin native database engine, and Aaron's pet peeve. Aaron has only
one answer to any question whatsoever: use SQL Server. I'd suggest reviewing
some earlier threads involving him and make your own judgement about how to
use his advice.

The database is made up of two tables, one with contact details the other is
the mailing lists they are on - if record one is on mailing lists 1 2 & 5
then it has three entries in the second table. Printing is done with a query
and a macro - there is a 'print' button on a form, it pops up a window asking
which mailing list (and a few other options) you tell it and it prints them
out to match our labels.

I don't use the form to change records as I think it's hideously badly
designed and doesn't include all the fields that I need to put data in, so
I'm amending the records in the table.

Ummm... it's really easy to create your own autoform or wizard generated form.
With two tables, you really need a Form with a Subform. Working in tables will
give you no end of trouble.

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.

 

[Tony Toews [MVP]]

"aaron.kempf" is a robot

It has been determined that the message below was generated
programmatically,

1) In my news reader the message to which you are replying appears
above your message and not below. Thus I would suggest changing
"message below" to "previous message".

2) As much as I feel Aaron should have his Internet access removed
until he is stabilized on appropriate psychiatric medications I feel
your postings are way over the line of decent netiquette. Please stop
posting such messages.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

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

my postings are over the line of netiquitte?

are you kidding me?

are you talking about the swearing?

ROFL

Swearing ain't illegal-- and you do NOT need to write letters to
people's boss-- trying to get them fired-- just because they swear

I think that you should have your Internet access disconnected because
you are such a whiny bitch and you promote an obsolete database
TONY is the reason that people send their SQL Server work to India--
because all the dipshits over here are too stupid to use anything
except JET