I agree with Rob on making the keys compatible, however, there may already be lots of code generated with the existing keys.  Changing the keys could cause excessive downtime for...

How about:

   table1:  LALA LULU [33q][v0.1]

   table2:  LALA LULU [33q] [v0.1]

t1.key = SubString(t2.key,1,15) + SubString(t2.key,17,6)

Not elegant, but should work.

Pete is absolutely correct... I thought I was dealing with SQL!

After reformatting your query to make it easier to read, it looks fine to me.

SELECT

  js.ID

, js.[Role Type]

, js.Field2

, js.Field3

, js.Field4

, js.Field5

, js.Field6

, js.Field7

, js.Field8

, js.Field9

, js.Field10

, js.Field11

, js.Field12

,...

I'm not an expert, but your code might work better like this:

ALTER Function CalcPercent(@totals as double , @fldValue as double )

RETURNS double AS

Begin

dim @retVal as double

if @totals = 0 then

  ...

Since it's being run in Access, perhaps this will work:

where (ivc.invoicedate between ? and ?)

where (ivc.invoicedate between [LowDate] and [HighDate])

Where the query "should" ask for the low and high dates,...

Perhaps it would be BETTER to rename the OLD server before copying the files to the new server.  Sounds to me like the old server will be out of commission...

All you really need to do is invoke the BCP utility from your SQL server using a complete path like: 

\\server\path\bcp <switches> <files>

Or map a drive to...

The REAL difference is the: nvarchar(40) in the first statement while the second is: varchar(40)

Chances are that Port 1433 is BLOCKED at the router.  If you're using a small router/switch like an SMC, dLink, Siemens, etc., ports are blocked by default from inbound traffic. ...

There's a nifty feature in SQL Server Enterprise Manager where you can right-click on a database object, All Tasks > Generate SQL Script.  Click on the Show All button, then...

You say you can use either IE or WS_FTP to get the file, but can you get it FTPing from the server?  I have seen the "unknown host" error when the...

Have you tried shutting down your SQL Server and ALL instances of MS Access then deleting the appropriate *.LDB files? IF some user had a crash and the *.LDB...

You might want to try using RCP (Remote Copy) for your task. RPC

has the advantage that you don't need to use passwords like you do

with FTP. You also...