Microsoft Access and Radio DJ Database

[PROducer]

I'm trying to link MS Access to my Radio DJ Database using an ODBC connection, but having a couple of issues.  All the tables seem to link properly, except for two fields... 'listeners' in the history table, and count_played in the songs table.  Looking at the DB in Heidi SQL, I see both are of the datatype MEDIUMINT and have a length of 9.

If I try to open either table in Datasheet view in Access, I get an error: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.  Also, all fields in the table show #Error

Strange, since I'm not trying to paste or insert anything.  Anyway, if I create a query which does not include either of the offending fields, I can see the data.

What I'm wondering is if anyone on here knows of a solution to this problem?  I wonder that since it seems to be an issue with datatype MEDIUMINT if in Heidi SQL, there was a way to change those fields to a datatype MS Access can handle without error or wrecking the RDJ Database?

[stevewa]

Interesting, can you elaborate on why you want to do this?

[PROducer]

Well, I fixed the issue by changing the fields to INTEGER.  *NOTE* I'm not working on my station's db... I created a test one for this.

Interesting, can you elaborate on why you want to do this?

I could, but I won't.   

It's an idea that popped into my head that will probably take me a very long time and a lot of hard work to find out it's impossible to complete. 

Or it'll work and I'll share then. 

[stevewa]

I'm just wondering why, because it seems like you're going backwards. MariaDB would supersede Access by a million miles.

[PROducer]

...which is great if you've got a programming background, etc.

This is going to be a utility to help with the day to day with my station.

[MisterMom]

I may be overstepping my bounds of knowledge here and if I am then I apologize.  But is RDJ not programmed around sql ? and Access is a relational database so i don't know how it could work, but I think it would be cool as I am a user of Access.

[PROducer]

Access can also connect to other databases (MySQL, MARIA, etc.) through ODBC.

[MisterMom]

Access can also connect to other databases (MySQL, MARIA, etc.) through ODBC.

Oh OK I did not know that.
In the words of Benny Hill "always learning"

[PROducer]