Keys - I Keep losing my Keys, Any Ideas?

Good Morning all,

I have a table that maintains Date, Route, Customer Number and Stop. I have
these as key fields so as to not duplicate from a Append Query that I use to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11141-keys-i-keep-losing-my-keys.html
update the table.

For the past couple of days/Weeks I have noticed that he table Drops it keys
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11141
and allows duplicates.

How can I prevent this or is this a bug with Access?
--
-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On rare occassions, Access can drop the index when you perform a repair. If
the index is corrupt, it drops the index in preference to dropping records.

This should not be happening on a regular basis, so something else is wrong
here. Firstly, make sure you have the latest service pack for your version
of Office, and also (assuming Access 2000 or later) the latest service pack
for JET 4. Available from:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114

If that does not solve the problem, tell us more about this database:
- Access version?
- Split (FE/BE)?
- Multiple users over a network?
- Post the SQL for the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11141
Reply to group, rather than allenbrowne at mvps dot org.

"TheNovice" wrote in message
news:BDB0CF22-76B2-4D10-A1FA-C73C4552386B@microsoft.com...
> Good Morning all,
>
> I have a table that maintains Date, Route, Customer Number and Stop. I
> have
> these as key fields so as to not duplicate from a Append Query that I use
> to
> update the table.
>
> For the past couple of days/Weeks I have noticed that he table Drops it
> keys
> and allows duplicates.
>
> How can I prevent this or is this a bug with Access?
> --
> -The Novice
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11141
> Learn Today, Teach Tomorrow
>
> Great Success is ones ability to ask for Help.