Solved

Migration from ACCESS front end for SQL Server to web-based front end--advice needed!

Posted on 2012-03-12
8
861 Views
Last Modified: 2012-03-20
Hello,

I have a MS Access with a lot of forms and reports that is connected to a SQL Server backend.  This has been working out ok for some years.  However, since everyone in the office is on a MAC, I would like to make the front end to the SQL Server database accessible from the web (or even program installed on MAC OS of each computer).  I am familiar with Dreamweaver (have just downloaded Visual Studio, but am not convinced), but was wondering if anyone perhaps had a better suggestion....time is of the essence as I need to deploy this rapidly.

Many thanks in advance.

Cheers!
0
Comment
Question by:cougarsy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 37713297
not sure but things that come to mind

maybe look at asp.net (have a look at the asp web matrix free software to look at the easy way of developing apps) http://www.asp.net/web-pages

is there some kind of emulator for windows that can run on mac? maybe something like winehq. I have never used a mac so am not too familiar with it.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 37713300
did a quick google search for possible products and found this. a trial is available. maybe it might help?

http://dbconvert.com/convert-dbforms-access-to-aspnet.php
0
 

Author Comment

by:cougarsy
ID: 37713324
Hi,

I do have Access running on the Macs via Parallels, but I guess I should have added in my first post that not only is there a drawback of having to launch Windows to run Access, but also that Access is just limited.  As we have people accessing the database from different locations, I wanted to get away from having to have Windows and Access installed.  So, I wanted to migrate to a front end that is web-based and login protected.  

I am downloading WebMatrix and will see if that might work.  Your second link looked interesting but on further inspection I think that they are taking Access databases and front ends and migrating both to ASP.NET and SQL Server.  I already have a SQL Server database and I just want to find a tool to use that will allow me to quickly set up forms for web-based GUI that perform functions the Access forms are doing.

Thanks again,
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37713640
You could look at Office 365 and move the database(s) to the cloud. Relatively easy to setup, not too expensive (you'd need the medium sized business package. There are a few gotchas though. All connections have to havean IP address specified for security - for some businesses that is a problem. If you can make it work, it saves the hassle or redevelopment. Internally, perhaps Citrix (can that be delivered to a Mac?).


Kelvin
0
 
LVL 84
ID: 37713821
Given that you write this:
.time is of the essence as I need to deploy this rapidly.
and
with a lot of forms and reports that is connected to a SQL Server backend.
Then I'd have to agree with kelvin that a Citrix/Terminal Server setup would be the quickest route to success, given your requirements/limits/needs.

There's also eqldata.com, which is a paid service that would make your existing db instantly available to your users. It's not cheap, but it is the single easiest route to sharing data with remote users.

If you have extra time, then moving the application to a web-based frontend, using the technology of your choice, would make sense. Personally, if you have experience with Access and VBA then a move to ASP.NET would probably be the least painful, but of course your experience may be different.
0
 

Author Comment

by:cougarsy
ID: 37713876
Hello all,

Thank you for your responses....very interesting--all of it--and programs I didn't even know existed.  Our SQL Server DB is already on a web server, so I really just need a front end.  I have worked in Dreamweaver, so am going to evaluate if WebMatrix, Visual Studio or Dreamweaver would be the most efficient for me, time-wise.

I was hoping to find more of a WYSIWYG program to recreate the Access forms without a lot of coding.

Thanks again!
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 37713885
Visual Studio is very similar to the Access interface in terms of drag-drop. There's also Microsoft Expression Web, which is a dedicated web editor along the same lines as VS.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37713889
The momemnt you move from Access you get two problems - forms - replace with some web system and reports - they don't readily convert to the web - you'll need a report server - these days either Crystal or SQL Server's SSRS (Sql Server Reporting Services). If you're in a hurry, and you have lots of forms and reports - then its just not achievable as LSM has already indicated. If it were me, I'd be going for Citrix or Terminal services as a short term one while you evaluate your options and determine the effort - it will be substantial. Access has survived as it is one of the very few complete packages out of the box that provide a rapid application development tool. You''' be surprised how much time redevelopment will take unless your forms and reports are very simple.

Kelvin
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question