Data won´t load from Access Database

MS Access is alot better than a lot of people give it credit for but as the other guys have pointed out, its not designed for that many records, are you able to run any queries with Access itself?

If switching to one of the fee alternatives is not an option  (Mysql, SQLserver express etc) I would look at exportng the data to a csv and importing from there.

As an aside, you can usually get around the lack of space issue in Access if you create a new table/column rather than try to update existing. In your case you could try creating a new empty table with auto-increment primary key (and other keys if appropriate) then use an append query to add your data. Using the compact database tool also helps if you have a lot of data.