Create an mdb file. Link your table. Create queries as you want.

.mcxl at end is : Create a column Right([fieldname],5) with criteria ".mcxl "

finding - is : Create a column Instr([fieldname],"-")...

It asks you which instance to apply it to.

Ideally, you should be aiming for SP4.

Don't know about 2000. I think I got confused because i generally use DNS less connections and connect all my tables in code - lots of it.

Try a search on...

There are many ways of attaching tables.

What I meant was that once you've got the tables attached, you don't need the dsn/odc whatever. Using Access 2003, if you hover over...

An ODBC "Connection" is a bit of a misnomer.It is a guide to help you link data. You should be able to link tables using an odc and then use...

I keep saying this is an interface problem.

Quite agree. We have moved a lot of the logic over to SQL Server - lots of multi table table views with limited...

Very possibly. I agree about Access's faults but I haven't the skills to go fully over to .net framework (yet)

What may be obscuring things is the question of signed code...

Yes we have been successful but it took quite a bit of work and forward planning. We knew that we would need to move up to Access 2003 for our...

The security features are accessed through Tools .. Macros.. Security. It is normal therefore to refer to this as  the Macro warning even though it refers to code.

I have...

Thanks immensely!!

Worked a treat. No major hiccups at all.

As to the question of security, I'm not (directly) worried about security for this application. It's more a question of user...

Quite agree. Trouble is the users.  They have enough trouble clicking on a program icon.

Seriously, we are looking a situation in a College where...

>Where is the control?

You do have permissions set on tables and views don't you?

>Where is the accountability?

You do keep an audit log don't you?

>Where is the testing?...

Quite agree.

Absolutely excellent book.

Source code available on line.

Interesting when I did a Google on this I got

http://www.databaseadvisors.com/gazette/sqlexpress.htm

Which relates to Yukon and its lack of support for...

Lovely article.

Two problems I've come across:

1) Nice three table view with calculated fields fully updatable in SQL server - lots of lovely triggers. Put it in an adp - not...

It's still form and subform. Or in this case subform and sub- subform.

The layout is a bit of a problem, but you can do the same thing by adding T2...