If the goal is to change the whole string to upper or lower, you would use UCase or LCase in VBA.  (You would not want to use a T-SQL command...

Try this KB site search and see what might help you:

http://www.kbalertz.com/sresults.aspx?sw=sql+server+2000+sp3&st=1

Good luck...

Rich

Once again, Remi is absolutely correct about the timestamps.  In my apps, EVERY table has a timestamp and a single unique primary key.  As you have just proven, ff you...

Settings

The compare argument settings are:

Search for Instr in the VBA help file.  You just need to set the compare option to binary compare.  IIRC, the compare constant is something like acCompareBinary, or something like...

I suspect you had some corruption in a system table, perhaps related to extended properties, or perhaps related to something else that Access writes into the system tables directly.

It's a...

To be a bit simpler about my first suggestion:

Just create a new ADP and connect to your databse.  Then try to open up the problem tables.  If it works in the...

Sounds like your ADP client is corrupted.  There may be properties (such as the ones that control the column widths and orders in the datasheet) that are stored in the ADP itself that...

Without knowing how you are doing the import, it is difficult to respond.  I have 2 thoughts:

1) If you store the date as text in your MDB, you will have...

I just ran a trace to test RecordSourceQualifier.  Looks like it does nothing at all.  And the SQL editor doesn't use it either.  In fact, the SQL editor just deletes...

Also, I was always suspicious of the RecordSourceQualifier property.  I'm still not sure that it really does anything.

The whole issue is strange, since I don't have that problem when I...

"RecordSourceQualifier property doesn't appear on the user machine."

Is it possible that the user is using an older version of Access?  That type of version conflict can be a serious problem.

"the existence of this platform is really suspect in later versions of MS access."

Karim, this is a baseless rumor started by one particular well-known newsgroup poster.  I have not heard...

Remi, That's a very nice piece of code.  Thanks!

Paul, just to add a bit to Remi's comments:

Each Access form has a property called RecordSourceQualifier.  This is the default object...

Remi is correct.  Furthermore, you should never distribute an ADP. In short:

ADP = Source Code

ADE = compiled version for distibution

Forget about the VBA password.  It's a  joke that takes 5...