|
|
Posted by jfrasier on 08/19/06 19:38
I re-linked the table in Access and that did the trick. Thanks.
Jane
mollyf@hotmail.com wrote:
> 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]
|