Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating a SQL/Access Database from Scratch Expand / Collapse
Author
Message
Posted Wednesday, July 15, 2009 7:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 15, 2009 8:43 AM
Points: 25, Visits: 55
I'm an one man technical staff for a small (100 person) office which has used an Access Database for 10 years. The current Database has gotten very complicated and on the verg of crashing. I want to move over to an SQL backend with an Access front end, but all my attempts to use migration has failed, due to the complexity of my Access Database. So I need help a blueprint or easy to understand instruction on starting from scratch to design a SQL Back end to an Access front end (only because that is all I have, and my agency will not invest in other programs).

The reason I need to use Access is for ease of use for the Mangement Staff here. The primary use of the Database of tracking Adherence, Leave, Training, Skill Assignments, Call Logs, Monitoring, etc. At present each Supervisor has a copy of the front end Access database, which has been designed to show ONLY their staff.

I Appreciate any direction which will guide me to the structure and development of this project.

Thanks
Post #753419
Posted Wednesday, July 15, 2009 7:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
What version of Access are they using? That may affect what you want to do.

I built and operated a complex application with SQL in back and Access on the front for about 7 years. Worked quite well.

Are you getting a specific error on the upgrade wizards? Or just, it finishes, but the end result isn't what you want/expect?


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #753453
Posted Wednesday, July 15, 2009 7:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 15, 2009 8:43 AM
Points: 25, Visits: 55
Thanks for your response. I have Access 2007, and SQL Express 2005. I started this project many months ago, then got engaged & then Married..... so I dropped that project until I got settled in with the new wife. Now I'm starting over to get this done. The original attempts to convert the old Access failed at many levels, and many functions did not come over. I've since decided to start from scratch because that ten year old Access needs some real cleanup.

I appreciate any guidance. Thanks
Post #753464
Posted Thursday, July 16, 2009 7:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
Starting from scratch sounds like a reasonable idea.

Take a look at what the Import Wizard in SQL Management Studio might be able to do for you, at least as far as getting tables set up. That's where I'd probably start.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #754125
Posted Friday, February 26, 2010 3:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 26, 2010 9:10 AM
Points: 149, Visits: 451
how did this end up? I'm curious?
Post #873745
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse