[ms office - 2019] Access Database file - 64bit

[newpersn]

Hello,

 

One of our departments uses a Access database - Worked fine for years. This year we have updated our Office to 2019 64bit. (Not by my choice)

 

When we open this database file we get this error. I have seen some bits online but unsure where to add the statements in. Any ideas?

 

[Steve21]

I don’t think you need to add anything in, it’s probably complaining with that line that’s highlighted as Long is 32bit only

 

To make it work with 64bit you’d need to change the

Declare Function

To

Declare PtrSafe Function

To tell it it’s safe to use for 64bit

 

And then depending if you want the longer variable the end “Long” to “LongPtr”

 

Repeat for any other bits it complains about

 

Steve