I created an Access database in 2003 format and have upgraded from windows xp and office 2003 to Windows 7 with Office 2010. I have a table (tblemployee) that is using a autonumber as a primary key. Everything has been working fine with it but when I upgraded I needed to add a new employee. I filled out the infomation in the table like I have always done but it doesn't recognize it.
I kept a seperate pc with 2003 on it for debugging between the versions and it does the same thing. Access 2010 doesn't seem to have the security wizard like 2003 did so I tryed to create a new employee and set his security to different items (all in 2003) and the wizard will not reconize the addition to the employee table even though when the table is opened the information is there.
Any thoughts?
Thanks
Tim
I kept a seperate pc with 2003 on it for debugging between the versions and it does the same thing. Access 2010 doesn't seem to have the security wizard like 2003 did so I tryed to create a new employee and set his security to different items (all in 2003) and the wizard will not reconize the addition to the employee table even though when the table is opened the information is there.
Any thoughts?
Thanks
Tim