I don't usually, but... 10042

rapskat

The Wizard? Access will hold your little uninformed paw and wizardly take you through life, too. The default with the Access table design wizard is also to create a PK.

So, we've established that both OO Base and Access prompt and default for Primary Keys in the same manner, whether you're importing data via the wizard, or building a table by hand or by wizard. And the reason they both default and prompt in the same manner is OO Base is a spastic, totally shameless copy, lamer wannabe of MS Access.

We've also established wizards are your only hope of using database software, and thus we can't offer you employment. When we need someone who can boot Knoppix and use dd we'll get back to you.

Like I said, if you create an OO Base table without a primary key, you can't afterwards add records to that table except via the import wizard. And then you can't delete them. Not that anyone cares; all 3 users of OO Base will be too busy cursing the (cr)app.

It's looking very, very pooty so far. Clunky, slow, and weird is no way to get started. It's nowhere near the db package Access was 10 years ago.

Approach was quick and easy to use, but had nowhere near the programmability and features of Access.

OK.

The problem, clueless wonder, is multiple users opening the same Access form onto the same table(s) from the same .mdb. It's a recipe for corruption. I've seen it happen many times. It's not Windows file locking that's at fault - it's something internal to Access. If Windows file locking was the issue, none of the dozens of multi-user Access systems I've deployed would work.

1) you don't know what you're talking about 2) you don't have any experience using Access 3) splitting the system has worked well for me and millions of other Access developers-systems for years now 4) you're an idiot

I do. Let me check... nope, it's not me.

Like to like, but it doesn't matter which I compare. The Windows version of Slow-O runs faster than the Linux version of Slow-O, but Slow-O for Windows on the 2ghz-1ghz system gets beat by MS Office on the 166mhz-32mb system.

While you're sitting there waiting for Slow-O to load, I'm working. All of a sudden it's the end of the workday, and I've gotten half-an-hour more work accomplished than you. That's why it matters.

MS Office 97 on that old machine runs great (as great as a P166-32mb system can run), is stable and has tons of great features. I developed with it for nearly 4 years.

What has it lost? OO can barely be given away. For all practical purposes, its market share is 0%. MS Office, on the other hand, still rules the land.

I can determine you still have none.