Make sure your accessing the right database file. Don Krause [email protected]
________________________________ From: LaDeana <[email protected]> To: [email protected] Sent: Sunday, May 31, 2009 4:34:05 PM Subject: Re: [Access VBA Central] Record-Level Security Not sure on 2007 but on 2003 there is no record level security directly on a table you would need to apply a filter someway. Check to see where the table is linked to on his system. Sounds like he's writing to a different data source. ----- Original Message ----- From: "henryovitz" <hb...@sbcglobal. net> To: AccessVBACentral@ yahoogroups. com Sent: Friday, May 29, 2009 9:01:58 PM GMT -05:00 US/Canada Eastern Subject: [Access VBA Central] Record-Level Security I created an Access 2007 database with a table of about 1600 records. We copied it to a summer employees computer and I gave him full control. He has added about 30 records to this table. He has about 1630 records in his copy of the database. He can see them all when he is signed in on his computer I can see them all when signed in on his computer. I see only the original 1600 records when I view the table over the network. His copy of the database is in a shared folder. It seems like there is record level ownership; is there such a thing? How is this corrected? Any help will be very much appreciated. Hank [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
