When to use odbc

  • Thread starter Thread starter Squik27
  • Start date Start date
S

Squik27

Hi,

I have a database and after i split it i add a password to the back end and
then I move application to other computer and I re-link the tables at this
point it's going to ask me for the password to re-link tables and that's it,
I don't need the password anymore. I also learn a few days ago about ODBC,
but it wasn't clear enough; so, I don't know when to use it. I think, I need
to use it when I write code to open the connection. Is this true?

Thank you
 
Open Database Connectivity is used to link your tables that are on a server
SQL server...if your sharing your backend from a local computer you just need
the link manager.


Richard
 
In fact, if your back-end is a Jet database (i.e. an MDB or ACCDB), you
cannot use ODBC to link to it from an Access front-end.
 
In fact, if your back-end is a Jet database (i.e. an MDB or ACCDB), you
cannot use ODBC to link to it from an Access front-end.
Click to expand...

Many database engines (Oracle, MySQL, DB2, ...) support ODBC connections. SQL
is certainly the most common example though.
 
Back
Top