Office 365 Access 32 bit fails to compact a *.mdb database (1 Viewer)

sportsguy

Finance wiz, Access hack
Local time
Today, 09:38
Joined
Dec 28, 2004
Messages
358
not repairing and compacting an Access 2003 *.mdb file, even when mt.

Error message is "Selected collating sequence not supported with the specified file format."

Any suggestions? Registry, retirement, lottery to put me out of my misery?

thanks

sportsguy
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:38
Joined
Oct 29, 2018
Messages
21,457
Can you post a copy of your db here for testing?
 

isladogs

MVP / VIP
Local time
Today, 14:38
Joined
Jan 14, 2017
Messages
18,211
Check the default sort order in Access options. Change to General-Legacy and try compacting again


Sent from my iPhone using Tapatalk
 
Last edited:

Users who are viewing this thread

Top Bottom