Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create New Database Query (Excel 2000)

    In Excel, when I go to Data, Get External Data, Create New Database Query, locate my Access database on my school's network drive, and click OK, I get a message that says "This data source contains no visible tables". The database runs fine when opened in Access.

    What does this message mean, and how do I correct it? Many thanks.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Create New Database Query (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> jaleotta

    Do you have access to these tables? I am not familiar with MS-Access, but they may have some privileges and restrictions set on some of the tables and that is why you are getting this error message.

    Best of luck

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Create New Database Query (Excel 2000)

    There are two possibilities that give this symptom which I have experienced. The first is that someone has the database open exclusively, make sure that users uncheck the exclusive access box when opening the Access file. The second is that the permissions set on the Access database need to be amended using the security permissions menu in the opened Acess database. Have the administrator change these permissions for the tables that you wish to connect to. HTH
    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •