Can't get into an Access database
Posted on 2011-10-05
This is probably pretty easy for an Access guru, which I am not... A customer was using an Access database (2003) on an XP computer. The database is located on a network share. She normally accessed it through a shortcut that just had the UNC path to the .mdb - nothing in the shortcut path about a workgroup or anything. It would come up to the login box, then after logging in it would go to a menu (front end). I put in a new Windows 7 computer, copied the shortcut over from the XP profile, but when you double click on the shortcut you get the error "You do not have the necessary permissions to use the Database.mdb object..." No login box, and of course she does have full permissions to the database file on the server. I copied over the Access folder inside Application Data from the XP profile, thinking that might solve it, but no luck. I assume there has to be something in the XP profile that I need, but I don't know what or where. The folder on the server containing the .mdb file has nothing else in it. Help!!!