Relationship window in Access 2007 ADP mode

[Laury G Burr]

I'm developing an ADP project under Access 2007 on Windows XP2. Most buttons
on the "Database Tools" ribbon are diabled (all bar 4v - Visual Bais, Run
Macro, Add-ins, Make ADE). I depsperately need the Relationship window but
its button is disabled. How do I enable it?

 

[Paul Shapiro]

Access doesn't display SQL Server relationships. SQL Server Manager can
generate db diagrams which will show the relationships and let you
graphically create/edit relationships. It also has property-type design
tools for working with relationships. Depending on the SQL Server version
the server explorer shows relationships. You can create them with sql
statements. Etc.

There are also 3rd party tools like Embarcadero's ER/Studio or CA's ERWin
that generate db graphical models, but these are expensive.

 

[Laury G Burr]

Thanks Paul - tho' admittedly not the answer I was hoping to receive!! Up to
now I've done everything through Access - time to add to my knowledge!

all the best

Laury

 

[Tony Toews [MVP]]

I'm developing an ADP project under Access 2007 on Windows XP2. Most buttons
on the "Database Tools" ribbon are diabled (all bar 4v - Visual Bais, Run
Macro, Add-ins, Make ADE). I depsperately need the Relationship window but
its button is disabled. How do I enable it?

I'm also thinking this might depend on what version of SQL Server you
are going against. If SQL Server 2008 then A2007 might not support
some features. If SQL Server 2005 then A2007 might support more
features.

Just guessing though.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Laury G Burr]

Ah - my mistake. I forgot to mention that it's running on SQL Server 2000 -
so Access 2007 ought to be aware of it!! Certainly there's no problems with
building stored proccs etc.

Laury