How to Add a Data Source in Visual Studio C# Without Errors

I am developing a program in Visual Studio C#. I am trying to add a data source to it so
that it can have a database displayed in a DataGrid. When I go to "Add Data Source" and follow the steps, I get the following error: "Could Not Retrieve Schema Information For Table or View". The database is in an .mdb file in the same directory as the program. Can anyone help with this error?
Leonard GojerCAD Technician/ProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LearnedCommented:
What version of Access are you working with?

What version of Visual Studio.NET are you using?
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Access 2003.
Visual Studio 2010 Premier.
0
Bob LearnedCommented:
To make sure that I understand what you are referring to, are you talking about the Data > Add New Data Source menu option?
0
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Yes.
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Hello,
I see that my question has stumped you. I think maybe that I should subscribe to some other service as a way of getting this question answered, because it's kind of an advanced C# question on a relative scale. Can you recommend some service to me that would be such a resource, (perhaps charging under $30/month)?

I am trying to develop this project for a commercial application, but I can't afford a support contract from Microsoft.
0
Bob LearnedCommented:
I don't work with Access very much, and I have Access 2010.  Also, I don't use the Add Data Sources dialog, so I needed to review.  Sometimes I  get involved in too many questions.  Lastly, I have my own production issues to take care of, which means I can't dedicate all my time.

Did you try the same process with different databases?  Is this a problem with the computer, or the database structure?
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
I checked your question and it has the same problem with any database that I create.

I am going to be away from this computer for a couple of days, so you won't have to attend to this problem until sometime like Monday.
0
Bob LearnedCommented:
Where are the databases that you are trying to connect to with the dialog?  I was assuming local machine, where you should have full rights.  The dialog needs access rights to the target file.

Is this Windows 7, Windows Vista, or Windows 2008 Server?
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
I have to try looking into that when I get there, but I am not there right now, so I will
talk to you on Monday. The machine in question is a virtual machine on a server running
Windows XP.
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Hello, I am back from my trip out of town.

I have several books on C#, but I haven't read them thoroughly. It could be that the answer to this question is in one of those books.

I'd like you to help me to understand how I go about looking up this question in one of those books, so that I can be on my own with respect to this problem. Maybe you can give me some "clues" that will get me started to fix it for myself.
0
Bob LearnedCommented:
That error suggests that you don't have access rights to the database.  The dialog is trying to get information, but doesn't have the necessary security permissions.

What operating system are you working with on your virtual machine?

What are you using for your virtual machine?
0
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
The virtual machine is VMWare running Windows XP.
0
Bob LearnedCommented:
Windows 7 and Windows Vista have special User Access Control (UAC), that would be a possibility, but Windows XP doesn't have that extra protection.  I don't have any experience with configuring VMWare, so I can't be of any help there.  You would have to ask a different question related to VMWare, if you think that is the cause of your problem.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
I am going to close this question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.