Edit ACCESS file in Visual C++

[sunnyyang]

Hi,

I am fresh to Visual C++.

Visual C++ 6, does it support editing to ACCESS file? And if the answer is yes, what is the lowest version it supports?

If you don't mind, who can tell me the major difference between Visual C++ and C#?


Thank you in advance.


Regards
Yang Guang

[zerver]

Hi!

Yes, MSVS 6 supports MS Access databases. You can use Access 97 and Access 2000. Access 2000 requires the setting AfxGetModuleState()->m_dwVersion = 0x0601;

C# is a managed programming language that is part of the .NET framework. If you want to write managed code, it is the language recommended by most developers. C# has nothing to do with regular C++, but there is a managed language similar to C++ called C++/CLI.
http://en.wikipedia.org/wiki/C%2B%2B/CLI
http://en.wikipedia.org/wiki/.NET_Framework

[sunnyyang]

Thank you.

[sunnyyang]

Hi!

Yes, MSVS 6 supports MS Access databases. You can use Access 97 and Access 2000. Access 2000 requires the setting AfxGetModuleState()->m_dwVersion = 0x0601;

C# is a managed programming language that is part of the .NET framework. If you want to write managed code, it is the language recommended by most developers. C# has nothing to do with regular C++, but there is a managed language similar to C++ called C++/CLI.
http://en.wikipedia.org/wiki/C%2B%2B/CLI
http://en.wikipedia.org/wiki/.NET_Framework

Since then I may have to change my plan, my ACCESS file is generated on Office 2003. My OS is Windows 2000 professional, so Visual Studio 2005 may be a good choice.

Is it a good idea to code a pure database application with VC++?

Microsoft web site declares Web Developer fully supports C#, how should I understand it? Does it mean C# code can be smoothly compiled on WD?

If I had mastered C#, would I be able to program with C++?


Thank you.

[zerver]

Since then I may have to change my plan, my ACCESS file is generated on Office 2003. My OS is Windows 2000 professional, so Visual Studio 2005 may be a good choice.

I believe the file format for Access 2003 is the same as Access 2000.

Is it a good idea to code a pure database application with VC++?

Yes, C++ is good for coding database apps. Writing in C# may be slightly less work but the difference is small.

Microsoft web site declares Web Developer fully supports C#, how should I understand it? Does it mean C# code can be smoothly compiled on WD?

Sorry, I don't know about WD.

If I had mastered C#, would I be able to program with C++?

No, it is a different language. C# is managed, which makes it easier to understand for noobs. However, knowing ANY language means you will learn another language much quicker.

[sunnyyang]

Ok, I see....

Thank you.

[sunnyyang]

I am suing VC++ 6.

Trying to access a column (date format) with MFC.

//DDX_Text(pDX,IDC_BODDisp, m_pSet -> m_column4);

m_column4 is refering to a date column.

It does not work.

[zerver]

Hi!

If your data type is COleDateTime, convert date to text using

CString DateAsString = m_pSet->m_column4.Format("%Y-%m-%d");

Regards / Z