Thanks PW, I think I have the link set up, and tried a simple SP:

CREATE PROCEDURE [procTest]

AS

SELECT Shift_num

FROM [bell-sql].CabTS.dbo.Shift

GO

The Syntax Check says it's fine, but when I try to...

Thank you Phill, that's what I was after. I was so hung up on SET I forgot about SELECT. I'm fairly experienced in Access & VBA, but just...

Would the import feature in Access be an option here?  I've imported tables from SQL Server that were available via ODBC link.

Thanks, that nailed it.

This is what I ended up with.  It may not all be necessary, but I was trying different things and this finally worked.  I had to move the formatting out...

Thanks to all who answered.  I have it working now.

Paul

Thanks noeld,

Unfortunately, as noted, my fields contain only times, so that doesn't return the correct result.  I'll keep playing with it in the morning.  My brain is fried at this...

Thanks PhilM99,

I'm pretty sure the password is being reset.  I don't actually use another login, I change it back through Enterprise Manager.  I'm in the process of creating other logins,...

Min = 0, Max = 1, Config_value = 0, run_value = 0

So it doesn't look like there are any start up procs?  In the logs during startup I see these. ...

Yes, SP3.  To be honest, I'm more of an Access developer and "all-around" tech person.  I'm not strong in SQL Server's inner workings.  I'm not sure I've "verified" this as the...

Actually the opposite.  Because of a canned program where they hard-coded a blank sa password, ours is blank.  I'm fighting with them to change that, but in the mean time,...