Query to Access : does'nt see tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vuillermet Jacques (jvuillermet_at_no-spam.fr)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 11:42:13 +0100

Office 2000 SP3 FR

>From Excel / MS Query, I want to read data in Access tables.

I choose the mdb file and so MS Query displays this error message
(translated) :
"This data source does'nt have any visible table".

Original in French : "Cette source de données ne contient aucune table
visible."

I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.

How to resolve this problem ?

Jacques.

Relevant Pages

  • Re: Mail Merge
    ... What happens if you start with a completely new blank document and use the Mail Merge Helper to set up a new mail merge document and choose that query? ... Can you find the .mdb file in the "Open Data Source" dialog box? ... some reason now when I try to open the word document I get an error message ...
    (microsoft.public.word.mailmerge.fields)
  • sql ADOQuery problem with access 2000 database .mdb
    ... I have posted this message before on other delphi news boards but never got ... The following query works fine: ... ADOQuery1.Open; //Generates error message ... DOS_EMPR_PRENOM is Text type (visual Basic .mdb file) ...
    (borland.public.delphi.database.ado)
  • Re: how do i export a table of addresses from access to word ?
    ... create a select query which returns all and only the names ... Use that file for the data source in Word. ... error message -cannot find file ... what is wrong that I cant get this to work ?? ...
    (microsoft.public.access.externaldata)
  • Query to Access : doesnt see tables
    ... I choose the mdb file and so MS Query displays this error message ... "This data source does'nt have any visible table". ... I transfert my data to a new mdb file: it work's few times, ...
    (microsoft.public.access.queries)
  • Re: A really really simple report
    ... click on MDB file, Open" it appears you are not in Access since to create a ... query in Access, you just click on "Queries" in the list of Objects and then ... There is no "My Data Source" that I am aware of in Access 2003. ... several options as well as the table or query to base your report on. ...
    (microsoft.public.access.gettingstarted)