oracle to access

Results 1 to 2 of 2

Thread: oracle to access

  1. #1
    Join Date
    Dec 1969

    Default oracle to access

    HI all,<BR>i have a data base in oracle at a remote server(connected on a lan to my web server).All i want to do is fetch a table(completely or a subset of it) and first convert it into an access database on my machine so that the clients to my web server can acces it directly from my webserver and the request doesnt have to go to the oracle server all the time.<BR>how do i convert oracle in to an access database thru my web page it self.<BR>pliss suggest<BR>Regds<BR>mechigger.

  2. #2
    Join Date
    Dec 1969

    Default Use ODBC

    with an ODBC connection, you can link the table to Access and then run a maketable query, creating the Table you need. You could then save the query and run it at odd times (2:15AM????) to syncronize (in a screwy fashion) the two tables.<BR><BR>Note that this is NOT the way I would treat it if the information were time dependant, but then, apparently, it isn&#039;t

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts