hi how want to export a query and the name from the query is temp and i want to export it to excel in this location i:\database, and this is my vba code
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "temp", "I:\Importand Database", True
but i get an error message
run time error 3051
The Microsoft Access database engine cannot open or write to the file
'I:\databases. It is already opened exclusively by another
user, or you need permission to view and write its data.
i'm the owner from the computer so it's don't to be any promession problem i have windows 7 ultimate with office 2010