I would suggest that instead of individual logins that you create a DOMAIN Group and add that group to the DB access. Then it should work as pass-through authentication.

Check in the EM Security. By any chance does the workstation/client have a login in the server? Did you run a fix on that?

SELECT COL1 AS COLMain, COL1 AS COL2nd

FROM TABLEA

UNION

SELECT COL2 AS COLMain, COL1 AS COL2nd

FROM TABLEA

DECLARE @quarter

declare @sql Varchar(8000)

SET @quarter = 'Q1' + '2004'

SELECT @sql = ('INSERT INTO [dbo].[' + @quarter + '] ' + 'SQL Statement')

EXEC @sql

Note that if the table doesn't exist it...

select convert(datetime,'10/10/2004')

SELECT 'SELECT ' + CHAR(39) + 'TEXT_COLUMN' + CHAR(39) + 
' AS NEW_COL_NAME, * '
+ CHAR(13) + 'INTO [' + TABLE_NAME + '_TEMP] ' 
 + CHAR(13) + 'FROM ['...

There are proprietary fonts out there that can't be used in PDF and other documents unless you pay additional licensing fees. Examples of what i'm talking about are in the...

The problem is that if you aren't filtering for a specific company string and searching for a location.

• Heritage Ltd GA
• Herberts Barber Shop ...

This is one we're setting up now. Its in a module. Its called on form open and automatically builds a System DSN.

Private Const REG_SZ = 1   ...

Or when you link in the table(s) make sure you click the "Save Password" box

SELECT Tbl_A.PK, Tbl_A.BeginDt
FROM Tbl_A
WHERE (((Tbl_A.BeginDt) Between (SELECT Tbl_B.BeginDt FROM Tbl_B) And (SELECT Tbl_B.EndDt FROM Tbl_B)))

But this is assuming there is only one record in TBL_B. If there are more than...

Couple of questions....

Why are you opening this workspace? Set mwspCalc = DBEngine.Workspaces(0)

Why are you opening this database again? Why not just reuse "mdbCalc"?

Set mdbExWk = CurrentDb

Can you modify the SQL...

Copule of questions.

Where are you backing the SQL Server to? Local drives? The LAN? The WAN?

Is BE backing up this server and other server(s) to a local tape unit?

What bandwidth...

SELECT entered, mrocomid, compwksid, company, random, 
location, add1, add2, city, state, zip, confname1, conlname1, 
conphone1, conext1, conemail1
FROM company
WHERE (company = ?) OR
(location = ?) OR
(confname1 = ?)
ORDER BY company, location

Couple...

Have you looked at this KB 283696: Job to Monitor SQL Server 2000 Performance and Activity article?