SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:11 PM
| ||||
| ||||
 Alter a SQL table 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      |
|
02-29-2008, 08:12 PM
| |||
| |||
| Re: Alter a SQL table 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 |
|
02-29-2008, 08:12 PM
| ||||
| ||||
| Re: Alter a SQL table 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 |
Linear Mode
