Converting Access Queries to Run on an Oracle server
Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks
Jeff Boyce
backend), you don't really need to do anything. When you link to the tables
in <fill in your backend server here>, the ODBC connection handles the
translation.
I believe you can simply "point to" (link to) the new tables and start
running Access queries.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Rocky5" <nos...@msnnews.com> wrote in message
news:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
Rocky5
One more thing, how do I do a DSNLESS oracle server connection
1. Through ODBC
2. via code where the event of connection happens once a button is clicked.
I plan to either connect on form open or on "connect" button click.
3. via user login form to the database (Generic user made ) login form.
some Sample code would be greatly appreciated
Thanks
Rocky
"Jeff Boyce" <nons...@nonsense.com> wrote in message
news:enSV7Dqd...@TK2MSFTNGP02.phx.gbl...
Alex Dybenko
have a look here:
http://www.accessmvp.com/DJSteele/DSNLessLinks.html
then you should use Driver={Microsoft ODBC for Oracle};
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Rocky5" <nos...@msnnews.com> wrote in message
news:u2YUK2xd...@TK2MSFTNGP04.phx.gbl...
magy
elodie legarnd
"Rocky5" <nos...@msnnews.com> a écrit dans le message de groupe de
discussion : OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
savoyechristian
Jeff Boyce
If you are using an ODBC driver, it might be as simple as creating a new
ODBC driver to connect to the Oracle data, then linking to the Oracle
tables. If your (Oracle) table names are the same as your (SQL-Server)
table names, you wouldn't even need to change your queries!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"savoyechristian" <karb...@voo.be> wrote in message
news:%23r69mMG...@TK2MSFTNGP02.phx.gbl...
reginka
Użytkownik "Rocky5" <nos...@msnnews.com> napisał w wiadomości
news:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
Cameros Casado
"Rocky5" <nos...@msnnews.com> escribi� en el mensaje de
noticias:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
> Thanks yo hablo espa�ol
>
Cameros Casado
"Rocky5" <nos...@msnnews.com> escribi� en el mensaje de
noticias:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
> Thanks yo talk espanish
>
birdj...@hotmail.com
"Cameros Casado" <camero...@yahoo.es> เขียนเป็นข้อความ
news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>
>
> "Rocky5" <nos...@msnnews.com> escribió en el mensaje de
> noticias:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
>> Hello;
>>
>> I have an access db front end and sql server backend. how painful is it
>> to convert this to work on an oracle server backend. Any help would be
>> much appreciated
>>
>> Thanks yo hablo español
>
>>
rene
markhenry
<birdj...@hotmail.com> wrote in message
news:0B41E31D-F8CE-4953...@microsoft.com...
>
>
> "Cameros Casado" <camero...@yahoo.es> ????????????????
> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>
>>
>> "Rocky5" <nos...@msnnews.com> escribi� en el mensaje de
>>> Hello;
>>>
>>> I have an access db front end and sql server backend. how painful is it
>>> to convert this to work on an oracle server backend. Any help would be
>>> much appreciated
>>>
>>
>>>
Jeff Boyce
conversion/translation.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"markhenry" <markh...@cox.net> wrote in message
news:%23pqMw2G...@TK2MSFTNGP04.phx.gbl...
Rolande Serge
Stephanie McCorkle
On 10/5/09 1:24 PM, in article #wgEQGfR...@TK2MSFTNGP06.phx.gbl,
o;;
<birdj...@hotmail.com> wrote in message
news:0B41E31D-F8CE-4953...@microsoft.com...
>
>
> "Cameros Casado" <camero...@yahoo.es> ????????????????
> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>
>>
>>> Hello;
>>>
>>> I have an access db front end and sql server backend. how painful is it
>>> to convert this to work on an oracle server backend. Any help would be
>>> much appreciated
>>>
>>
>>>
o;;
news:0B41E31D-F8CE-4953...@microsoft.com...
>
>
> "Cameros Casado" <camero...@yahoo.es> ????????????????
> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>
>>
>>> Hello;
>>>
>>> I have an access db front end and sql server backend. how painful is it
>>> to convert this to work on an oracle server backend. Any help would be
>>> much appreciated
>>>
>>
>>>
o;;
"rene" <rens...@planet.nl> wrote in message
news:F7F5463B-5CEE-47FF...@microsoft.com...
>> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>>
>>>
>>>> Hello;
>>>>
>>>> I have an access db front end and sql server backend. how painful is it
>>>> to convert this to work on an oracle server backend. Any help would be
>>>> much appreciated
>>>>
>>>
>>>>
>
o;;
"Stephanie McCorkle" <st...@me.com> wrote in message
news:C6F150CC.15D%st...@me.com...
> Hello
>
>
>
> On 10/5/09 1:24 PM, in article #wgEQGfR...@TK2MSFTNGP06.phx.gbl,
> "Rolande Serge" <rola...@videotron.ca> wrote:
>
>>
>> news:F7F5463B-5CEE-47FF...@microsoft.com...
>>>
>>> <birdj...@hotmail.com> schreef in bericht
>>> news:0B41E31D-F8CE-4953...@microsoft.com...
>>>>
>>>>
>>>> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>>>>
>>>>>
>>>>> noticias:OkmxUMpd...@TK2MSFTNGP04.phx.gbl...
>>>>>> Hello;
>>>>>>
>>>>>> I have an access db front end and sql server backend. how painful is
>>>>>> it
>>>>>> to convert this to work on an oracle server backend. Any help would
>>>>>> be
>>>>>> much appreciated
>>>>>>
>>>>>
>>>>>>
>>>
>>
>
o;;
"Rolande Serge" <rola...@videotron.ca> wrote in message
news:%23wgEQGf...@TK2MSFTNGP06.phx.gbl...
>
> "rene" <rens...@planet.nl> a �crit dans le message de
>>
>> <birdj...@hotmail.com> schreef in bericht
>> news:0B41E31D-F8CE-4953...@microsoft.com...
>>>
>>>
>>> news:#YlQPUy#JHA....@TK2MSFTNGP03.phx.gbl...
>>>>
>>>>
>>>>> Hello;
>>>>>
>>>>> I have an access db front end and sql server backend. how painful is
>>>>> it to convert this to work on an oracle server backend. Any help would
>>>>> be much appreciated
>>>>>
>>>>
>>>>>
>>
>
o;;
"o;;" <il;i> wrote in message
news:%23UDFyqa...@TK2MSFTNGP05.phx.gbl...
o;;
o;;
"o;;" <il;i> wrote in message news:O2$xZpaSK...@TK2MSFTNGP06.phx.gbl...
o;;
miguel
"Rolande Serge" <rola...@videotron.ca> escribió en el mensaje de noticias
news:%23wgEQGf...@TK2MSFTNGP06.phx.gbl...
druenne
ben belgacem walid
"druenne" <an...@live.fr.com> a écrit dans le message de groupe de
discussion : O3jkrtXX...@TK2MSFTNGP04.phx.gbl...
Megha Raj Sapkota
normalo...@hotmail.com
"Rolande Serge" <rola...@videotron.ca> escribió en el mensaje de
noticias:#wgEQGfR...@TK2MSFTNGP06.phx.gbl...
derick
drummerboy
never clone.
"derick" <der...@microsoft.com> wrote in message
news:F11D1236-7598-4706...@microsoft.com...
> kids
aleta
David Jennings
"drummerboy" <drumm...@comcast.net> wrote in message
news:%23v%23ooPIx...@TK2MSFTNGP06.phx.gbl...