Recent content by DataMiner

I've created a separate thread under "repair/compact seems not to be working in Access 2007", which I believe I've confirmed to be the problem here. See the new thread for more info.

The Repair/Compact feature appears not to be working in my Access 2007 databases. It looks like it's doing something, but my ballooning file sizes don't get any smaller. This is true when I run it from manage - compact and repair database AND when I turn on "compact on close". Some examples...

Either i don't understand the answer or it doesn't help. My bloating is occuring in frontends. I do a fair amount of "refreshing" tables, by which I mean deleting all the records in the table and then re-appending. But the tables are all backend, mostly in SQL server. The data stored in the...

Just wanted to update you all on this. Even though Citrix has 3 different versions of Excel installed, and even though I was licensed for Excel XP, and even though I added the Excel XP reference to Access (both before and during runtime...no matter what I did, Access 2007 insisted on trying to...

I need to be able to print multiple copies of a report from Access 2007 in an Access Runtime environment. The only way that I know of to print multiple copies is to use Docmd.printout. In a full-access environment, this works fine. But in the runtime environment, I get "the command Printout is...

I am having problems getting my report to always print to the correct printer bin(which contains special paper), so i thought i would give the PrinterCapabilities class from Getz et al "access 2002 developers handbook" a try. It looks so hopeful, but.... when I look at form frmdevcaps for my...

ok, i figured it out. contrary to what on-line help seems to say, the filter should be status<>'obsolete' NOT "status<>'obsolete'"

thanks, i've changed my code to: the msgbox indicates that the filter has been applied, but the data doesn't. the filter looks like this: but here's a sample of the output:

Hi, I have a checkbox on parent form ProductInfoMaster, and would like its after-update event to change the filteron property on subform ProductInfoSub. here's my code: but at the filteron step, i get error "object doesn't support this property or method". What am i doing wrong? I also tried...

No. anyway, no changes to the db from it's access 2002version, other than the 2007 conversion. and i did not have this ballooning issue in 2002.

I've recently completed converting all my db's to access 2007. now i'm noticing seriously ballooning file sizes, even though i've got compact/repair on close turned on. all of my db's are split into fe's and be's, and it's the fe's that are ballooning (be's are all on sql server). I distribute...

The following piece of code runs on an on_close event of a form in my db, when the db itself closes. I get the message box saying "removing reference to " and the path to excel I get the message box saying "reference removed". But the reference does not get removed. When I reopen the db, it's...

Yes. BUT...the start menu shows Excel 2003, Excel 2007, and Excel XP. If I try to oepn anything but the XP version I get "windows cannot acceess"..."you may not have the appropriate permissions"... So, I have this foggy theory that Access is trying to open one of those versions that I don't...

I am getting the error "Runtime Error 70: permission denied" when trying to execute the following line of code: We are in the process of converting to a new version of Citrix. The error occurs ONLY when running on a terminal server on the new version of Citrix. On our current (old) version of...

Since I need to use command line variables (like \exe), my shortcut paths must contain the msaccess.exe path. But it varies in different environments, and this is NOT under my control. For example, on our citrix servers, the path starts with c:\program files (x86)\MS Office whereas on most PC's...