Peter,

That makes sense. Thank you.

Denis

I tried your code on a WinXP 64-bit workstation connected to SQL Server 2008 64-bit. I always get this error:

Cannot bulk load. The file "C:\TestBook.xml" does not exist. at line...

I found some pertinent info by "googling" the web. I found some .NET code that "should" do the trick except for one thing. It's difficult figuring out how the...

Thank you. Changing the function from "integer" to "string" did the trick. At least now I get a "real" error message back. As I suspected, it is a "security" issue....

Thanks for the response but it didn't help any. I've already determined that the error returned is NOT caught by the Try...Catch loop. To confirm again, I did try your...

It's just a block of code using a basic .NET System.IO function that is entered into the "Code" tab of "Report Properties". I am not referencing any assembly. I don't...

1. Create a system "Data Source" using the "ODBC Data Source Administrator" that points to your SQL Server database (e.g., "MySQLDatabase").

2. In SAS, use a "libname" statement to connect SAS to...

I tried your code exactly as written and it worked perfectly. I tried outputting to both a temporary table (as in your original code) and to a "real" table. In...

Yes, I CAN open the Access database that was created on the SQL Server from other computers. The database is OK. It's got to be some sort of security issue...

That did the trick. Thank you.

Dale,

While troubleshooting this, I did see some of the information you provided about some of the incompatibilities between Access 2000/MDAC and SQL Server 2000 (which is what we're running). I'll...

Dale,

No, I'm afraid that article did not help. It's talking about saving "Access objects" and primarily deals with Access databases (not projects). Also. she's using Access 2000 NOT 2002 which...

Dale,

I forgot to answer your other question... No, she is not on a Windows 98 machine. She's running W2K Pro with Office 2000.

Denis W. Repke

Dale,

The "Default Open Mode" setting is ONLY available for Access databases (i.e., MDBs). It is NOT an option for projects (i.e., ADPs) -- the option does not exist under Tools,...

Dale,

Thanks for the reply but I have already made her a "db_owner" and she still cannot make changes to any of the objects. Actually, in taking another look at the...