Results 1 to 8 of 8
  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659

    Access with .net

    Is there a version of MS Access that uses .net for code behind instead of vba?

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    I think they call that Microsoft SQL Server.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    No, not that I am aware of. Access is the RAD program that comes with Jet (which is the database engine). SQL Server, SQL Server Express, Oracle, DB2 and MySQL are examples of other database engines.

    .Net is a programming language. There is nothing stopping you from using .Net to create the interface to access a database engine. You could also use VB, C, C++, C#, Java, ect.

    My $0.02 worth....

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Alright thanks

  5. #5
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    To my knowledge there is no way to use .net as accesses IDE editor. As stated you can write dll's in .net and then call them from access.

  6. #6
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Is there any benefit to staying inside access for developing with .net dll's instead of just moving the project into visual studio as a whole?

  7. #7
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    access is a rapid development environment. .Net is a more enterprise environment with a longer development cycle from my experience.

  8. #8
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    SQL Server, SQL Express, MySQL, DB2, Oracle are basically data containers. HOW you access the data depends on your requirements and how much money you want to spend.

    You can build the UI in VB, VC, C, C++, C#, .Net, Perl, Access, etc......and a lot of it depends on the programmer(s) available.
    Access is a Windows only application. If you developed the UI in, say C++, it could be compiled for use in Linux or a Mac and still access the data in whatever back end you want to use...

    Requirements and money is all it takes.

    My $0.02 worth

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums