![]() ![]() you can set an external view on text-files and use complex joins between those without any programming. Personally I have used access mainly for ad-hoc querying on txt files and you cannot get it much better than that. It will be interestiing to see how it develops. Particularly when rdbms-parts are moved to server-RDBMSs. ![]() I have seen MS-Access solutions made by groups of people over years that cost-wise can easily clobber much more expensive solutions and handle quite serious amounts of data. The disadvantages are that you cannot separate data-management / DBA tasks off from developers. The advantages are that a not too highly trained employee or group of employees can have very efficient databases with full control. MS is promising to continue supporting it. People are still paying for the old version and there is so much code in it, that will not easily change. SQL-server or other RDBMSs will separate the data / tables from the rest and only allow access and return results without the users touching the original files. The requirment that a user can access the files makes it scary. MS-access databases can be put on a server and then several people sharing the file, but it does mean that one virus can wipe out a lot of work. ![]() SQL RDBMSs are not filebased storage and MS-Acess is not a SQL-DBMS. Spreadsheets are reporting tools with some data-entry and unstructured/un-modelled information. Databases are not spreadsheets.ĭatabases are for data-processing so they can validate input by user A while user B is also inputting data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |