Tables on SQL BE

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I have an Access Database with a FE and a BE. I am in
the process of putting my tables on a SQL BE. This
database has 50 plus users. Is there a work around for
installing Oracle for the ODBC on each user's computer?
I don't want to have to install Oracle on each of these
computers.

Thanks for your help!
 
Hi Joyce,

1st, you can upsize the backend using an ORACLE upgrade utility. You
then, of course need to work on your ORACLE DBA stuff, ie, backing up,
location of control files, tablespaces etc, etc.

2nd. Work out the middle bit, ie, the connection. What have you got
doing the work on your FE, is it Access forms with bound record sources
or is it unbound forms using ADO or DAO??

If is is bound forms you could set up an ODBC connector in control
panel which will need the ORACLE drivers on each client, this could then
point to the ORACLE DB. Next, you could link the FE via ODBC connector
thru File/Get External Data.

Should you be using ADO code on unbound forms it could be more work but
hopefully, you have one common class for connection, otherwise it could
be quite a lot of re-coding!

Do not put this task as a days work, the upsizing, especially onto
ORACLE can be a big job, post if you need more info

Rich
 
Joyce said:
I have an Access Database with a FE and a BE. I am in
the process of putting my tables on a SQL BE. This
database has 50 plus users. Is there a work around for
installing Oracle for the ODBC on each user's computer?
I don't want to have to install Oracle on each of these
computers.
Click to expand...

Just to be clear here. When you state SQL BE you do mean an Oracle BE
and not a Microsoft SQL Server BE? If so then I suspect you'd have
to install an Oracle driver on each workstation. Do ensure you are
consistent on the version you install.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
I Think you have to bite the bullet
The Good thing is that you can make a silent install, or make an msi package
or
(quite dirty) make a network install & copy the
H_KEY_LOCAL_MACHINE\Software\Oracle
to each computer (+ H_KEY_LOCAL_MACHINE\Software\ODBC) & modify the path on
the computer to include the %ORACLE_HOME%\bin directory

HTH
Pieter
(Oracle Professional DBA & such things...)
 
Back
Top