pcsoft.us.windevCopyright 2026, PC SOFT11 Nov 2015 14:22:00 Z10 Nov 2015 18:37:00 ZHi All, I am writing an application that will be used on a local area network with multiple users. There will be about 7 files/tables with about 5000 records max in at least 3 tables and the rest will have less than 100 records. I don't want to use a database server at this stage so my choices are limited to either HFSQL Classic or a MS Access database for data storage. Please give me some advice on which would be the better to use from these two options. Speed, reliability and managability are the most important factors to me. Kind Regards Ray30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54909/read.awp11 Nov 2015 14:22:00 ZThanks everyone for your advice. It is pretty clear that the database server route is the best way to go. I will give HyperSQL C…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54909/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54909/read.awp[WD] Data Storage Choiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54900/read.awp11 Nov 2015 06:25:00 ZHi Ray, do not use HF classic 1. in multi users environment 2. transaction, even though in single user and even though it i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54900/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54900/read.awp[WD] Data Storage Choiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54894/read.awp10 Nov 2015 19:11:00 ZHi Raymond, Your question depends on several factors; the obvious ones are "server" spec, number of users, speed of network, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54894/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54894/read.awp[WD] Data Storage Choiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54892/read.awp10 Nov 2015 18:52:00 ZHello Ray Installing HFSQL C/S takes 5 min tops, can be done on ANY of the computers of the network, does not require any mai…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54892/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54890-data-storage-choice-54892/read.awp[WD] Data Storage Choice