Recent content by ttyppi

Thank you jgoodman00! (Those are just the facts I was afraid to hear ;) ) So I added an autonumber field and made the column so narrow, it won't disturb the poor user :) ---------------------------------------- The above worked on some tables, but there were other tables, where personID-column...

Yes, but that is just what I don't want to do. But I am sure it is the only way to get MSaccess working. In similar cases I usually make a special id-field for keyvalues, which is not shown to the user. But this time the customer does not want any programs or forms, just the tables. She is...

I have the same problem: when a table is open, there is no empty line for adding new lines. And I cannot update existing lines (imported from text file). Can anybody help? I suspect that there is nothing one can do to this, except programming own forms or something ...

Thank you PETE314 and wmikeh! Last night finally emailed the offer to the customer, hope to start this project next month, supposedly with ADP. Tarmo

Thank you cjowsey! It really sounds that ADP is the best for this customer. The reason for paradox corruption is unknown. Earlier they had all data in one single table. Now the data will be spread in a more planned way over several tables (for example patient and research result). So before...

Thank you for the answer Daniel! I was thinking too that MSDE (now called SQL Server 2000 Desktop) would be the best solution, customer has had enough db corruption problems with paradox :) The size of database is rather small (less than 10000 rows in the largest table), so the speed might not...

Hi, am a newbie to MS Access, but I have many years of experience on other databases. ------- The situation: Customer wants a small db-system to be used in LAN. They had an old single user system based on paradox. The new system would be used by about 5 persons. ------- I am considering between...