|
|
Posted by mollyf on 08/18/06 17:14
jfrasier wrote:
> I used the MS Access 2000 Upsize wizard to create a Client/server
> application. After the wizard ran, the original table names had become
> the linked tables and then there were duplicates of the the tables
> named xxx_local.
>
> I realized later that I needed to add some fields to a table and
> couldn't do that in Access (couldn't edit the linked tables). So I used
> the Query Analyzer and created a script to add the fields to my table.
> It looked fine in Query Analyzer, but back in Access the fields were
> added to xxx_local and not xxx, the linked table. My forms and reports
> are built on xxx, not xxx_local.
>
> How do I do this correctly?
>
> Jane
Anytime I've added fields to a linked table in Access, I've always had
to refresh the links (using the Linked Table Manager) in order to see
them on the Access side. I'm not sure if the fact that I seldom use
Query Anazlyer to add fields to a table or not has anything to do with
it (I just go into Enterprise Manager and make the changes there). Are
you sure you're referencing the desired table in your script?
Molly J. Fagan
Navigation:
[Reply to this message]
|