[SOLVED]Access data base 2003 (baby steps)

[What I can do]

OS: win 10
compiler: Lazarus 3.2
 I 'm trying to hit a starting point on a new form with nothing but ODBCConniction1. I have an old data base call 'CarCare.mdb' all I want to accomplish at this point is a successful connection. The Lazarus Access Help documentation sort of helped but I never got past a successful connection. After a week with sore finger, sunken eyes, sore back, I have learned two major things 1 most titles that list Access don't deal with *.mdb and 2 most errors are deep into the code. I just want to get one single successful   ODBCConnection1.Connected := True; to not explode. Then I can deal with DB components, DataSets, DataSorce, and such.

[Handoko]

I haven't tried to connect Access database using Lazarus, not much I can say. But I think this maybe can help you:

https://wiki.freepascal.org/MS_Access

[What I can do]

Thank You, Handoko
I have spent the last three days reading through this but no matter what I could never get a successful connection;
I imbedded my file name and the MS Access driver in the component setting and then tried experimented with the  DSN but no matter what I changed or remarked out, I always got an error.  The errors have been different depending what I changed but regardless of default settings or to cut and cut and paste from others. Still no successful connection.

[What I can do]

I read a brief profile about your goal of creating your own game. I do have a suggestion but it fall in the category of find a need and fill it. A lot of games out there with all kinds of goody's. However I have looked long and hard for many years and have not found a simple car driving simulator, lots of stuff on flying air craft but it would be awesome to any parent to have there teenager new driver to just drive. Must pay attention to signs, lights, direction, slow traffic, fast freeway, and different levels of hazards and random events. The out put score chart could be presented to a parent of sort for a formal proof that at least the new driver has successfully completed different levels. Adapted kits could be foot peddles and instrumentation but the view is locked to the drivers seat, an option could be right, forward, or left view that could be switchable or even projected on a three separate monitors for view point if multilabel video card were present. The controls could be simple USB inputs to mimic mouse, joystick and such. Some like this could extend you ability to capitalize at mutable fronts.
Like ....
Parents would pay for it not a penny pinching kid who just wants the new game
Insurance could give discounts on high score levels
Hardware controllers are simple and cheep to construct, most technology already exist
         just remodel the shape into peddles and steering wheel with USB inputs

any way just throwing that out there

[Handoko]

Interesting. That is a good idea, both entertaining and educating. I saw GCompris, that made thought instead of games that kill monsters, I would make educational games.

I started with making the graphics engine that can run on Windows, Linux and Android. Later, I dropped the Android because it was too challenging to me. The basic graphics features already working good on both Windows and Linux. Unfortunately, I was too busy working on other things, so the game engine development has been temporary halted.

Thank you for your suggestion. It is in my list now.

[Thaddy]

Are you compiling for 32 bit? or 64 bit?
The good news is MS has an odbc driver for 64 bit, (basically the only one)
The bad news is otherwise you are stuck with 32 bit.

[What I can do]

(UPDATE)
I copied the
(File DSN contents)
into notepad and saved to my project folder (MyDSN.dsn)
then created a new application project
dropped  on a TODBCConnection
configured it to use the DSN "MyDSN.dsn'
and by golly it worked or at least for now
all I have to do is get other stuff to see it
I trying after days of frustration and fatigue I just couldn't see the forest for the trees.
[SOLVED] thanks again for every ones help