asked on

creating a relational database in sharepoint to manage a project

hi all..

I have the idea to create a relational database in Sharepoint (ITS SHAREPOINT 2) as it would be of course then accessable by machines without the need for software.,

The idea is for adatabase that tracks a job, holds client info, installation notes and other docs...

any ideas where i should start with this one?

Cris Hanna

Sharepoint uses the Windows internal databse by default. Sharepont is not desiged to work in the way your're considering.

you can set document libraries, based by team, or project, etc. you can set up workflows. There are many types of team collaboration, but its not like an access database

it_saige

As Cris states, Sharepoint on SBS2003 (natively) uses the Windows Internal Database. If you need simply need a database, then either using Access (which is not really the most common method these days) or some other SQL service would be the way that you would want to go. For example, you could install and use SQL Server Express for you database backend. The front end would then be comprised of any method you desire (ASP.NET, VB.NET, C#, C++, etc. etc.) in order to provide a user interface for the clients. As stated above, I personally would not tangle with Sharepoint's database configuration.

-saige-

it_saige

As a point of correction, Sharepoint on SBS2003 Standard, uses MSDE (basically a trimmed down, single instance version of SQL Server 2000), Sharepoint on SBS2008 Standard uses the Windows Internal Database.(basically a trimmed down, single instance version of SQL Server 2005). In either case, the premium editions of both offer full standard versions of SQL Server 2005 and 2008 respectively.

-saige-

ASKER CERTIFIED SOLUTION

shjacks55

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

huntthewumpus

ASKER

hmm looks like i going to have to have a re-think..

dont think sharepoint is the way to go here...

Cris Hanna

It's really hard to judge from this distance whether it does or not...because we don't have vision to all the pieces you are trying to include.

If you enter project management software in Google, you'll find hundreds of options. Windows Sharepoint Services could be the right tool, but I'd for sure want a newer version...but that gets tricky on SBS 2003.

But without a lot more detail and analysis, hard for anyone here to give you a yes or no
It might be worth a trip to Borders or Barnes and Noble, peruse some of the Sharepoint books while enjoying some coffee and get more up to speed on Sharepoint's capabilities to see if it meets your needs

Jeffrey Kane - TechSoEasy

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.