XP permissions?

Hi,

I am using Visual Studio.net professional 2003 (C#.NET). I am building a very simple project where I need to connect to Microsoft Access database through OledbDataAdapter in design mode by Dragging the OledbDataAdapter Control from the Data tab on the ToolBox and then generate
the DataSet.

I am able to connect to MS ACCESS and test connection is a success.Now when I try to generate the Dataset by Right Clicking The Data Adapter Object in the Component Tray and Click Generate Datset,and then Select the New Radio Button from Geneate Dataset Daialog box and click OK I get this Error:

*****ERROR:There were Problems Generating the ExampleProgram1.Dataset1 .To resolve
this problem,build the Project, fix any Error, and then generate the dataset
again.*******(ExampleProgram1 is the Name I have given to the Project)

I see that when the above operation of Generating a dataset is done a file Named "Dataset1.xsd" is being added to the Solution Explorer, and I am able to open the Dataset1.xsd file and view the contents.

So, My Question is why is this Specific Error happening inspite of building the project again where really I dont need to... and unable to find any Errors where I need to fix. Everything Looks good from my end.

Is there some permission that needs to be set up in WinXP Pro that allows access to databases? I have no ideas. :(

I Look Forward to your reply as I have been tying to fix this problem for long
time.

Thank you in advance,

Jerry

I found a website that has 4 possibilities for causes: (taken from: http://www.mcse.ms/archive100-2004-11-1203470.html )

--------------------------------------

1) The database you try to access contains illegal characters in its
path name (for example the & sign).

2) The fields in your database contain .Net reserved words (like e)

3) The System-account doesn't have full rights on the map where your
..Net application is located.

4) (My very own :) The user doesn't have full rights on the
"\Application Data\Microsoft" folder and its submaps in his profile
map. My problem was quite obviously a permission problem since the
administrator account could create a dataset."

--------------------------

1.) I couldn't find anything like that in the path
2.) I used people's first names (just to test this), so I don't that could be it.
3.) I'm using my own personal computer where I am admin...maybe I'm missing a setting.
4.) I have no idea.

Can anybody help me?

Thank you,

Jerry

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jerry Foster20y ago
no one can help me?
Jerry Foster20y ago
I found a website that has 4 possibilities for causes: (taken from: http://www.mcse.ms/archive100-2004-11-1203470.html )

--------------------------------------

1) The database you try to access contains illegal characters in its
path name (for example the & sign).

2) The fields in your database contain .Net reserved words (like e)

3) The System-account doesn't have full rights on the map where your
..Net application is located.

4) (My very own :) The user doesn't have full rights on the
"\Application Data\Microsoft" folder and its submaps in his profile
map. My problem was quite obviously a permission problem since the
administrator account could create a dataset."

--------------------------

1.) I couldn't find anything like that in the path
2.) I used people's first names (just to test this), so I don't that could be it.
3.) I'm using my own personal computer where I am admin...maybe I'm missing a setting.
4.) I have no idea.

Can anybody help me?

Thank you,

Jerry