On 2/17/07, Shachar Shemesh <[EMAIL PROTECTED]> wrote:
Is it a requirement that it be "Access", or should it be "a database server"?
It has to be Access - it's not only a database, but a whole program written in Access, with at least 50 forms, at least 100 queries and lots of VB code. I wrote it myself. A few users in the office can use it simultaneously, they can update tables, and Access locks and unlocks records and tables automatically. If a table is locked by one user and another user tries to open it, he is denied. There is also a database of tables with many connections, this is in Access and in general it can be any database, but we are happy with access and we don't want to convert. But if we do decide to convert, we will convert only the tables (there are at least 50 of them) and not the entire program. It's very convenient for us that a few people can use the Access program simultaneously, and we don't want to lose this feature. But as I said, the server will also be used for other purposes, such as a mail server. Access requires Windows, and that's one of the reasons we can't convert the entire office to Linux. Each user has Microsoft Access installed on his computer. It's smart on Microsoft side - we pay lots of money to Microsoft. Windows and Microsoft Office for each computer in the office. In theory I would like to convert the entire office to Linux, but in reality I don't see how it will work. I also think most people, who are not computer programmers, prefer Windows. If they just use the computer for typing Word documents or using E-mail, Windows is usually easier to use or at least that's what they're used to. How many companies do you know, which are not computer companies, who use Linux? Uri. ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]