Legacy system platform change - how to change the reports

K

karen andross

many access reports to linked tables for an Oracle
manufacturing database. Tables all start with "SYSADM"
from that system.
Converted database is SQLserver - all table names start
with dbo instead of sysadm.
ODBC connection also needs to change.

Anyone know a QUICK easy way to do that?

I am very NON-TECHNICAL,
thanks
 
C

Cheval

I think your stuck in the long run. The only think that
you can do quick, is delete all the links to the Oracle DB
and relink to the SqlServer and rename the links to start
with "SYSADM" instead of "DBO". That should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Changing Baseline dates due to snow days 0
Linked Tables and SQLServer and Remote Users 1
Urgent - how to disable user from making new queries 2
Records in subform do not change when record in main form changes 0
Database name added to link tables! 1
change an oracle session parameter 0
oracle sql plus - modified table column - not showing in Access 1

Top