In Access 2007, I have created an Access Project. I have it linked to a SQL database on my local. I have created a bunch of tables. Now I want to build relationships between these tables, but the ';Relationships'; button under the ';Database Tools'; tab is unavailable, along with most of the other options under that tab. Is there a way to make them available? Please explain clearly step-by-step. Thanks!Microsoft Access 2007 (Access Project) Table Relationships Unavailable?
Most of those options are disabled for .adp projects. If you want to create relationships, open the tables in design mode, then open the Propery Sheet. From there, you can specify relationships with update and delete behaviors.
Hope that helps. Good luckMicrosoft Access 2007 (Access Project) Table Relationships Unavailable?
Are you using the database you're working in, did you link to an external database (external to Access) or did you import an external database?
Subscribe to:
Post Comments
(Atom)
No comments:
Post a Comment