>telephone leads. Now they want to put >the database on a server and have other managers in >the company add/change/delete >leads from its database. The application uses M$ >Access. Should the application be >re-written or are there things i can do to it to make >it work? I'm now using Delphi 7 Pro.
Access is file sharing multi-user DBMS. A major problem with all file sharing databases is that the users all have read-write access to the database file(s). As a result, if any of the machines with access to the files do an invalid or incomplete update of the files, the result is a corrupt database. I read a white paper that Microsoft published which indicated that the maximum number of users for a shared Access database should not exceed 5. I would recommend using a true client-server DBMS. There are very good free DBMS's out there now, like PostgreSQL, Firebird, and MySQL. HTH, Glenn Lawler ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
