Re: Inbuilt functions ODBC

Bob Hairgrove <rhairgroveNOSPAMPLEASE@xxxxxxxxxxx> wrote in news:b3294
$47a77217$54485a1e$11608@xxxxxxxxxxxxxxx:

This is correct.

None of the built-in VBA functions will work in ODBC. This is because
Access itself isn't running; there is only the MDB file which is being
read from or written to through the ODBC. MS-Access is not a database
server like Oracle or DB2, but a client-only platform.

There are some ODBC functions which can be used; however, I don't have
access to the ODBC documentation at the moment. You need to read the
"ODBC Programmer's Reference" which comes with the MDAC (or MSDN) and
look up these functions.

For your convenience:
The ODBC Programmer's Reference is at
http://msdn2.microsoft.com/en-us/library/ms714177.aspx

.

Relevant Pages

  • Re: help pls.........
    ... If the forms are in the WB, then there's no need for any ODBC etc stuff. ... You can reference the WS directly. ... I have a workbook named WBOOK with I think 20 worksheets. ... What I want to do is to be able to edit and delete data from worksheets ...
    (microsoft.public.excel.programming)
  • Re: OdbcDataAdapter and MySQL
    ... Don't use Microsoft.Data.Odbc reference; ... Configure the driver in Control Panel>Administrative Tools>Data ... Select "System DSN">Add>MySQL ODBC 3.51 Driver DSN. ... specifically MyISAM types. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Inbuilt functions ODBC
    ... None of the built-in VBA functions will work in ODBC. ... there is only the MDB file which is being ... The ODBC Programmer's Reference is at ...
    (microsoft.public.data.odbc)
  • Linked Tables odbc
    ... I have a BE that links via odbc to sql. ... The database is obviously split. ... does the FE reference the BE and then link to sql via ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Changing linked SQL Server tables in code
    ... Relinking ODBC tables in code is kind of a pain. ... With ODBC you have to use a lot of API code. ... you just make a reference to the Microsoft ActiveX DataObjects ...
    (comp.databases.ms-access)