Completed

microsoft access database

One of our fileservers has been in use for about 10 years now gradually collecting more and more documents and files over the years. We need to have a clear-out!

I've trawled the main hard drive on the server with a script and have produced a .csv file with a complete list of every file on it together with its size, date created and date last accessed. I want to suck this into a Microsoft Access 2003 database with a simple front-end to allow us to quickly browse through the folders (and the files in each folder) to establish whether we want to...

1. Keep the file forever where it is

2. Keep the file where it is until the next review occurs

3. Keep the file for a finite amount of time e.g. 3, 6, 9, 12, 18, 24 months etc

4. Delete the file immediately

5. Keep the file but move it off the server into an Archive Drive (directory structure / file location to be preserved, just moved from say c:\Docs1\January\[login to view URL] to d:\Docs1\January\[login to view URL]

Front-End should be primarily in two parts, one top section to display all the directories, maybe against each directory could be the oldest file, youngest file, size of the largest file within its immediate directory, this would enable us to sort the directories into an order so we could prioritise some of the oldest files, files hardly ever used, largest files we could get rid of etc, i.e those files which would have the biggest impact on the space available on the server (we're looking to archive / delete a lot of stuff to free space). The bottom screen section would display all files in the directory selected in the top section.

For each file we would need to be able set the attribute as per 1-5 above together with a "keep until" date for those attributes where we would keep the file for a finite amount of time. Also required would be a facility to set all the files in the immediate directory with the same attribute e.g. for those directories which contain many hundreds of files, to save setting the attribute for each file individually.

There would be a .csv file containing all the file / directory info. This would need to be sucked into an Access 2003 .mdb file. So we could run the procedure again in the future on a new set of files, we would need a facility to be able to....

1. Append any new files that didn't exist in the previous .mdb file

2. Update any existing files already in the database with new attributes if they have changed, but keeping the pre-assigned designations 1-5 above

I know how to program this myself, however i am looking to outsource for efficiency and to free my time for other projects.

Skills: Microsoft Access

See more: database design microsoft access, lawyer database access microsoft, database flower microsoft access, wordpress microsoft database access, database tables microsoft access, database invoice microsoft excel access, database shop microsoft access, census database access microsoft, chemical inventory database access microsoft, access microsoft money 2004 database, design recycling database system microsoft access, asp form microsoft database access, simple database student microsoft access, chemicals database access microsoft access, database projects microsoft access doc

About the Employer:
( 6 reviews ) Hayes, United Kingdom

Project ID: #13266968

Awarded to:

torajiv

Hello Importing the csv should be pretty straight forward. I can provide you with an advanced search form where you will be able to filter out and sort the data by one or more parameters. You will also be able to m More

$150 USD in 3 days
(153 Reviews)
0.0

14 freelancers are bidding on average $257 for this job

$111 USD in 5 days
(1 Review)
0.0
paskal77

Hello Sir /Ms, I have received the specification of your project and I am sure to be able to develop it, I would recommend using ms sql server and developing the front end using a win form Please check the pa More

$222 USD in 7 days
(3 Reviews)
0.0
$257 USD in 10 days
(0 Reviews)
0.0
Deenario

I am an Oracle certified database developer. Currently working in Hadoop MapReduce. I have been doing this work for 6 years now. I understand your system and really want to work on this for you. My bid is alot lower th More

$222 USD in 10 days
(3 Reviews)
0.0
fazeelraza

Hello, sir. I am a Software Engineer and I have been doing all types of Access, SQL, mySQL, databases over past 4 years. I understand your project requirements as mentioned in description. There are few things regardin More

$250 USD in 3 days
(7 Reviews)
0.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$500 USD in 15 days
(89 Reviews)
0.0
AlexandrUKR

please clarify possible next steps

$250 USD in 7 days
(12 Reviews)
0.0
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$257 USD in 10 days
(0 Reviews)
0.0
$240 USD in 3 days
(0 Reviews)
0.0
zu02

Hi, Dear I hope all's well with you. I'll be shortly: I capable to make ms Access DB for your project. In my opinion here need to build Access split DB (i.e. Access front end and back end) Don't hesitate to ask qu More

$555 USD in 7 days
(44 Reviews)
0.0
asem1199

dear sir i can do your work because i worked in many projects of access 2003 and i achieve this work , you can give me this chance thanks asem

$277 USD in 5 days
(0 Reviews)
0.0
Prashantskin

[login to view URL] I have gone through your detailed project requirements. I will do all the things narrated in that description. I am confident of doing it all within 3 days only My ratings and reviews will give you confid More

$155 USD in 3 days
(477 Reviews)
0.0
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. I will focus on user friendly interface. As you can see I have very good rate, you can be sur More

$147 USD in 3 days
(79 Reviews)
0.0