E
Elsie
hi all, in my access file, I have some linked tables and these linked tables
are used in all my queries. now I have to change the linked tables, is there
any quick and painless method to change?
e.g.:
SELECT [PUB_po-rcpt].[rcvd-date], [PUB_po-rcpt].[vend-num],
PUB_vendaddr.name, PUB_poitem.item, PUB_item.description,
PUB_item.[product-code], [PUB_po-rcpt].[qty-received]*1 AS [qty-received]
INTO T_Past_Purchase
FROM (([PUB_po-rcpt] INNER JOIN PUB_poitem ON (PUB_poitem.[po-release] =
[PUB_po-rcpt].[po-release]) AND (PUB_poitem.[po-line] =
[PUB_po-rcpt].[po-line]) AND ([PUB_po-rcpt].[po-num] = PUB_poitem.[po-num]))
INNER JOIN PUB_item ON PUB_poitem.item = PUB_item.item) INNER JOIN
PUB_vendaddr ON [PUB_po-rcpt].[vend-num] = PUB_vendaddr.[vend-num]
WHERE ((([PUB_po-rcpt].[rcvd-date])<#6/1/2004#) AND
((PUB_item.[product-code]) Like "*imp"))
ORDER BY [PUB_po-rcpt].[vend-num], PUB_item.description,
PUB_item.[product-code];
I have to change all PUB_<table name> to dbo_<table name> as well as all
hyphens to underscore, I.e., [PUB_po-rcpt] --> [dbo_po_rcpt]. Please help
are used in all my queries. now I have to change the linked tables, is there
any quick and painless method to change?
e.g.:
SELECT [PUB_po-rcpt].[rcvd-date], [PUB_po-rcpt].[vend-num],
PUB_vendaddr.name, PUB_poitem.item, PUB_item.description,
PUB_item.[product-code], [PUB_po-rcpt].[qty-received]*1 AS [qty-received]
INTO T_Past_Purchase
FROM (([PUB_po-rcpt] INNER JOIN PUB_poitem ON (PUB_poitem.[po-release] =
[PUB_po-rcpt].[po-release]) AND (PUB_poitem.[po-line] =
[PUB_po-rcpt].[po-line]) AND ([PUB_po-rcpt].[po-num] = PUB_poitem.[po-num]))
INNER JOIN PUB_item ON PUB_poitem.item = PUB_item.item) INNER JOIN
PUB_vendaddr ON [PUB_po-rcpt].[vend-num] = PUB_vendaddr.[vend-num]
WHERE ((([PUB_po-rcpt].[rcvd-date])<#6/1/2004#) AND
((PUB_item.[product-code]) Like "*imp"))
ORDER BY [PUB_po-rcpt].[vend-num], PUB_item.description,
PUB_item.[product-code];
I have to change all PUB_<table name> to dbo_<table name> as well as all
hyphens to underscore, I.e., [PUB_po-rcpt] --> [dbo_po_rcpt]. Please help