March 23, 2006 at 3:13 am
Has any member ever modified a table structure of a database linked to an Access database? if so how do you do it without having to delink the two? I need to add an extra variable either in access/sql(EM).
Thanks,
Allan.
March 24, 2006 at 8:28 am
If your using a straight linked table within ACCESS, you cannot do it without re-linking the table, as it performs the link using the objectID of the table in SqlServer.
Another way to perform the same basic function, without having to re-link tables, is to use pass through queries as your data view. You can reference the passthrough query in other queries, and not need a linked table. This has no reliance on objectid, so doesn't break anything when the table is dropped and recreated on SQL.
March 25, 2006 at 12:40 am
It is an ODBC link which i have successfully managed to modified the struture from the SQL - EM and then refreshed the link with the access and it has worked. Thanks,
Allan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply