database server

patrickv · 03-18-2007, 12:20 PM

ok so i've never actually setup a database server or better yet, i dunno anything in databases on servers but i do know Microsoft Access. anyhow can someone tell me what i will need in order to do this !!
i wil install server2003 but from there am doomed...

help greatly appreciated

patrickv · 03-28-2007, 12:53 PM

ok maybe i didn't give enough info. i want to upload access files on a small (intranet) site so users can do data entry...any ideas ?

RoveWolf · 03-28-2007, 01:28 PM

What sort of data entry are you wanting your users to do? Is it basic 'entering information into the correct fields with each individual user entry containing the same information categories?'. Meaning will the fields constantly be things such as: Name, Information, date etc.. etc.. Or will they always change per user entry?

If you plan on doing it the same way I mentioned above then you wouldn't really need to setup a 'server' so to speak. You could just install your own webserver software on a normal desktop machine and host a basic website / webpage with the correct fields on them that allow users to manipulate the information within a database. Sounds more complicated than it is. Although it would require you to have some knowledge on using Dreamweaver. That's how I done a similar sort of thing.

patrickv · 03-28-2007, 05:26 PM

yes thats exactly what i wanted to do but i have no knowledge at all in dreamwearver nor access but i used adobeGOLive some years ago but anyways,how do get the info to be saved directly into the access database i created ?

i mean when users enter data online that data has to be saved somewhere but i want it to go str8ght to my access database

RoveWolf · 03-30-2007, 11:25 AM

The only way I know how to do such a thing is via dreamweaver unfortunately. I never program / create my websites in anything but. What your asking to do isn't actually a hard task within Dreamweaver it just takes a little time. I'm not entirely sure how else to do it. Writing out the code manually for such a thing would be a nightmare, not to mention extremely hard.

patrickv · 03-30-2007, 12:06 PM

thanks, i'll get a copy of dreamweaver and some tutorials and see what i can do.
many thanks

lee101 · 03-30-2007, 04:39 PM

Before you go and get dreamweaver, Microsoft's Visual Web developer will probably be better for integration with Access databases, since it can create a lot of code for you, it is totally free from:
http://msdn.microsoft.com/vstudio/ex...d/default.aspx

03-18-2007, 12:20 PM	#1 (permalink)
patrickv Diamond Member Join Date: Jul 2006 Location: Soul Chamber Posts: 5,426	database server ok so i've never actually setup a database server or better yet, i dunno anything in databases on servers but i do know Microsoft Access. anyhow can someone tell me what i will need in order to do this !! i wil install server2003 but from there am doomed... help greatly appreciated __________________ Laptop: Thinkpad X60: Core2Duo T7200 @ 2Ghz,1GB DDR2,110GB SATA -winXP ProSP2 Work Desktop: Core Duo E2180 @ 2Ghz,1.5GB DDR2,240GB HD - XP PRO SP2 Home: Core Duo E2180 2Ghz,1.5GB DDR2,Nvidia GForce 6200TB,320 GB (2x160GB) -Dual boot - XP / OSX 10.5.2

03-28-2007, 12:53 PM	#2 (permalink)
patrickv Diamond Member Join Date: Jul 2006 Location: Soul Chamber Posts: 5,426	ok maybe i didn't give enough info. i want to upload access files on a small (intranet) site so users can do data entry...any ideas ? __________________ Laptop: Thinkpad X60: Core2Duo T7200 @ 2Ghz,1GB DDR2,110GB SATA -winXP ProSP2 Work Desktop: Core Duo E2180 @ 2Ghz,1.5GB DDR2,240GB HD - XP PRO SP2 Home: Core Duo E2180 2Ghz,1.5GB DDR2,Nvidia GForce 6200TB,320 GB (2x160GB) -Dual boot - XP / OSX 10.5.2

03-28-2007, 01:28 PM	#3 (permalink)
RoveWolf VIP Member Join Date: Aug 2006 Location: West Midlands, UK Age: 22 Posts: 1,257	What sort of data entry are you wanting your users to do? Is it basic 'entering information into the correct fields with each individual user entry containing the same information categories?'. Meaning will the fields constantly be things such as: Name, Information, date etc.. etc.. Or will they always change per user entry? If you plan on doing it the same way I mentioned above then you wouldn't really need to setup a 'server' so to speak. You could just install your own webserver software on a normal desktop machine and host a basic website / webpage with the correct fields on them that allow users to manipulate the information within a database. Sounds more complicated than it is. Although it would require you to have some knowledge on using Dreamweaver. That's how I done a similar sort of thing. __________________ Note: Formerly known as Breaks. Thermaltake VC3000BWS Armour Jr SuperMidi Tower - Black Gigabyte GA_965P_DS3 PCI-Express DDR2 Motherboard Intel Core 2 DUO E6300 "LGA775 Allendale" 1.86GHz (1066FSB) HIS ATI Radeon X1950 Pro ICEQ 3 V2 TURBO SILENT Heatpipe 256MB GDDR3 (PCI-E) Western Digital Caviar RE 160GB SATA-II 16MB Cache Enermax Noisetaker 535W EG565AX-VE(W) SFMA ATX2.0 SLI Compliant PSU Corsair 2GB DDR2 XMS2-6400C4 TwinX (2x1GB) Samsung 18x18 DVD+RW (Black)

03-28-2007, 05:26 PM	#4 (permalink)
patrickv Diamond Member Join Date: Jul 2006 Location: Soul Chamber Posts: 5,426	yes thats exactly what i wanted to do but i have no knowledge at all in dreamwearver nor access but i used adobeGOLive some years ago but anyways,how do get the info to be saved directly into the access database i created ? i mean when users enter data online that data has to be saved somewhere but i want it to go str8ght to my access database __________________ Laptop: Thinkpad X60: Core2Duo T7200 @ 2Ghz,1GB DDR2,110GB SATA -winXP ProSP2 Work Desktop: Core Duo E2180 @ 2Ghz,1.5GB DDR2,240GB HD - XP PRO SP2 Home: Core Duo E2180 2Ghz,1.5GB DDR2,Nvidia GForce 6200TB,320 GB (2x160GB) -Dual boot - XP / OSX 10.5.2

03-30-2007, 11:25 AM	#5 (permalink)
RoveWolf VIP Member Join Date: Aug 2006 Location: West Midlands, UK Age: 22 Posts: 1,257	The only way I know how to do such a thing is via dreamweaver unfortunately. I never program / create my websites in anything but. What your asking to do isn't actually a hard task within Dreamweaver it just takes a little time. I'm not entirely sure how else to do it. Writing out the code manually for such a thing would be a nightmare, not to mention extremely hard. __________________ Note: Formerly known as Breaks. Thermaltake VC3000BWS Armour Jr SuperMidi Tower - Black Gigabyte GA_965P_DS3 PCI-Express DDR2 Motherboard Intel Core 2 DUO E6300 "LGA775 Allendale" 1.86GHz (1066FSB) HIS ATI Radeon X1950 Pro ICEQ 3 V2 TURBO SILENT Heatpipe 256MB GDDR3 (PCI-E) Western Digital Caviar RE 160GB SATA-II 16MB Cache Enermax Noisetaker 535W EG565AX-VE(W) SFMA ATX2.0 SLI Compliant PSU Corsair 2GB DDR2 XMS2-6400C4 TwinX (2x1GB) Samsung 18x18 DVD+RW (Black)

03-30-2007, 12:06 PM	#6 (permalink)
patrickv Diamond Member Join Date: Jul 2006 Location: Soul Chamber Posts: 5,426	thanks, i'll get a copy of dreamweaver and some tutorials and see what i can do. many thanks __________________ Laptop: Thinkpad X60: Core2Duo T7200 @ 2Ghz,1GB DDR2,110GB SATA -winXP ProSP2 Work Desktop: Core Duo E2180 @ 2Ghz,1.5GB DDR2,240GB HD - XP PRO SP2 Home: Core Duo E2180 2Ghz,1.5GB DDR2,Nvidia GForce 6200TB,320 GB (2x160GB) -Dual boot - XP / OSX 10.5.2

03-30-2007, 04:39 PM	#7 (permalink)
lee101 VIP Member Join Date: Mar 2005 Location: UK Age: 17 Posts: 1,150	Before you go and get dreamweaver, Microsoft's Visual Web developer will probably be better for integration with Access databases, since it can create a lot of code for you, it is totally free from: http://msdn.microsoft.com/vstudio/ex...d/default.aspx __________________ My PC: Core2Duo E6300 @ 1.86 Ghz, Asus P5v-VM DH , 200 GB Maxtor SATA ,2GB (21GB Kingston DDRII), Radeon x1650 Graphics (256 mb), 2 Acer 17 inch TFT's, Windows Vista Home Premium Server: AMD Athlon XP 2800+ 256 Mb Ram, 8Gb IDE for o/s, 2 * 250GB SATAII for storage, Ubuntu Server 7.10

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
server database	jedijeff123	Computer Networking and Servers	0	03-17-2007 06:45 PM
DX 10 for Vista!?	ADE	Computer Games and Consoles	15	03-09-2007 01:58 PM
DMZ and Ping issue when changing ip address for a server	cargo	Computer Networking and Servers	2	01-08-2007 09:39 PM
Proxy servers	The Astroman	Internet Discussion	8	03-22-2006 09:51 PM
How can I set up a server?	Bootup05	Internet Discussion	2	02-26-2006 10:41 AM