Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Microsoft Access gets "Cannot open Database" when trying to open multiple partitioned table

Posted By connex 7 months ago

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message

"Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file may be corrupt.

I rebuilt the table and used "Integrity Check", but this made no difference. Has anyone ran into this and found a solution?

0 rclowe 7 months ago

I haven't had this issue, but I have always been under the impression that the "Optimize" option in the Rebuild Key File utility can sometimes reduce the file size. I would also look into purging some history first, if that is at all an option.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sevendogzero 7 months ago

Connex, I know you've been here a long time and probably already thought of this. Is it possible the 32/64 bit version of Access is the problem?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 connex 7 months ago in reply to sevendogzero

sevendogzero That's a good question. I'll try to move the backup partitions to where I can try different levels. rclowe I did use "Optimize", but that didn't reduce the size of the file. I did ultimately purge history. I use MS Access a lot in my practice and would like to find the answer to my question.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Microsoft Access gets "Cannot open Database" when trying to open multiple partitioned table

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING