Timtropolis
Registered User.
- Local time
- Today, 08:52
- Joined
- Jun 17, 2004
- Messages
- 84
Greetings all.
I am charged with linking an existing Access2003 front end to a Sybase backend. I created my DSN and used ODBC to connect with no problem.
However, when I link to the Sybase tables, I notice that I do not inherit the relationships which were created in Sybase. When I try to establish them, I see the all the referential integerity boxes are disabled (grayed out). Now obviously, if I import the tables, then I can set them accordingly, but that is defeating the purpose of what must be done here.
Is there something that must be done so I can inherit these relationships or am I stuck?
TIA,
Tim
I am charged with linking an existing Access2003 front end to a Sybase backend. I created my DSN and used ODBC to connect with no problem.
However, when I link to the Sybase tables, I notice that I do not inherit the relationships which were created in Sybase. When I try to establish them, I see the all the referential integerity boxes are disabled (grayed out). Now obviously, if I import the tables, then I can set them accordingly, but that is defeating the purpose of what must be done here.
Is there something that must be done so I can inherit these relationships or am I stuck?
TIA,
Tim
