Re: accessing ms access via ODBC without Microsoft Access


<timasmith@xxxxxxxxxxx> wrote in message
news:1145206985.433826.106120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

If I have a computer without Microsoft Access installed but with an
ODBC connection to a .mdb file - can I still access the 'database' via
ODBC?

Yes, provided you are running a program prepared in a language that supports
ODBC and have installed an ODBC driver on that user's machine.

What you cannot do is to access a Jet (often called Access) database via
ODBC from Access. You can link to tables in that Jet database, or open it
directly, but you can't ODBC to Jet tables from Access itself.

Larry Linson
Microsoft Access MVP


.

Relevant Pages

  • Re: RecordSet fails if a field is null ! - unspecified error 80004005
    ... Yeah thats what I was doing to be sure. ... Could your database be corrupt? ... Maybe something is wrong with your Jet components. ... I didnt think you could use ODBC with access... ...
    (microsoft.public.scripting.vbscript)
  • Re: ADO.net Code contest
    ... Ah, actually, accessing an Access database is done through JET. ... generic interface like OLE DB or ODBC from any data access interface ... ODBC, OLE DB are ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Replacement for Dao
    ... then open both and fetch from the database. ... Jet Engine to be deprecated soon - in fact Jet will not be available at all ... > that Jet actually provides ADO support through its ODBC (I am still ... > was straight forward in Dao) and hence ODBC may perform better than ADO. ...
    (microsoft.public.vc.database)
  • Edit rights to linked Oracle databases
    ... I have ODBC connections established to a Production Oracle ... database and a Test Oracle 9.2 Database - using ... Using the ODBC channel to Prod in Microsoft Access 2000, ...
    (microsoft.public.access.externaldata)
  • Edit rights to Oracle database
    ... I have ODBC connections established to a Production Oracle ... database and a Test Oracle 9.2 Database - using ... Using the ODBC channel to Prod in Microsoft Access 2000, ...
    (microsoft.public.access.security)
Loading