Re: Chnaging the DB that Tables point to

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Have you tried the link table manager? If all the tables were linked to one
Oracle db then if you Select All, check the Always prompt for new location,
and click OK you can select your test db.

Haraki wrote:
I have an Acces mdb with odbc links to about 100 tables to an oracle
production database. Is it possible to change the links all at once to my
test db without having to relink each one?

Thanks in advance for any help that can be offerred.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Linked Table Manager Macro
    ... I need to prompt a user to relink a table every month. ... macro that opens linked table manager and prompts for a new location. ...
    (microsoft.public.access.externaldata)
  • Re: Oracle connection from MS AS 2000
    ... When you are using Analysis Manager to create objects and browse, ... allow any process running Local System to touch any network resource. ... > tables, etc in Oracle and you are able to make cubes, dimensions etc. ...
    (microsoft.public.sqlserver.olap)
  • Overcoming objections to Oracle
    ... I recently took a job as an IT manager for a financial institution in the United States. ... I will be acting as the senior project manager until I get a feel for things, and then I will take over as the departmental head. ... At my former position, which was also a financial institution, we used Oracle. ... Of course, it will be a huge task that will take years, but considering the subservient position the senior leadership is in because of this common bad IT situation, it's the best choice. ...
    (comp.databases.oracle.server)
  • Re: Embrace and Extend, Borland Style
    ... > Well, Oracle does, and it works great! ... IB Console is a shame, I'd wish it wasn't coded in Delphi! ... And although I do not like SQL Server too much, Enterprise Manager is a good ...
    (borland.public.delphi.non-technical)
  • SN#22917 Oracle Management Connector for Ops Center
    ... An Event Forwarding Solution From Ops Center to Oracle Enteprise Manager ... Have a custom version of 'System News for Sun Users' delivered to you ...
    (comp.sys.sun.announce)