Search results for query: *

Nope, the same error identified in earlier versions is displayed: Run-time error 2593: This feature is not available in an MDB

CautionMP; This is a good idea, but the backend database is password protected. How do I include the password in the SQL syntax? When I use the SQL it says invalid password.

I am using one MS Access 2003 as a front end user interface for forms and reports, and another as the back end. This is a user requirement. I cannot use linked tables in the front end, so I am managing all forms through ADO Recordsets and the form recordset properties. I was hoping to do...

The report was created with a wizard, so there is no underlying query. However, here is the structure that is used... Table_1 Table_2 Index_1 Index_2 Text_1 Index_1 Quantity_1 Desc_2 Quantity_2 Select Table_1.Text_1...

I am creating a report based upon two tables with a 1 to many relationship. Both tables have a quantity field that I must aggregate on. However, when I create the query the quantity from the primary table is aggregated for each instance of the child record. This causes a erroneous value in...

Thank you all for your response, and klewis, I agree with you that I need to make microsoft except my solution also. jazgeek and jimwilson, If I understand your suggestions, if I were to simply delete the original transactions (from both IV30100 and IV30300) then the reconcile will update...

We recently had an occurance where a user was posting an Inventory Batch Transaction with about 76 Item Transactions. During the posting, the user's pc lost network connectivity and the transaction hung. So she re-posted it and it processed. However, the hung transaction was in the system...

Thanks for responding. I found a non-official fix for the problem. Within the registry located at HKLM\Software\ODBC\ODBC.INI\ODBC Data Sources the first key is a Default key. I deleted the key, which is not allowed but is does reset something because it allowed my ODBC Manager screen to...

Hope it isn't too late to pick up on this thread... Uncle T, I had also used the Microsoft source code for adding a DSN. However, when I run it on my XP maching the registry settings are added but the DSN doesn't show up in the ODBC Data Source Admin. screen and are not accessible from other...

When using CDO, be aware that it is for client-side only. If this is going to run on ther server then you will want to use something else, like CDONTS. Microsoft has some good help on this at http://msdn.microsoft.com/library/default.asp Select Messaging and Collaboration >>> Collaboration...

OK...so you are saying that the oledb32.dll file is part of the MDAC load (which makes sense) so get rid of them both within the package and handle the MDAC separately. Makes sense since the PDW won't actually run the MDAC if it is part of the install. I tried it my way and a workstation...

The development computer was simply the first test setup, as I assumed it would work. So I need to keep references to ADO and OLEDB as most workstations won't have those components by default. I did find a fix (at least it worked on the development computer). I added the file oledb32r.dll...

dellyjm...I am looking into the Visual Installer now... cclint...MDAC is loaded, I did the test install on the development computer which is running XP. Thanks for responses, keep em coming!

Just a thought, but in the line If myRS.Fields(i).ActualSize > 0 Then imageData() = myRS.Fields(i).GetChunk(myRS.Fields(i).ActualSize) since you redimmed the imageData variable, you need to state which index you are saving it to. i.e. imagedata(1) = .... good luck baugie [cheers]

I am trying to create a quick deployment for my app using the Package and Deployment Wizard (PDW). I am running into a problem with the oledb32.dll files. I get an error that it failed to load resource oledb32r.dll, followed by an error registering the oledb32.dll. The oledb32r.dll is not...

I am not trying to close Great Plains from the VBA code, but from an external application using Visual Basic. I have been using the SendMessage method. However, occassionally I notice that when I try to close GP manually after using this method it will hang. This does not happen often, but...

winthropdc; thanks for the idea. are you running this macro from vba code then? i need to close it from a process externally from Great Plains. I have had the problem of it hanging. I even tried some send keys tricks to try and get the File Menu, but GP wouldn't accept them. My options...

Hello All; I am in the last stage or developing an automated integration system, and have one last hurdle, I hope :) Does anybody have a good method that will automtically close Great Plains? I know the vbScript within Integration Manager doesn't work properly. I have tried using a SendKeys...

This hit the nail on the head!! Thanks

Thanks for the info CID8...You re-affirmed some tidbits of info. that I had found. Does anybody else think it is a joke that Microsoft would not support their own functionality? Cheap old Access can support indexed seek methods, but SQL Server can't! Nice one Bill. Thanks all!