Database

Admirer Of Digit · 29-01-2010, 09:05 PM

I want to make a database which contains the contents of DVDs OF All months issues in such a way that helps me to look for any utility easily contained in any DVD as the Digit Finder is not running on my system and showing errors.....

For this I want to make tables with Table name as of "Multimedia" or "Games" or "System" etc. with Field Names as "Jan10" or "Dec09" .......{as per months publication}

Please help me out how can i make such a database on MS Access or suggest me some other DBMS on which my problem can be sorted out easily.....

Help me out.......

krabhishek · 01-02-2010, 10:04 PM

Quote:

Originally Posted by Admirer Of Digit

I want to make a database which contains the contents of DVDs OF All months issues in such a way that helps me to look for any utility easily contained in any DVD as the Digit Finder is not running on my system and showing errors.....

For this I want to make tables with Table name as of "Multimedia" or "Games" or "System" etc. with Field Names as "Jan10" or "Dec09" .......{as per months publication}

Please help me out how can i make such a database on MS Access or suggest me some other DBMS on which my problem can be sorted out easily.....

Help me out.......

Try out MySQL. Its very simple and lightweight (and much much much much more advanced RDBMS when compared to MS Access). Its free and opensource.

As far as creating the database is concerned, its actually quite easy. You can use PHP as frontend. That way you can even put your software up on your website also if you want, else you can run it locally right out of your browser. If you are running OpenSolaris then you can install amp-dev package (it included preconfigured php and mysql) (open http://tr.im/ampdevpkg from your opensolaris box to install using web installer) and install phpMyAdmin to manage your database (http://pkg.opensolaris.org/contrib/e...ken=phpmyadmin)

If you are running linux then you can individually install mysql and php and configure it or you can install something like XAMPP for Linux.

Here are some tutorials: http://knol.google.com/k/jayadev-kam...rl65u0kyb4n/2#

phpMyAdmin: http://www.siteground.com/tutorials/...ase_manage.htm

Hope it helps.

~Abhishek

Garbage · 01-02-2010, 10:48 PM

Or you can Digit Archives ?

Admirer Of Digit · 15-02-2010, 10:49 PM

Quote:

Originally Posted by Garbage

Or you can Digit Archives ?

digit archives is not wrking on my comp. please gve me a better way out.............. & My SQL is not suitable please gve something better.......................................

Admirer Of Digit · 28-03-2010, 12:20 PM

Please help me out..................

Admirer Of Digit · 01-04-2010, 07:43 PM

Please help me.....

Aspire · 06-04-2010, 07:55 PM

MySQL seems to be the only way
OR
You could try MS Access. Its simple and straight forward. You only need to have the right database structure in mind.

Tron91 · 09-04-2010, 04:04 AM

Try fiddling with MS Access. Its simple and straight forward. You only need to have the right database structure in mind. You will need to put one field for storing the software version too! That one will be a bit messy. For example you might need to search for version 2.3.123.789 or 1.03! Figure that out!

Admirer Of Digit · 11-04-2010, 09:19 PM

Quote:

Originally Posted by Tron91

Try fiddling with MS Access. Its simple and straight forward. You only need to have the right database structure in mind. You will need to put one field for storing the software version too! That one will be a bit messy. For example you might need to search for version 2.3.123.789 or 1.03! Figure that out!

Ya, i tried it but the problem comes is that there are 100s of softwares in each digit magazine....

And the copy paste option from the site to MS Access does nt works......

And if we will export it through copying in Notepad & importing then the softwares will be arranged only in one coloumn...

Whereas i want that the softwares in each coloumn would be of one type eg. in one coloumn all softwares related to internet, & so on....

Please gve me a good way... out....

Admirer Of Digit · 13-06-2010, 06:44 PM

Please help me out./..........

Aspire · 13-06-2010, 11:23 PM

no access or frontpage on Windows 7

Time to move on to open source...............

---------- Post added at 11:23 PM ---------- Previous post was at 11:19 PM ----------

If i recall correctly, there used to be an option in the menu giving you the freedom to split the contents of a cell into multiple cells if there was a space between the words.

so what you need to do is:
1. copy the contents into a notepad file
2. import it
3. split the contents into multiple cells using that tool