Search results

Does anyone know of an inexpensive tool that can be used to combine multiple PDFs into a single PDF through VBA without having Adobe Acrobat?

No, that's not true. The Compact on Close only kicks in when the actual BE file is opened directly, not when it's opened in the background by the front end.

No, the C&R is done at 3 AM when everyone is gone. They only work during the day. I also have code in the front end that triggers an auto-close if the back end has a certain value set (the front end checks for the value once per minute). So, before the C&R is done at 3 AM, I set the autoclose...

No, I'm not the sole user. When I said that I was the only one who touches the tables, I meant in the back end. No one else touches the back end. But there are about 10 users who use the database through a front end file, stored locally on their machines.

Yes, the back end is on a network server. The file is set to compact on close, and it is opened with a command line argument that tells it to automatically close.

Anyone ever have a problem with primary keys disappearing on their own? Every once in a while I look at one of my main tables, and I see that it has no primary key, and all relationships to the primary key are gone. I'm the only one who touches the tables, so it wouldn't have been someone else...