You don't say exactly how you are doing it.

We seem to have horrendous problems because we don't use US as the default format so some of this may be...

You don't say exactly what you want. To use the like  + * syntax, you must be working with character or string fields in Access. I will assume you are.

I...

Point is if you have two tables linked 1 to 1 you need a view and a trigger to do inserts and such. It doesn't work in a project AFAIK....

Hmm.

1. Security. Unless you make a mess of it, then an mdb uses SQL security to access data etc held on a server.

3. Clarity. You should have a clear front...

Watch out for "odd" table / database  names e.g. we name our databases by year e.g. 2005, 2004, 2006 which means you need to put brackets round them.

In general, if...

One incredibly stupid way to do it is to link to the table and simply do

me.Filter = "GMCode Like " & txtbox & "*"

me.FilterOn = True

i.e. do it all...

Add them to a Windows NT / Security group. Add the group as a Login. Assign privileges to the group.

As post 2 says, at the presentation level, don't update.

Using the principle of post 3:

SELECT (CASE where isnull(field,' ') = ' ' THEN 'N/A' ELSE field END) AS NewField

This should...

My immediate though is file locking.

Remember any Access data base in use creates an .ldb to manage file locking. This in turn means that ALL users need read/write access to...

OK I assume you are using an mdb rather than an adp.

Hopefully you do mean form rather than report. You can get a recordset from the server and attach it to...

Even simpler, have a hidden box with data = 1,  called tbSeed and a visible text box tbRowNumber with data set to tbSeed and the Running sum set to over...

Ideally, each user should have their own copy of the Access database. Because the data has to be shared, this in turn means that the data has to be held...

Basically, you create the groups in Active Directory and then add users again in Active Directory.

In SQL server, you need to be a member of sysadmin or security admin or...

Depends on how you're doing it.

If you put your "queries" / Views on SQL server than that's where the security goes. That's the recommended model - all calculation on the...

Very neat!

Nice trick with "*[0-9,-]*"!