Have you thought about using ltrim to remove leading spaces, if any?

set contact2.uexfield1 = ltrim(contact1.contact)

Or, am I missing something?

Go to Tools/Options and unclick "System Objects" and "Hidden Objects" on the View tab.

If you're not using the username and password for security purposes (if they add their own, it isn't security), but for audit trail purposes, you could just query the machine...

Ritesh,

The best way to add security to an existing database is to set up a BLANK database with security (joined to the appropriate mdw) then to import your objects...

Rich, I agree with Phil.  I'd to a "linked_tables" table too, if it were my application.  But, I don't see any need for an ini file, unless it is for an...

Are you running it as a manual process or as a scheduled job?

I save them as vbscript and then run from within VB6 or Access if I need to recreate a package. (Package/SaveAs/Location = Visual Basic File)

Sure.

The easiest way is to set up the pass-through query then change its SQL and execute it.

If your pass-through is qryPassThrough, then

Function QdEfMe()

Dim qDef As QueryDef

Set qDef = CurrentDb.QueryDefs("qryPassThrough")

qDef.SQL...

You can have a startup form with a space for user name and password, and then on the click event of a button loop through the 10 tables and reconnect...

Are you using ADO or DAO? The article is referring to ADO.  Have you tried

SELECT Nom, Sum(Tarif) AS SumOfTarif

FROM Modale

GROUP BY Nom

ORDER BY Nom;

Thanks,

Have you thought about adding a user ID to the table name and passing the tablename to the report as a parameter?  So Joe would have a table named

Let me rephrase what you said and you tell me if that is correct?

Rephrased:

You have an Access MDB or ADP file on some share.  Possibly the 2003 server.  When opening that...

Hi,

Have you checked your references on the server (from a code window, go to tools/references and look for any missing ones)?  Do you have the correct version of mdac...

A down-and-dirty alternative is to manually set the first cell in that column as text, by adding an alpha character in the front of the contents and then trying again.

To get the user's domain in Access, you use the api calls -- here's what I use, call UserNTDomain() to return the domain.  To try it, just paste this into a...