Search results

BINGO, It works fine under a different user than Administrator or System. Now how am I suppose to fix that? Access has to be run by the System user. The web server is run as a service under the System user. The web server service is what is running Access. The problem happened when I had to...

I have tried the Detect and Repair and this did not help. I have removed the scanner and that did not help. Any other ideas?

Answer to xBug: I have not tried that yet. I will try it today.

Answer to Joe8915: The 4th pc is a brand new install of xp with Access 2000 on it. I have tried disconnecting them from the network and I still have the problem. I have gone back and reversed any changes that I have made on the three pcs since before they started acting up. The sequence of...

No, I am talking about the Access program by itself, with no tables in it, no linked tables in it, no forms, no queries, no reports, nothing. I was having this problem on an Access db I use, but when troubleshooting it I tried just opening up Access by itself. So I have eliminated any problems...

I am having problems with Access itself opening slowly. I am just opening Access with no objects in it at all, just the program. It use to open quickly. I made some changes to the pc it is on around the time Access started to act up. I have tried to reverse those changes, uninstall new programs...

Any takers?

One more item is that all of this is being done in a Function that is being called from a macro which is being started via the command line. There is no form or report event that is involved.

The report is based on a query and the filter is dynamic. With: DoCmd.OpenReport "reportName", acViewNormal, , "[fieldname]=" & whateverString I change the "whateverString" arg every time it is run. I did get it to work by calling DoCmd.OpenReport with acViewPreview and then calling...

How do you filter a report you use in DoCmd.OutputTo acOutputReport, "reportName", ... I can filter a report in DoCmd.OpenReport DoCmd.OpenReport "reportName", acViewNormal, , "[fieldname]=" & "whatever" The DoCmd.OutputTo doc says that if you leave the Objectname parameter blank it will use...

I see the Split function. I guess I can use it like /cmd "dbName;reportName;printerName" Spit(args, ";")

I looked it up, but how do you pass more than one argument. You mean like: /cmd dbName reportName printerName or /cmd dbName;reportName;printerName

I am currently using Access to print reports from a Java app. I use the command line command to open Access and run a macro that runs some VBA code that prints the report and then close Access. This works great except that I can not pass any custom arguments to Access. I am looking for a way to...