<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>Updating Access Tables</TITLE>
</HEAD>
<BODY>
<P><B><I><FONT SIZE=2 FACE="Arial">---- London Borough of Bromley E-Mail Disclaimer ----</FONT></I></B><I></I>
<BR><FONT SIZE=2 FACE="Arial">"For information about Bromley Council visit our web site www.bromley.gov.uk"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">"The information contained in this message (including any attachments) is confidential in that it is intended solely for the use of the recipient to which it is addressed. If you are not the intended recipient, the use of the information by disclosure, copying or distribution is prohibited and may be unlawful." </FONT></P>
<P><B><I><FONT SIZE=2 FACE="Arial">---- End of Disclaimer ---- </FONT></I></B>
</P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">Hi All,</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">I want to mirror data held on the Oracle tables in a read only Access database.</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">I am using a .udl file to access data from</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> the</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> Oracle database</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"></FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">using ADO. </FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">(</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">The Oracle db</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">is administered externally).</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">Can anyone tell me the quickest way to do this.</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">At the moment I am considering</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">creat</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">ing</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> each table in Access individually</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">(which will be no small task as there are many tables with even more fields)</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">and then update the tables</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> as demanded</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial">, or is there a specific statement I can use which will build the tables</FONT> <FONT COLOR="#000000" SIZE=2 FACE="Arial">after</FONT><FONT COLOR="#000000" SIZE=2 FACE="Arial"> creating the connection?</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">Thanks in advance!</FONT></P>
<P ALIGN=LEFT><FONT COLOR="#000000" SIZE=2 FACE="Arial">RyanS</FONT></P>
<BR>
</BODY>
</HTML>