Microsoft Jet Database Error

[Brent E]

Good day,

I am trying to use a macro to export a Query as an Excel Spreadsheet to a
specific web server share on a network.

I am using Windows XP Pro, Access 2003 (11.8204.8221) SP3.

The database is stored for the time being on my hard drive. I also have
create, read, write permissions on my hard drive as well as read and write
access on the server share I am trying to export to.

I am using the TransferSpreadSheet command w/ the following Fields
Transfer Type: Export
SpreadSheet Type: Microsoft Excel 8-10
Table Name: Applicable_To_Dyess
File Name: \\sw.nos.application.com\BMS\Applicable_Dyess.xls
Has field Names: No
Range: Blank

When I try to run the macro, I get the following error:
“The Microsoft jet database engine cannot open the file
\\sw.nos.application.com\BMS\Dyess.xls. Its already opened exclusively by
another user, or need permission to view this data.â€

I get this error regardless if I try to export to my hard drive or network
drive. Also does not seem to matter if the file is already in existence or
not. If I delete the file for fresh export, I get same error.

I have also tried using the drive letter rather than the absolute path.

Any ideas why this may be occurring?

Thanks.

 

[Brent E]

Thanks, Chris.
That fixed the problem.

It's a bad path name. You can only use 1 dot in the entire path, and that
has to be just before the file name extension. IP addresses and domain names
can't be used for the path. Use the server name instead.

\\servername\sharename\Dyess.xls

Chris
Microsoft MVP