ODBC Connection and automation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the situation:

There are several different types of databases that I have
access to Sybase Oracle, I have been using Crystal reports
to pull the data from the databases and then exporting to
excel.

I want to setup a direct connection to Access so that we
can create user friendly views and have the data be live
up to date data.

Any ideas?

My wheels have been spinning on this any help would be
appreciated.
 
What you have to do on the server side to assign permissions, userids, etc.,
will depend on the server.

On the client, install the appropriate ODBC driver, create a System DSN, and
link the tables using Get External Data on the File menu. That's the basis
of what you want to do on the client side, but there are some design factors
that can affect performance. Your goal should be to minimize the amount of
information you need to pass across the network... so no forms opened
against tables or huge queries and filtered on the client, for example.

There's a presentation that might help you on client-side issues that you
can download from http://appdevissues.tripod.com/downloads.htm. It's one I
did for my user group on the subject of Access as an ODBC client.

Larry Linson
Microsoft Access MVP
 
Back
Top