I would really like to know what are some recognised limits of Access 2k databases or better still unofficial limits that are best not to cross where performace/relability may be unreasonably affected etc, does anyone know what they may be? or have experiance of them?
I was thinking in terms of database size, number/size of records, networked users etc but any sort of metric would be very helpfull
I use Access 97, and I want to know if the space limit is 2G or 1G ? It seems to be 1G (and I have a problem with that ). I have to store pictures in my database, that's why I need space.
Then don't store pictures in your database, that should get the db size down. Store a URL to the physical location of the picture instead. Although there are potential pitfalls if someone deletes the picture outside access the performance gains (imho) are significant and worht having.
if you are going to link images rather than embed them, then make sure you specify the location using a full network file specification eg
personally i'd just store the path to the image as a string within Access, place some code to display the picture in an unbound image / picture control in the forms oncurrent event. The only down side is that some else may come along and delete or modify the images and you may end up with an invlaid pointer to the image or an incorrect image.
If you store them within the databae, then you know you are not prone to such errors but you are storing a huge amount of datain the DB, and it will be a struggle to do backups. With a good bit of network design you can reduce the risk of this happening by controlling the permissions on the directory holding the images.