I am using access 2000 as a interface. But when I click on relationship option the window that comes up is all disabled and you can not click any where....

Create a new Access database file and select Access Project (.adp) This will allow you a front end tool for your MSDE database. Access 2000 will even let you manage the security from the Access adp. You can also view/create database diagrams and relationships.

If you use a mdb, you will not be able to change the relationships of the MSDE database.



Sal

Hi,

I have created database with 2 tables in MSDE using Access 2002 as the front end for MSDE. But still don't know how do I create relationship between my tables ?
I read this article it says click on Design Diagram and then click on "new", but when I click on "new", I get this error "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."

Thanks

Do you have the latest service pack for ms access 2000?



Sal