Welcome to the forums.

You may also like this thread.
IMO, using ADO is better (and easier after a few days) than using data environment. Consider using ADO if it is possible.

Sorry for the CC posts. Couldn't resist.