Dag, we've used Access too for various applications over the years, including an Access 2 program that currently runs in 38 hospitals in our state, and an Access 95 (became 97) program that manages the maintenance of our city council's mobile phones and radios assets (over 3000 units). In all, it's not a bad database system in a single-PC or small network environment, particularly the later versions, but you do need to construct it carefully - dragging code over the network is an absolute performance killer! It's good for end-users who want to put small apps together, but we've gained a lot of work from them when they realise they've bitten off more than they can chew!
We've also used the Jet engine in various apps without problems: in one instance the database contains many thousands of records in a complex relational structure, and there were performance issues at first which, like many, were solved as PC's got faster and had more RAM to play with. I don't mind it, in summary - but I wouldn't use it for anything where the number of records got to the million mark or more. Somebody said something about using Auto-number fields - don't,don't,don't,don't,don't,don't,don't,don't!!!! They can fail abysmally, and it takes a bit of time to sort them out hands-on. If you must, write a tiny bit of code to discover the last number used in the table referenced, and add one to it: Public Function GetLastID(strTableName) Dim rsTemp as Recordset set rsTemp = Currentdb.openrecordset(strTableName) rsTemp.Index = "FilmNumber" or whatever the name of the index is rsTemp.MoveLast GetLastID = rsTemp!FilmNumber + 1 or whatever the name of the field required is End Function In the form where you add a record: TextBox(x).value = GetLastId(whatever the table name is) John Coyle Brisbane, Australia ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 5:52 PM Subject: Re: Re: Building a photo database. Any MS Access experts out there? > > Fra: "Doug Franklin" <[EMAIL PROTECTED]> > > > > On Tue, 09 Sep 2003 09:22:49 -0400, Mark Roberts wrote: > > > > > Is there anyone on the list with Access experience who can answer some > > > questions? > > > > There's only one question that matters when Access is involved. And > > the answer is run fast, run far, run until you're foaming at the > > withers, but get away from Access and get a reliable database. > > > > I don't agree, I liked Access, I built and ran a database for a former employer and for small firms and home use it's OK. With some programming experience you can do a lot of things. The only problem we had was that our based was built in Access 2.0, but when Access 97 arrived it turneed out that M$ had left out some code that lost the backwards compatibility.... > > DagT >
