On Sunday 18 February 2007 01:57, Uri Even-Chen wrote: > 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.
If you don't have the strength, then as was said before, you can use a samba share which looks and works exactly as a windows share (perhaps better). If you want to invest a little time. just write a little script or use a program to convert your tables to mysql or postgresql. Once there, you have to do mostly 3 things: 1) create a table link in access table list to the server table. 2) make sure the syntax of your queries is compatible with mysql/postgresql. 3) the locking mechanism would have to be converted to either a transaction or simply locking again which is specific to each database. As for the dependency on office/windows. You can greatly reduce that by: 1) If you will use a different program than access, you could only buy the lower costing office (IIRC) suite. What is that program that would replace access and run on windows? can't tell you that. You have the one on open office but access is fully mature plus. It would be a tough act to follow but remember that this is a business and not a beauty contest. Also, if you try open office, try it directly with an sql server to avoid the local db bugs it might have because of it's maturity levels. 2) the windows server would be replaced by a linux server. > > 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] -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================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]
