vs.net and access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I open a database application using Visual Studio.net? I have a database
that was created by a former employee and I need to see how it is structured
but it only allows me to go to the application. There are no reports and
there is no code that I can see but that does not mean anything.
Any help would be appreciated.
 
Can I open a database application using Visual Studio.net? I have a
database that was created by a former employee and I need to see how
it is structured but it only allows me to go to the application. There
are no reports and there is no code that I can see but that does not
mean anything.
Click to expand...

There are two ways, depending on what you want to achieve.

You can access the data (i.e. tables and queries) using a library such as
ADO.NET but, as you have noticed, this will not get at the Access stuff
like forms and reports.

You can access the whole thing by using OLE Automation. I don't have
experience using dotnet to do that, but it's presumably the same thing in
principle as using the old COM interface. Look up dotnet help for
something like CreateObject.

Since you are using a forms-based application environment anyway, is
there any difficulty in just reproducing the Access forms in your own
language? You'll find it's a little bit more work but you will have
enormously increased functionality.

Hope that helps a bit.

Tim F
 
Back
Top