cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mcraine15 Frequent Visitor
Frequent Visitor

Trouble with MS Access Large Number Format

Hi,

I'm having trouble accessing a relatively large dataset (~1.5GB) stored in Microsoft Access 2016 with several fields (~30) formatted as Large Numbers. The error message I receive when attempting to access the database is "The database you are trying to open requires a newer version of Microsoft Access." I do not receive this message with databases that do not contain Large Number formatted fields.

 

I'm running the latest versions of Power BI (January update), MS Access (version 16.0.8xxx) and MS Access database engine 2016. All of this runs at 32 bit. 

 

Can anyone provide a workaround or solution to avoid this error message? Solutions I've tried include:

 

  1. Changing field type from Large Numbers to just "Numbers": won't work because it deletes or cuts off certain key datapoints.
  2. Updating computer, office software and power bi: as mentioned, I have updated all software to latest versions available

Thanks in advance for the help!

2 REPLIES 2
mcraine15 Frequent Visitor
Frequent Visitor

Microsoft Access Large Number Format

Hi,

I'm having trouble accessing a relatively large dataset (~1.5GB) stored in Microsoft Access 2016 with several fields (~30) formatted as Large Numbers. The error message I receive when attempting to access the database is "The database you are trying to open requires a newer version of Microsoft Access." I do not receive this message with databases that do not contain Large Number formatted fields.

 

I'm running the latest versions of Power BI (January update), MS Access (version 16.0.8xxx) and MS Access database engine 2016. All of this runs at 32 bit. 

 

Can anyone provide a workaround or solution to avoid this error message? Solutions I've tried include:

 

  1. Changing field type from Large Numbers to just "Numbers": won't work because it deletes or cuts off certain key datapoints.
  2. Updating computer, office software and power bi: as mentioned, I have updated all software to latest versions available

Thanks in advance for the help!

 

 

 

v-xjiin-msft Super Contributor
Super Contributor

Re: Trouble with MS Access Large Number Format

@mcraine15

 

I can repro your issue as creating a MS Access table which is containing a large number field. When use it as a data source in Power BI. I got the same error. And my environment is same as yours.

 

11.PNG22.PNG

It seems like this is a limitation for Access Database.

 

Thanks,
Xi Jin.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)