Access and Excel New Database Query Problem Followup

[Hedgehog]

I just ran into this exact problem. I was trying to connect to a
secured database. I got past it. The steps that I used follow.

Edit the datasource (Start==>Administrative Tools==>Data Sources).
Choose the tab for the correct DNS type (User, System or File).
Select your connection from the list.
Click on Configure.
Click on Select and type in the path to the .mdb file.

Select Advanced.
Type in your username and password that you use to access the secured
access data (maybe it'll prompt you for your login if you don't do
this; I didn't try it).
Type in a default directory if it isn't filled in (don't know if this
is important or not). Click OK.

In the System Database panel at the bottom, select the Database radio
button.
Click on the System Database button.
Select the security .mdw file. Click OK.

Click OK again to close the ODBC setup dialog.

After I did this, the database access worked just fine from MS Query
and Excel (Import External Data==>New Database Query).

Reply


From: "Will Buffington [MS 414076]" - view profile
Date: Wed, Feb 20 2002 10:34 am
Email: [email protected] ("Will Buffington [MS 414076]")
Groups: microsoft.public.access.externaldata

Hello Robert,

The database, if it uses a system.mdw or secured.mdw, is a secured
database. The first thing to do is to check permissions for the users group
to make sure that they at least have view or read permissions set. The fact
that you can export the objects to a new databaseand run the get external
data wizard fine from Excel points to either insufficient permissions to
view the data within your objects, or possibly database corruption. Have
you tried compacting and repairing the database?


Will Buffington
Microsoft Access Support