using Access as a front end to Oracle Clinical

[pietlinden]

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

 

[Shiller]

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

You can use ODBC connection in Access to link to your Oracle Clinical
database tables. Do this in Access:
Click on Insert > Table > Link Table, at the bottom of the Link
windows you have to scroll down to the ODBC Databases file types
(Files of Types), then select your Data Source (New > Microsoft ODBC
for Oracle...) Your Oracle Clinical administrator should be able to
help you configure the Data Source.

 

[Klatuu]

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).

 

[pietlinden]

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









- 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.

 

[Klatuu]

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.

 

[pietlinden]

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








- Show quoted text -

Thanks, Dave. I'll read up on it. I already have the book, so maybe
it's time i actually opened it! (RT...M!!!) How about that?!

Pieter

 

[Klatuu]

Read the Manual!
That's Crazy Talk!

 

[pietlinden]

Read the Manual!
That's Crazy Talk!

--
Dave Hargis, Microsoft Access MVP







- Show quoted text -

LOL, almost beneath my dignity...

 

[Albert D. Kallal]

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).

Actually, adp ONLY work with sql server, and not other database products
like oracle etc.

Furthermore, we as a general rule suggest using mdb + odbc for sql server
applications and avoiding the use of a adp project altogether.

however, in this case, we CAN NOT use adp...they are ONLY for sql server
from ms..and not other database engines.

using a mdb has no such restrictions, and will work fine with non MS sql
server databases.