Colleagues,
Need some help for a novice, please.
Like many who post, I have inherited a problematic database in Access 2007. The original creator is has moved away from the company, left no documentation on the location/features, but did leave the password to their former manager.
***The core problem is that no one knows how to merge new-hire, new-employee information into the DB from Excel 2007.***
From what I've gathered, the original designer split the database into a front end and back end copy. The front end copy is what I and everyone else have access to, but only the home tab is visible; Create, External Data, Database Tools and Datasheet tabs are not visible in the FE copy. The posts tell me to look for a .mdw file, but it's no where to be found in multiple drives, folders, etc.
When loading the FE copy, I have pressed the shift button down, but it only gives me design view for the FE data entry form only. For the Advanced Security settings tab, the FE "Owner" is whoever happens to have the DB opened first at the moment, although updates to permissions-settings are not allowed by anyone. Any ideas on a workaround to complete a merge of Excel data into a FE copy?
Thanks for any and all insights and replies.