ah ha! Jens, that's what I said to our Database "guru".

We [will be - on Monday] are using an MS Access front end (ie. The Access database has all the forms and reports) and the data will be stored on a SQL Server.

He told me that each and every machine will require an DSN configured - and I said "you must be ******* joking!".

I thought you could put the "on-the-fly" code into the MS Access database contained within a "Startup" macro.

Is he talking ****?

Lee