How to set up a database? Help please!

[Mizugori]

Ok at work my boss has a bunch of policy files for customers, and he wants to scan them all and set up a database so he can search for the images by customer name, policy #, email address, etc...

What is the best way to do this? He had suggested Microsoft Access, but I don't know much about that... Is that the best way? If so, how would I set this up? Can anyone help me get started?

Thanks!

 

[Unheard]

Define a bunch. Access has a limitation on the amount of records it can contain in a table. Here is some more information on the limitations of Access. If you are talking less than 1000 records you should be fine, and I would recommend using Access for this project as it would be a perfect fit. If not, you will need to start looking @ something more enterprise level such as MySQL or MS SQL.


Take a look @ this for help with using Access.

 

[KLin]

Originally posted by: Unheard
Define a bunch. Access has a limitation on the amount of records it can contain in a table. Here is some more information on the limitations of Access. If you are talking less than 1000 records you should be fine, and I would recommend using Access for this project as it would be a perfect fit. If not, you will need to start looking @ something more enterprise level such as MySQL or MS SQL.


Take a look @ this for help with using Access.

Access has a file size limitation of 2 gigabytes. There is no limitation in the number of records stored in a particular table.

 

[Evadman]

Originally posted by: KLin
Access has a file size limitation of 2 gigabytes. There is no limitation in the number of records stored in a particular table.

'97 is 1 GB in case anyone cares, thought I haven't tried using Jet 8. As Klin states, there is no limit to record count. Usefulness goes down drastically once you pass about a million, but access can handle it, and a good indexing strategy can solve for it.


Sicne it seels your DB skills are just getting started, I would suggest reading 'database design for mere mortals' as a good place to start.

If you are going to be storing images (like your post implies) you are going to need to read up on BLOBs too. Access doesn't work well with them, but you can either write a translation to put them into a memo field or you can use OLE objects in fields.