User interface that is not Ms Access Front End

If i wanted to migrate my Access Front end database to something else what would that be.

If needed to i could put the back end in a sql database, it's in access right now. I'm just looking for something that is smoother and cleaner than access. Can't i build a GUI using VB and tie the data into somehow.
jb702Asked:
Who is Participating?
 
mbizupCommented:
.Net as the others have said is good for GUI development if you want to get away from Access.  VB.net specifically is a good first step, because you will find it very similar to Access VBA in many respects, and likely quicker to learn initially than C#.  There are some common VBA-specific commands that will not work in .net such as the domain functions, and also .Net commands/features that are not available in Access -- but for the most part, the syntax, basic conditional and looping commands, etc will be familiar to you.

Some major differences with the .net environment...

In Access you are working with databound objects which makes dealing with your tables (displaying data, updating, inserting, deleting, etc) almost automatic.  In .Net, you will be programming this functionality -- a bit of a learning curve if you have not worked with unbound forms in Access.  

You'll find a wider variety of skills needed to build a .Net application.  Like in Access, there is a robust visual design environment for developers where you can drag/drop and arrange objects on your forms.  But it is not nearly as easy to manually get the layout you want as it is in Design View on Access forms and reports.  In addition to VB, C# or whatever.Net, HTML skills are important in developing your forms' layout/design and CSS for refining the styles,

So there are many more things/skills involved in developing a .Net application.

Access development involves:
     -- VBA and SQL

.Net involves
    --  Language(s) such as VB or C#, SQL, HTML, CSS, and possibly more depending on your application.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sure, but forget about the "migrate" part.   There's nothing out that (at least that I'm aware of), that's going to take your Access DB and convert it to something else.

But as far as a GUI, you can go PHP or ASP.net for web based, vb.Net or C#.net, and the backend data can be in a JET database (Access) or SQL Server.

Jim.
0
 
jb702Author Commented:
So your saying i would use PHP and ASP.net for something on the web, and vb.net or C#.net for something for the PC. How hard is it to learn PHP or ASP.net as this would be something that i would like to put on the net so i can access it from while at home. It seems like i'm always working on it.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
chaauCommented:
Learning new things is always a challenge. If you have experience with Access VBA, I think, learning ASP.Net with VB.Net should be easier than php. You will find that php is a bit more different to VBA than VB.Net.

You can leave the data in your access database, or migrate to SQL Server depending on how big your data is and how many concurrent users you are going to have. SQL Server seems to be better when you have many users
0
 
Gustav BrockCIOCommented:
You can use LightSwitch to create either (or both) a desktop app or an HTML5 site:

http://lightswitchhelpwebsite.com/
http://msdn.microsoft.com/en-us/library/ff851953.aspx

It is _very_ different from Access so you must "wipe the mind" but once you get it, it is quite fast to work with. Also, the language is either C# or VB.NET so if these are new to you, prepare for some learning time (which, however and indeed for C#, you will never regret).

/gustav
0
 
jb702Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.