[AccessD] Access/Oracle

Thanks Scott,

Pointers is exactly what I will need and any place on the net that you
know of that has information on Oracle.  I have not really embarked on
anything that has to do with Oracle so this is going to be a new avenue
for me.  It is going to be fun but I am sure agrivating at times.

Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader
(541)881-4808


-----Original Message-----
From: Marcus, Scott (GEAE, RHI Consulting)
[mailto:scott.marcus at ae.ge.com] 
Sent: Wednesday, March 12, 2003 11:22 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Access/Oracle


I have done this many times. What are you looking for? Pointers?

I have noticed that pass-thru queries work better(but requires you use
Oracle only syntax for SQL) than attaching tables and running queries
based off those attachments. Provided that the user has the proper
privleges, attaching the tables to the front end (replacing the existing
attached access tables)is the whole beauty (well not the only advantage)
of splitting your database into front-end back-end. Very little else
needs to be done.

Scott Marcus

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Wednesday, March 12, 2003 12:50 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access/Oracle



I am about to embark on a project to right a front end that will connect
to a back End Oracle database.  Has anyone had any experience in this
area or know of where I can find good information on techniques?  Any
help anyone can provide would be great.

Thanks

Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com