Re: using Access as a front end to Oracle Clinical

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

I found very useful information from Access 2002 Enterprise Developer's
Handbook by Paul Litwin, Ken Getz, Mike Gunderloy, published by Sybex. There
is no 2003 version, but there is no real difference between the two.
--
Dave Hargis, Microsoft Access MVP


"pietlinden@xxxxxxxxxxx" wrote:

On Nov 26, 8:30 am, Klatuu <Kla...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Yes, you can link to an Oracle database. You just need to have the right ODBC
driver for it. The linking is not the issue. It is likely the table
structure will not be the same in the database your company is acquiring. It
would be wise to get information on the files, fields, and relationships in
the Oracle database so you can begin planning a conversion.

This would also be a good time to convert to a project (adp).
--
Dave Hargis, Microsoft Access MVP



"pietlin...@xxxxxxxxxxx" wrote:
Has anyone ever used Access as a front end to Oracle Clinical?

Here's the current situation:
The company has a lot of databases in Access 2003. They create their
data summary reports in Word. I have ADH 2002 (both volumes that show
how to do this. They're migrating to Oracle Clinical sometime in the
new year.

Can I just attach to Oracle Clinical through Access? (my guess is
whether OC will allow/enable it) Then I could just do my reports the
same old way. (well, same basic idea, but with modifications, since
the structures will be different).

Is this possible? Necessary? All I'd be doing are basic stats.
Frequency Counts, the random correlation, etc.

Any feedback on websites to check out, books, whatever are welcome.

Thanks!

Pieter- Hide quoted text -

- Show quoted text -

Thanks for the feedback. the conversion is "coming soon". What their
definition of "soon" is remains to be seen. At least that will give
me a head start on learning ADP's.

What are anybody's favorite/most useful resources for that? ADH
<version #> Enterprise? Are there any others? (Maybe Chipman &
Baron's book...?) I was thinking of checking out the Access
Developer's Cookbook, too...

any feedback on good resources (printed and internet) are very
welcome.

Thanks!

thanks.

.

Relevant Pages

  • Re: using Access as a front end to Oracle Clinical
    ... structure will not be the same in the database your company is acquiring. ... I have ADH 2002 (both volumes that show ... Thanks for the feedback. ... What are anybody's favorite/most useful resources for that? ...
    (microsoft.public.access.externaldata)
  • Re: Java GUI Problem
    ... I posted a good deal of useful information, ... Do you know the different between constructive criticism and flaming? ... people don't fart about with couching feedback in the most sugar ... The beauty of usenet is ...
    (comp.lang.java.programmer)
  • Re: Unrecognized Database
    ... This may mean that your database has become corrupt. ... http://www.granite.ab.ca/access/corruptmdbs.htm for useful information ... I tried the File Extension fix where I ... >> Please respond in the newgroup and not by email. ...
    (microsoft.public.access.externaldata)
  • Re: ORA-00600: [25027], [27] in ALERT.LOG
    ... Database 10g on Windows 2003 Server. ... but the error is generating a big amount of dump files. ... collection job is not running properly. ... couldn't find useful information. ...
    (comp.databases.oracle.server)
  • Re: ORA-00600: [25027], [27] in ALERT.LOG
    ... We have discovered in the alert.log some ora-00600 in our Oracle ... Database 10g on Windows 2003 Server. ... collection job is not running properly. ... couldn't find useful information. ...
    (comp.databases.oracle.server)