Re: MS Access 2003 as an ODBC source

In the Access FE, choose File, Get External Data, Link Tables
(assuming that you are using linked tables). Expand the Files of Type
drop-down and choose ODBC Databases. Follow the prompts from there.

--Mary

On Thu, 6 Mar 2008 06:39:25 -0800 (PST), gargoyle47
<gjdcatman@xxxxxxxxxxx> wrote:


I have Access 2003 and want to use one of my mdb databases in an
external program (VisualWorks Smalltalk image) via ODBC.

Here is an extract from the VisualWorks database documentation:-
Environment Strings
The Database Connect requires that you enter a database environment
string.
This can be any string that identifies the database, according to
conventions
for the specific database and the system it is on.
Throughout this document we will assume your database is configured
such that an environment string in the following format is
recognized:
<host_name>_<dbSID>
For example:
ocelot_ORCL

However, I can find no particular environment string or environment
variable that looks remotely related to this matter.

On a separate note, I have tried using the Windows XP ODBC Data Source
Administrator (with which I am unfamiliar) to identify the standard
installed User DSN of "MS Access Database", but have no idea of how to
actually use this, despite reading the (limited) help files.

What I need is somebody to help get me started?
.

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: 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)
  • Re: CDatabase, CDaoDatabase
    ... raw ODBC calls ... DAO will outperform ODBC (and so CDatabase) considerably in single user ... There is considerably more to database performance than making quick ...
    (microsoft.public.vc.mfc)