Visual studio 2019 - setup

Question

0.00/5 (No votes)

See more:

Good afternoon,
My apologies if this is the wrong forum to help. If there is a better forum, I would appreciate being redirected.
I am a programmer from decades ago (VMS mainframes & Unix). I am looking to transition a small MS Access database to a Windows Desktop database using Visual Studio Community 2019 written in C++. You ask why - just for something to play and learn with.

I am us using Windows 10 Home version 10.0.18363 (latest)
Laptop - i7 8th Gen, 64bit, 8Gb RAM
I have installed Visual Studio Community 2019, including:
- .NET desktop development
- Desktop development with C++
- Data storage and processing

I am wondering if that is all that is required to replicate my MS Access Database?
A website I was reading made no mention of needing MySQL or similar.

Any guidance or advice will be most welcome.

Thanks

Peter

What I have tried:

Searching on setup resulted in deploying a setup application.
Searching on database focused on database issues

I am looking for the minimum VS Setup to write a small desktop database app in C++

Posted 11-Nov-20 19:43pm

Member 2362679

Updated 11-Nov-20 23:18pm

Add a Solution

3 solutions

Solution 2

This will probably spoil the fun of doing it yourself, but take a look at: microsoft-access-alternatives~symphytum[^]

Posted 11-Nov-20 20:25pm

RickZeeland

Comments

Member 2362679 12-Nov-20 4:59am

Thanks Rick for responding,
I had a quick look, unfortunately I do need a relational database, so will head off down the path of ESE for now.

Solution 3

You would be better using C# as .NET supports OLEDB which allows you to use MSAccess quite easily. I have not tried it with C++ but see Developing Access 2007 Solutions with Native C or C++ | Microsoft Docs[^]. That is written for VS 2007 and the Jet engine, but should be easy to upgrade for VS 2019 and ACE, since the differences are largely transparent.

Posted 11-Nov-20 23:18pm

Richard MacCutchan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rick York · Accepted Answer · 2020-11-11T19:49:00

Solution 1

This series of articles might help : Using C++ to Simplify the Extensible Storage Engine (ESE) API - Part 1[^]

Posted 11-Nov-20 19:49pm

Rick York

Comments

Member 2362679 12-Nov-20 4:58am

Thanks Rick,
Much appreciated. Looks like this will force my brain to work overtime, but looking forward to the challenge.