Office & Productivity Software forum

Question

Need Help Finding an Appropriate Database for my Needs

##-The Issue
I have a collection of books, articles, & papers numbering into five digits XX000....that I have amassed over the last ten years. Till now I have used dedicated external drives using Windows filing systems. Iv got to the point where directories are too long and accurate backups are impossible


##-What I want in a database

1/ A simple interface with simple functions
2/ [Ideally] allowing me to plug and play the external drive on other computers and still have access to the database information/sorting system
3/ To have all the materials on one directory level so I don't have to worry about access or copy problems
4/ To be able to categorise into subject matters and assign individual files to multiple categories
5/ To be able to use simple entry tags, name, date, book/article etc
6/ Search

- Portability is important
- It's for private not business use
- It needs to be reasonably priced or free

Ps. Even if your responses do not cover ALL my needs I am still interested in answers relating to products

Answer This Ask For Clarification
Discussion is locked
You are posting a reply to: Need Help Finding an Appropriate Database for my Needs
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Need Help Finding an Appropriate Database for my Needs
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

All Answers

Collapse -
Answer
Re: database

In reply to: Need Help Finding an Appropriate Database for my Needs

I would recommend using a document management system. There are free open source ones.
https://www.google.com/search?q=open+source+dms seems a good start for you.

Of course, these systems reply on the OS for the storage and on you for the backup of all your files. I've never seen a backup system that couldn't make an image copy or even an incremental copy of a disk with too many directories or files. Since you're mentioning external drives, let me tell these are unreliable for storage and need extra care for backup. Why not use internal disks in your PC?

Collapse -
Re: database

In reply to: Re: database

Thanks for taking the time to respond.

I"'ve never seen a backup system that couldn't make an image copy or even an incremental copy of a disk with too many directories or files" - the problem is not the sheer amount of files, the issue is when a directory gets too deep/long i.e. Folders within folders....strings of subdirectories - there is a limit of pathways of 260 characters https://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx#maxpath ....... sometimes even these files don't copy properly.

"Why not use internal disks in your PC?"
I work on three PCs in total, it's ineffective and requires me to back up two other PCs when I add files to one of them - I'm not totally against it but the new situation of organising my files would have to be worth it i.e. the database would have to be good

I'll check out your suggestion Happy

Collapse -
Re: database

In reply to: Re: database

Two remarks:
- If your 3 PC's are in a network, you can access files of any or them on any other of them. It's just another drive letter.
- The maximum path length shouldn't be limiting only in a backup, but in normal use also. And on an image copy it's identical as on the original.

Collapse -
Re: database

In reply to: Re: database

- No network
- All the pathways are limited, and from experience, I know they vary in length so it would seem from device and system. Quite unintuitively I can have two blank hard drives, copy data over to both at the same time and end up with a different amount of files.

- I use what I currently do now because it is the simplest way of doing things - I need no software etc - if I did not have the path too long issue I would continue with the strategy I am currently using. Alas that is not the case

Collapse -
Answer
If the files have valid LFNs (long file names) then

In reply to: Need Help Finding an Appropriate Database for my Needs

I've been successful for years using a ZIP program. It also reduces the number of files to just one in a backup set.

Collapse -
If the files have valid LFNs (long file names) then

In reply to: If the files have valid LFNs (long file names) then

I have tried copying from one drive to the next zipped but the files are still missing in the target directory

Collapse -
Then why is the question.

In reply to: If the files have valid LFNs (long file names) then

When I do this I usually find there is a reason. Permissions, invalid name, file is locked by another process and so on.

There's always a reason, but what it is changes with the machine.

In parting, I find Roadkil's Unstoppable copier sometimes gives me a clue which file and why it didn't copy.

Collapse -
Answer
Database suggestion

In reply to: Need Help Finding an Appropriate Database for my Needs

Hey,

Have you heard of zenkit? It's project management software that can also be used for personal use. Their database feature sounds like the ideal tool for your requirements.

It has a simple interface with simple functions. Their label field feature allows you to categorise as your heart desires. It's also cloud-based which means you can access it from just about anywhere.

Not working link removed by moderator.

Post was last edited on June 28, 2018 6:39 AM PDT

Collapse -
Re: database suggestion

In reply to: Database suggestion

The link didn't work, so I disabled it. And I doubt if project management software is very well suited for a document management system.

Collapse -
Answer
Well Access is a database system that

In reply to: Need Help Finding an Appropriate Database for my Needs

comes with MS Office. It's is Office 365 Personal for 69/year and Home for 99/year.

Popular Forums

icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

REVIEW

Sublime suburban chariot

High on style and technology, the 2019 Volvo XC90 is an incredibly satisfying everyday crossover.