Re: Extracting format info from database

dave <nospam@xxxxxxxxxx> wrote in
news:e41Pe.42$NA5.9484@xxxxxxxxxxxxxxx:

> Thanks for your reply...only problem is that DAO can't be used to
> open an access database via ODBC. You get the error "You cannot
> use ODBC to import from, export to, or link an external microsoft
> jet or ISAM database table to your database"

Sounds to me like you did it wrong. Using DAO should not involve
ODBC at all, just as using ADO would not involve ODBC at all.

> any other suggestions? :-)

What programming environment are you working in?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.

Relevant Pages

  • Re: Nameless CREATE
    ... The starting point is either an existing database or one that is ... "Describe" involves issuing an SQLDescribeCol function to ODBC ... essentially much the same as character data type apart from all 8 bits ... ALTER TABLE tablename ADD COLUMN BinaryColumn BINARY ...
    (comp.lang.forth)
  • Re: Speed of working on Access tables
    ... You'd probably get a better discussion in an Access-dedicated newsgroup, ... The database already exists, so I don't need to create the ... What methods can I use to do the work on the Access database that I have ... I have read that ODBC is faster than ADO, ...
    (microsoft.public.office.developer.automation)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... of course supports ODBC connections but Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Serious Problem with Date in RecordSource
    ... Yes, this is ODBC data, not JET data, so some if the things I suggested ... >> c): Decompile the database. ... Still in the code window, choose Compile from the Debug menu. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.formscoding)