hi

I did  add accessdatasource control on my ASP page and add the .MDB file in my project in to the app_data folder.

The wizard did not show me the avalaible table & query and give me the folowing error

Object reference not set to an instance of an object.

what  reference should I used when I click 'Add References.. from Website menu.

I'm using visual studio express 2005

Hi~

We could be more helpful if you post related code. 

You can follow Retrieving Data Using the AccessDataSource Web Server Control  to start.

Thank for the info. But it did not help. Still not working
 

The control (AccessDataSource) simply do not show me the table. 

and the database I'm using is not password-protected

 ref: Retrieving Data Using the AccessDataSource Web Server Control

Note

The AccessDataSource will not connect to an Access database that is password-protected; to retrieve data from a password-protected Access database, use the SqlDataSource control.

I am not 100% sure anyway you can take a look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=133896&SiteID=1

You can find solution in the last several pages.

Yes it did solve my problem. What a long story. thank to everybody that did participate.

Ref posted : 05-02-2006, 5:04 PM UTC / Stephen Provine  / Posts 19

 Description of the solution:

Hi everyone,

I have determined what seems to be causing the problem, but I would like to verify that this is the cause for all of you that have seen the problem.

Please run regedit.exe and browse to the following location in the tree:

HKEY_CLASSES_ROOT\CLSID\{F9AE8980-7E52-11d0-8964-00C04FD611D7}

Underneath this key should be a sub-key called "ProgID" with a value of "MSIDXS.1".  If you can't find this, it is causing the problem you are seeing.  Adding this back should fix the issue.

Please let me know if this does not solve the problem.  We will see if it is possible to fix the code that makes some assumptions about the existence of this key to have some default behavior that works even if it does not exist.

I had the same problem and adding the reg key is the solution.

I've recreated this problem with doing everything i did before the error showed up. Turns out to be that RegVac (v 4.02.37 free edition) deleted that key :(