ADP Query Error

[Becks]

Hey guys, have got a problem with an Access ADP and SQL Server.

In enterprise manager I can look at a query and it outputs as expected.
However if I look at it in the Access Project, the field "VisitorName"
(which is an alias) is shown as "FirmName" and also shows the normal
"FirmName" field (which incidentally is another alias) .

I've repaired the ADP to no avail. Can you run a decompile on an ADP ? The
normal switch doesn't work.

Anyone got any ideas?

Thanks
Becks

 

[Steve Jorgensen]

Hey guys, have got a problem with an Access ADP and SQL Server.

In enterprise manager I can look at a query and it outputs as expected.
However if I look at it in the Access Project, the field "VisitorName"
(which is an alias) is shown as "FirmName" and also shows the normal
"FirmName" field (which incidentally is another alias) .

I've repaired the ADP to no avail. Can you run a decompile on an ADP ? The
normal switch doesn't work.

Anyone got any ideas?

Thanks
Becks

This kind of thing seems to occur when you create objects through the ADP,
then edit them elsewhere. The ADP creates extended properties for these
objects to remember things likelayout, etc. So, this extended property data
is stored on the server with the object, but SQL server has no ide what it
means, so it doesn't keep it in sync with any changes you make.

What I would do is rename the table, then create the empty table again from
scratch, then use an INSERT query to copy the data back into the pristine new
table. Finally, when everything looks clean, delete the renamed copy.

 

[Vadim Rapp]

B> Hey guys, have got a problem with an Access ADP and
B> SQL Server.

B> In enterprise manager I can look at a query and it
B> outputs as expected. However if I look at it in the
B> Access Project, the field "VisitorName" (which is
B> an alias) is shown as "FirmName" and also shows the
B> normal "FirmName" field (which incidentally is
B> another alias) .

What do you run from the ADP - the query itself, or a form based on the
query? if it's the form, the column heading in datasheet view is defined by
the label on the form linked to that field. You can only see the label in
design mode.

Vadim