What sql database role must a user have to use a MS Access project file

Today i tried changing a users role from db owner to db data reader and db data writer. This user uses an Access ADP file, to edit, add and delete records from a few tables in the SQL Serve开发者_Go百科r database. However, after doing so he got an OLE error from access on trying to open the ADP. Are there certain security priveleges required by the Access application its self?

---

Access has a built-in macro language called Visual Basic for Applications (VBA.) The OLE error might originate from that.

Try to open the Access application while pressing the SHIFT key. This should get you into the main Access screen. Press ALT-F11 to open the Visual Basic editor. Now, if you open the applications main form, the debugger should pop up if there's an OLE error coming from VBA. By examining the code that generates the error, it's probably easy to see which permissions are missing.