MS Access ODBC Compact and Repair - C / C++ / MFC Discussion Boards

Re: How to get the handle of a Popup Menu for a window?

Xiangyang Liu 刘向阳25-Jan-06 13:56

25-Jan-06 13:56

Ryan Binns wrote:
the application takes care of creating and storing it, and just calls TrackPopupMenu() when necessary to display it.

What I want to do is adding some items to the menu, not replacing the menu. The application is not mine, I need to install a hook to get into the application. Currently I am trying other ways.

Thanks.

My articles and software tools

Re: How to get the handle of a Popup Menu for a window?

Hans Ruck24-Jan-06 22:30

Hans Ruck

24-Jan-06 22:30

Xiangyang Liu wrote:
I know the handle of the window

Then you might subclass the window and handle the WM_INITMENUPOPUP and, maybe, WM_RBUTTONUP messages.

"quot capita, tot sententiæ"

rechi+

MRU in a popup submenu

manosza24-Jan-06 9:17

manosza

24-Jan-06 9:17

How can I convert the standard MRU file list in menu File
to a popup submenu in menu File in a MDI application ?

Manosza.

Password protect a document

arnoldkempt24-Jan-06 8:41

arnoldkempt

24-Jan-06 8:41

Hi,
I want to add a password at a document level. I have an MDI app. My idea is to add a password variable, allow the user to create a password and archive it during serialization. Then, whenever the user opens that file, during the onopendocument process, I want to open a modal dialog box, get a password from the user, check it against the one that was saved during serialization and then decide to open the document or not. I tried doing domodal on a dialog box during serialization and during the onopendocument functions in CDocument, but neither would work, it kept throwing exceptions. Also, once I get the password and check it against the saved one, how can I abort the opening of the document? Any ideas on how I can do this? Thanks.

Arnold Kempt

Re: Password protect a document

Maximilien24-Jan-06 8:47

Maximilien

24-Jan-06 8:47

do all of this work before actually loading the file; you can do a lot of things before calling serialization.

you first do a "pre-read" (hidden from the user ) to see if the document is protected, then if it's not protected, you load it, if it's protected, read the password, compare it with the one in the document, if password is ok, read the file.

or simply ask for the password, then call the serialization and check there if the password is valid, and exit from the serialization.

Maximilien Lincourt
Your Head A Splode - Strong Bad

Re: Password protect a document

arnoldkempt25-Jan-06 7:27

arnoldkempt

25-Jan-06 7:27

Great, thanks for the ideas. I realized that I have some code in my main app's file that opens the last open document. It seems this is causing the problem. I'll try to work it out. Thanks for the help.

Re: Password protect a document

sps-itsec4624-Jan-06 12:56

sps-itsec46

24-Jan-06 12:56

Hi Arnold,

checkout the LockNote[^] project at SourceForge. It's open-source and it does exactly what you want to do. So dig into the sources and you'll surely find many answers for your problems.

regards,
mykel

If they give you lined paper, write the other way!

MS Access ODBC Compact and Repair

Anfernius24-Jan-06 6:20

Anfernius

24-Jan-06 6:20

Is it possible using plain C to compact and repair a MS Access Database trough ODBC?

I'm trying the following code, found it in the WEB:

void CompactAndRepairDB ()<br />
{<br />
	RETCODE retcode;<br />
	int     subscrp;<br />
<br />
	CHAR szDriver[]			= "Microsoft Access Driver (*.mdb)";<br />
	CHAR *szAttributes2[]	=<br />
								// Create the original .mdb file.<br />
								{"REPAIR_DB=db.mdb\0\0",<br />
<br />
								// Compact the file onto itself.<br />
								"COMPACT_DB=db.mdb db2.mdb General\0\0"};<br />
<br />
	for (subscrp = 0; subscrp <= ((sizeof szAttributes2 / sizeof(UCHAR *)) - 1); subscrp++)<br />
	{<br />
		retcode = SQLConfigDataSource (NULL, ODBC_ADD_DSN, szDriver, szAttributes2[subscrp]);<br />
		if (retcode != TRUE)<br />
		{<br />
			for(int i=1;i<=8;i++)<br />
			{<br />
				DWORD dwcode = NULL;<br />
				WORD wlen = 0;<br />
				char szerr[SQL_MAX_MESSAGE_LENGTH] = {0};<br />
				if (SQLInstallerError((WORD)i, &dwcode, szerr, SQL_MAX_MESSAGE_LENGTH-1, &wlen) == SQL_SUCCESS)<br />
					printf ("Code: %u %s\n",dwcode,szerr);<br />
			}<br />
		}<br />
	}<br />
}

After creating the new compacted file I copy it over the old file.

Though when I run the compacting program I get the following error:

Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed.

I'm not using an ODBC datasource, only using filenames.

Thanks in advance,

Anfernius

-- modified at 12:21 Tuesday 24th January, 2006

WTF: std::string.find_first_of woes

Sebastian Schneider24-Jan-06 5:25

Sebastian Schneider

24-Jan-06 5:25

Hi guys,

I hope I do not have overlooked something small in my code, or you probably will make fun of me:

I have a function that determines if a critical error has occured in really old code which just returns a list of structs containing error information. Someone already added a std::string containing the error-message to these structs, and I can simply get that one.

I need to ignore a certain error message (which virtually always occurs), so I wrote the following code:

<br />
std::string noRecords = "no records found"; // Dont ask me why, but this message always is wrong.<br />
for (int i = curr.numberOfElements(); i > 0; --i) <br />
   {<br />
      if (std::string::npos != curr.currentElement.info.find_first_of(noRecords))<br />
      {<br />
          return true;<br />
      }<br />
      curr.setToPreviousElement();<br />
   }<br />
return false;<br />
<br />

which is supposed to return true ("a real error occured") if there is any other error than "no records found" and false otherwise (i.e. "just noRecords errors").

As mentioned before, I cannot change the implementation of the errorList. Just ignore the naming, please, as I had to "obfuscate" a little.

Well, the result: obviously "no records found" is a part of "unexpected end of file". Thats what currElement.info (the std::string) contains.

I also tried the following comparisons:
curr.currentElement.info.find_first_of(noRecords) < 0

curr.currentElement.info.find_first_of("no records found") < 0

curr.currentElement.info.find_first_of("no records found") != std::string::npos

but to no avail. I tried over 100 info strings with the above function, it never got inside the conditional.

I HOPE that this is really simple (that means, I messed up somewhere). find_first_of actually IS the string::find_first_of(), I double-checked that.

GNAH.

Cheers,
Sebastian

--
Contra vim mortem non est medicamen in hortem.

-- modified at 11:25 Tuesday 24th January, 2006

Re: WTF: std::string.find_first_of woes

Christian Graus24-Jan-06 14:20

Christian Graus

24-Jan-06 14:20

First of all, this is the wrong approach. You should fix the bug, not hide it.

find_first_of will find the first char in your string which is one of the chars in the string you passed in. I think you want string::find.

Christian Graus - Microsoft MVP - C++

Re: WTF: std::string.find_first_of woes

Sebastian Schneider25-Jan-06 2:07

Sebastian Schneider

25-Jan-06 2:07

First of all, I know, but there is nothing I can do about it.

And, BUMMER, I totally misunderstood the MSDN. Another problem if you're not a native speaker and just "taking a glance" at the docs.

Of course, find() is what I have to use.

Thank you very much, Christian.

Cheers,
Sebastian

--
Contra vim mortem non est medicamen in hortem.

__gc* equivalent in VC++ 2005

madhusri24-Jan-06 4:32

madhusri

24-Jan-06 4:32

I understand that the equivalent for __gc in VC++ 2005 is ref keyword. Similarly can anyone update me on the equivalent for __gc* in VC++ 2005.
Thanks in advance

Thanks and Regards
Madhu

Re: __gc* equivalent in VC++ 2005

toxcct24-Jan-06 4:34

toxcct

24-Jan-06 4:34

this should be asked in the C++/CLI[^] forum, which is dedicated to managed C++...

i'm sure Mr sivakumar will be a good help over there...

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]

Re: __gc* equivalent in VC++ 2005

madhusri24-Jan-06 4:44

madhusri

24-Jan-06 4:44

Thanks for the intimation. I have also posted the message in VC++/CLI forum

Thanks and Regards
Madhu

Re: __gc* equivalent in VC++ 2005

Christian Graus24-Jan-06 14:34

Christian Graus

24-Jan-06 14:34

toxcct wrote:
i'm sure Mr sivakumar will be a good help over there...

LOL - seeing as he's one of only three people worldwide using this stuff ? :P

Christian Graus - Microsoft MVP - C++

Re: __gc* equivalent in VC++ 2005

Ryan Binns24-Jan-06 17:59

Ryan Binns

24-Jan-06 17:59

And me as of the last couple of days, so that makes four Smile | :)

Ryan

"Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"

Hello

nne-vitamin24-Jan-06 4:06

nne-vitamin

24-Jan-06 4:06

Hello,

I created with Visual C++ 2003 - a Beta 2 Version - an dialog based application. I inserted a menu in the Resourccen view.

In VC6 I clicked onto the Dialog, said in proberties dialog "IDR_MENU1". That's all. But here in VC NET how can I connect these both (dialog & menu) ? Because if I run the App I don't see anything.

Thank You for help!

Re: Hello

toxcct24-Jan-06 4:32

toxcct

24-Jan-06 4:32

reach the dialog menu property and simply set it to your menu ID...

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]

Re: Hello

nne-vitamin24-Jan-06 4:42

nne-vitamin

24-Jan-06 4:42

Hello,

I use Vc NET 2003. The way you described is the way by using VC6.0. I already know it. But in VC NET there is no Property of the dialog where I set to the menu ID...

Re: Hello

toxcct24-Jan-06 4:45

toxcct

24-Jan-06 4:45

sure there is one, but it simply have not the same look... it is a docked tabed window, in which the proterties are exposed as an array...

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]

Re: Hello

nne-vitamin24-Jan-06 5:00

nne-vitamin

24-Jan-06 5:00

Yes, right, there is the property window with 6 small buttons and a combobox. In the combobox I select the IDD_MyDlG (Dialog). The 6 small button with names "kategory", "alphabet", "properties", "Messages", "Control-Events", "PropertiesSites"

Only the button "Messages" is enabled, the others are not enabled. If I click the button "Messages" I see a list of:

"WM_ACTIVATE"
"..."
"..."

That's all. I think because of the BETA VERSION of VC NET the game is over here for me?

Re: Hello

toxcct24-Jan-06 5:03

toxcct

24-Jan-06 5:03

did you selected your dialog to enable the other properties ?

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]

Re: Hello

nne-vitamin24-Jan-06 5:12

nne-vitamin

24-Jan-06 5:12

Yes I did. Which other properties did you mean? The list of the "Messages" is very long:

"WM_ACTIVATE"
...
...
...
"WN_WINDOWSPOSCHANGING"
"WM_INICHANGE"

Re: Hello

toxcct24-Jan-06 5:15

toxcct

24-Jan-06 5:15

the windows messages are not what you must look for...

open the dialog box in design editor, then select the dialog, right-click on it, choose Properties, then you should have a property called Menu...

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]

Re: Hello

nne-vitamin24-Jan-06 5:23

nne-vitamin

24-Jan-06 5:23

Yes, I did it. But nothing with "menu". I think the Beta Version doesn't have it!
Or this is the bug, therefor it is a BETA.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.