[AccessD] Access/Oracle

Marcus, Scott (GEAE, RHI Consulting) scott.marcus at ae.ge.com
Wed Mar 12 12:22:00 CST 2003


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



More information about the AccessD mailing list