RE: Linked Tables Losing Data
- From: Armen Stein <ArmenStein@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 8 Oct 2006 12:42:33 -0700
In article <958FA98D-1A99-481E-B729-8754833484D8@xxxxxxxxxxxxx>,
Gertrude@xxxxxxxxxxxxxxxxxxxxxxxxx says...
Access databases DO lose records. It happens to my databases sometimes
(especially where the network is unstable or where users use Ctrl Break to
stop a query). I always make sure that I can restore records from backups,
but I would like to know why Access does this.
"Jerry Whittle" wrote:
Databases , not even Access, just don't lose records. Some possibilities:
1. You are linking to the wrong BE MDB file. I've done this.
2. Other users are deleteing records. Seen that.
3. The network drive crashed or something happened to cause a restore from a
backup. They just forgot to tell you. Been there too.
4. Access is running into a severe, persistant corruption problem and is
dropping records when repaired. If so somebody should see this happening. Not
likely.
I'll add another way that Access can "seem" to lose records.
- You add records to a table.
- You look at the data using a query, or a form or report based on a
query.
- The query joins to another table using an inner join (I.e. no
arrowheads on the lines).
- For your new records, there is no matching record in the other table,
so Access omits those records.
- You wonder where your records went.
--
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
.
- Prev by Date: Re: Number feild for weight
- Next by Date: Re: Number feild for weight
- Previous by thread: Re: Linked Tables Losing Data
- Next by thread: Re: Where can I get a list of the Naming conventions used in Access?
- Index(es):
Relevant Pages
|
