Another way to accomplish this (Don't know if you have the capability) is to connect the OLD production system to a DIFFERENT DOMAIN and ensure that the two are NOT...

Why not just use

SELECT (DATENAME(MONTH, DATE)+', '+ DATENAME(YEAR, DATE)) AS 'MONTH' FROM TABLE

IF the table is 2 columnar and you had something like Field1 = David Field2 = CIO all you would have needed to do is something like:

SELECT ISNULL(Field1, '') + ':...

I hate to say this but Hunh??!?!?!  Are you asking is it possible to restore a VB application with a SQL BACKUP/RESTORE?

I would check the job that drops/re-creates the tables and look at the permssions for the objects that are having the problem.  It looks like your additional permissions was not...

Try checking out SQL Compare.  This software can look at DEV v TEST v Staging v Production tell you the changes and allows you to review them back fill, promote,...

Can you check your gvEmailList and see if this is being populated?  IF this is NULL or NOTHING THEN the RS would be NOTHING as well...

Can you please let us know what SET LINESIZE does so we can say yay/nay about the equivalent?

No.  Using this option transfers the object(s) between server(s) or database(s).  SQL does NOT convert from 1 object type to the other.

Another thing to add to what Remi stated is to CREATE your objects in order i.e.  IF a VIEW depends on a TABLE to exist make sure that the CREATE TABLE...

I would also look at the Server network utility (can be found via Start > Programs > SQL) and see if TCP/IP is enabled or disabled.

If it is disabled move...

Is the database rebuilt nightly?  Any jobs running nightly that affect permissions?  Sounds like there is a script running that re-assigns permissions daily...

What timeframe is expected to report the changes to the table(s)?  If it is "real" time than you will need to have your GUI constantly running "seeing" if there are...

Try using SET DATEFORMAT dmy

The problem you are facing is the REGIONAL settings on your SQL server are probably MM/DD/YYYY and you are passing in DD/MM/YYYY while you know that...

Access inherently "grabs" ALL tables and views that the user has SELECT permission and displays them ALL under the "TABLE" guise....