This is another script that I am converting from an older version of kixtart to run on a windows 2008 server with version 4.63.
I am sure my problem is that I don't know how to identify the new version. Also, I am wondering if I should update the .mdb to a .accdb.
The following is the code I am working on updating.

 Code:
Dim $accessApp

If Exist ("c:\cognos\data\update.csv")
	$accessApp = CreateObject("Access.Application")
;	$accessApp.visible = 1
	$accessApp.OpenCurrentDatabase("C:\AccessDatabase\list.mdb")
	$accessApp.DoCmd.RunMacro("import")
;     Del "c:\cognos\data\update.csv"


$rc = SetOption("NoMacrosInStrings","On")
$rc = SetOption("NoVarsInStrings","On")
	$Root = CreateObject("Outlook.Application")
	$Session = $Root.GetNamespace("MAPI")
	$DefaultProfile = Outlook
	$Session.Logon($DefaultProfile)	
	$Folder = $Session.GetDefaultFolder(olFolderInbox)
	$Folder.Display

			$MailItem = $Root.CreateItem(0)
? "Root Creation: "+@Error
			$MailItem.Importance = 1
			$MailItem.Subject = "list Updated successfully!!!!."
			$MailItem.Sender = "sender@xxxplace.org"
			$MailItem.To = "receiver@xxxplace.org"
			$MailItem.Body = "list Updated successfully!!!!."
			$MailItem.Send
endif


The email portion works great!

Edited by Karon (2016-04-19 11:04 PM)