• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Visual basic and Microsoft Access

hello guys i want to make a software that uses access at back end i have made like all pages in access i want them to be operated via vb .net program to add data to those pages,edit any data and delete if required and store the data so question is what things i need o do????

m using vb .net 2008 and ms access 2007
0
rosa545
Asked:
rosa545
1 Solution
 
Jeffrey CoachmanCommented:
From what you posted here, ...why not just migrate the entire app to vb.net...?
Thus eliminating all of the potential "Interoperability" issues...
0
 
Jacques Bourgeois (James Burger)Commented:
Why do you want to do it that way?

Is there a reason why you do not do it entirely in VB.NET or entirely in VBA Access?
0
 
rosa545Author Commented:
no there is no specific reason i just want to learn that integration can that be done or i wud have to make every thing from scratch in VB .net
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Jeffrey CoachmanCommented:
...Interesting...

I have not seen that much info on this.

Kinda like asking can Windows 7 be configured to control DOS...
;-)

So if this is something you are doing out of "Curiosity" then that is another story...

You may have to post some very specific scenarios and post detailed descriptions of your existing systems...


JeffCoachman
0
 
tlaytonCommented:
Here is an article on converting VBA code to .NET, hope it is useful:

http://msdn.microsoft.com/en-us/library/aa192490%28v=office.11%29.aspx

Personally I would rather rewrite in VB.NET from scratch though...
0
 
Jacques Bourgeois (James Burger)Commented:
I have never seen a scenario where it would be useful to have a .NET application control the forms in an Access database.

Usually, .NET is used to work with the tables and the queries and provides the screens as Windows Forms. You do not connect to Access to do that, you do it with ADO.NET or one of the .NET technologies that wraps around ADO.NET (Data Entities or LINQ).

As an alternative to what is available in .NET for reporting, you might however use Access for its reports capabilities. Since most of my customers used Access before I moved them to SQL Server, Access is available on their station, and I use it as a report generator for most of their applications, with code such as this one:
Dim accessApp As Access.Application = New Access.Application
accessApp.OpenAccessProject("<Path + Database>.mdb") 'or .accdb
accessApp.DoCmd.OpenReport("<ReportName>")
accessApp.DoCmd.Close(Access.AcObjectType.acReport, "<ReportName>")
accessApp.Quit

Open in new window

Note that you could use similar code to work with the forms if you wanted to, but as told before, creating the forms in .NET would be a better choice if you need your .NET application to interact with the database.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now