Recent content by GordonLeeds

Thanks, Catadmin! It's good to know there's a dedicated MSFT SSIS newsgroup - I'll use that for some other issues that have surfaced recently. As it happens (and I'm sorry I didn't re-post more promptly) I copied my posting to Qantel and it turned out they were JUST about to release a...

Advice from SSIS gurus urgently desired! I'm migrating an existing SQL 2000 Data Mart and its DTS packages to SQL 2005. I'm extracting data from the Qantel manufacturing system, via the Server version of their proprietary ODBC driver, into local SQL 2005 tables. In Windows 2003 I have a...

Well, I finally worked out a better technique, recalling that you could temporarily stop the screen from refreshing: Application.Echo False If Not IsLoaded("Products") Then DoCmd.OpenForm "Products" End If Forms!Products.SetFocus DoCmd.Maximize Application.Echo True But I'd still rather be...

Thanks in advance, if you know how to accomplish this. I recently overhauled my Access 2000 project's menu system and forms. I've made all menus/forms sized for a 1027x768 screen, and I want them to always open maximized. By default Access does NOT open maximized, and the way I'm faking it is...

Here's another wicked OLE detail I need help with. I've got an OLE field in an Access table. Some records have Word docs embedded, others have Excel workbooks. When I inlclude the OLE field in an Access report, it will Zoom to show all of the first page of the Word doc, but you can't use...

Hello OLE gurus, hope you can help me out! I have an Excel workbook embedded in an OLE field. A command button on the form opens the workbook invisibly, creates a new tab, uses a bunch of gnarly vba to populate & format it based on data in the existing tab, and stuffs the workbook back into...

Kyle, your post gave me EXACTLY the help I needed. I've been trying to figure out the details of this procedure since yesterday!

Dear VB gurus, I’m hoping someone can help solve my problem with SendObject, or recommend an alternative method for sending emails. I have built an Access DataMart application to automate custom reporting and run scheduled updates against our enterprise software (Ecometry, running an Image db...

Thanks, Brontosaurus - last night I did finally find an MS article that says exactly that: "Cannot Demote a Backup Domain Controller to Member Server". The workaround is a reinstall. Why this article was SO hard to search for I dunno - I found it using Google, by way of a...

Of course, as soon as I posted the above, I started finding clues... Seems only a Member Server offers the choice of joining to a workgroup instead of a domain! So now my question is, how do I demote an NT4.0 BDC to become a Member Server instead? Thanks! Gordon

Ok, I've hit that pothole Brontosaurus mentionned... Yes, I know it's been a couple of weeks, but my task list is (can anyone relate?) huge and crisis-driven... My problem now is that I can't switch the BDC from its domain membership to our workgroup, which is called (imaginatively) WORKGROUP...

Brontosaurus & NOnoy, Awesome, thanks to both of you for providing me with a clear and thorough road-map!!! I do in fact have an additional BDC on the NT domain, so I'll be able to jump right in and begin the process. If I hit any potholes along the way, I'll be sure to let you know! With...

Dear Brontosaurus, Thank you for asking - the answer is nowhere, yet! The MS knowledge base isn't helping me any. Your question points out to me that I have no idea what I'm doing - I've been assuming there was a way to simply move the server to a new domain, but evidently it's a two-step...

Thanks from me, as well. But I'm not sure the other thread really addresses my question, which centers on how to CHANGE an NT server in Domain1, before or during upgrade to Win2k, to an existing Win2k domain, Domain2000, which already has a primary controller with AD. I've created a machine...

We have an NT 4.0 BDC in one domain, and two Windows 2000 Servers in a new domain. The two domains have a co-trusted relationship. I want to upgrade the BDC to Win2k, moving it into the new domain. If anyone can tell me, step by step, how to accomplish this, I'll be very grateful! Regards...