Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Converting Access Database to SQL

Author  Topic 

scottsowles
Starting Member

3 Posts

Posted - 2009-09-09 : 15:54:31
First time poster looking for some help from the "experts". I've been tasked with converting all of our access databases to SQL to alleviate licensing costs. The converting of the database to SQL back-end isn't a problem. My problem is what do I put on the front-end for users to view the database and enter in data?? Has anyone completed this tasks? What steps are involved? Are there gotcha's to be on the lookout for??

Any and all insight is greatly appreciated.

Scott

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-09 : 16:12:06
Can't you point the Access frontend to the SQL backend?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

scottsowles
Starting Member

3 Posts

Posted - 2009-09-10 : 09:29:31
Yes you can, but I'm trying to alleviate the licensing costs to have Access loaded on each workstation. Trying to find a cheaper alternative.
Go to Top of Page

dportas
Yak Posting Veteran

53 Posts

Posted - 2009-09-10 : 10:56:05
quote:
Originally posted by scottsowles

Yes you can, but I'm trying to alleviate the licensing costs to have Access loaded on each workstation. Trying to find a cheaper alternative.



How about developing it in .NET? You could also consider making it a browser-based app. There are lots of other options for developing applications of course but .NET does have the benefit of good integration with SQL Server.
Go to Top of Page

scottsowles
Starting Member

3 Posts

Posted - 2009-09-10 : 11:41:07
First of all, thanks for the comments and suggestions. Unfortunately I'm not a .NET developer and don't have time to learn and support the product. Is there a boxed product available that you're aware of for integrating a web front-end??
Go to Top of Page
   

- Advertisement -