VerySimple

I ran into a problem with nText fields when porting a third-party app from MS Access to MS SQL Server. Wherever the existing code tried to get the value of an nText field in the RecordSet object, the return value would be blank.

I searched all over and found a workaround, which I did not like. The work-around suggested by many is that you must specifically select all fields in your SQL query In other words, you can’t do “SELECT * FROM”, you have to do “SELECT field1,field2,field3 FROM”. in addition to that, they say that you have to select the nText field LAST in your query. It has to be the last field in the list. And in addition to that, you have to then read that value from the RecordSet FIRST before accessing any other fields. So, you have to store it in a variable and save it until you need it.

Needless to say, this can be a painful process depending on how crappy the code you’re dealing with. However I found a solution that worked better. by simply changing the RecordSet LockType property to 1 PRIOR to opening the RecordSet, I don’t have this problem at all.

my RS settings that seem to work with nText fields are:

rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1

i set these properties prior to calling rs.Open of course.

best of luck with your code!

If you want to replace the default outlook data file (.pst) with another file, you have to change a few things. You may want to do this if you’re upgrading to a new machine or if (like me) you like to move your datafile to a different location.

To replace the default datafile, do the following:

1. Either create a new data (.pst) file or open your old data file that you want to have as your default. Save it wherever you like. (Use File -> New -> Outlook Data File or File -> Open -> Outlook Data File)

2. Go to Tools -> Email Accounts. Select “View or Change Existing Accounts”

3. On this page, you’ll see a drop-down: “Deliver new e-mail to the following location:” Select the new datafile that you want to use as your default.

4. You’ll be alerted that Outlook must be restarted. Go ahead and close Outlook, then re-open it. Your datafile is now the default delivery location for email. You can right-click the old data file and close it if you like.

5. At this point, everything will work except that your contacts will not show up properly when you click the “To:” button. You need to re-link your contacts folder to the Address Book. If you don’t know how to do this, there’s another post here: [url]http://www.verysimple.com/support/viewtopic.php?t=203[/url]

If you replace your default outlook data file (ie, you move your old file to a new computer or restore a backup) you may not get a list of your contacts when you click the “To” button.

When you click the “To” button in Outlook 2003, it actually displays the Address Book. Back in the day, the Address Book used to be Windows main app for storing contact information and it is shared by various Windows applications. Your Outlook Contacts folder needs to be linked to the Address Book in order for those name to show up when you’re composing messages. You can actually have as many Contacts folders as you like and link them all to the address book.

To link a Contacts folder to the Address Book, click on the “Contacts” navigation item in Outlook. You should see your Contacts folder in the upper-left pane and all of your actual contact records in the right pane.

Right-click on the contacts folder (not the outlook navigation item, but the actual contacts folder) and select “Properties”

On the contacts properties dialog, there is a tab labeled “Outlook Address Book” Click this tab. Here you’ll see a checkbox that is labeled “Show this folder as an e-mail Address Book.” Check this box to link this contacts folder with your Address Book. You can repeat the process for as many Contacts folders as you like.

All of the contact within this folder should now show up when you click the “To” button in an email message.