export 20+ character query name = error

[mbowler9]

I have a strange problem here. I have an Access app. that exports 50 queries into Excel.

I recently had some problems which I solved that had to do with my linking tables. I reinstalled Access and brought it back up to speed...or so I thought.

Now, when I try to export a query with a name of 20 characters or more, I get the following error:

"Run-Time error 3027. Can't Update. Database or object is read-only."

If the query name is 19 or less characters, there isn't a problem.

I use the following line of code 50 times:

"DoCmd.TransferSpreadsheet acExport, 8, "allmid_TD_LOAD_REPORT_ITO", xlWbkName, True"

I have the same results if I use the "Save As/Export" manual method.

Do you have any suggestions here?

Thanks

 

[mbowler9]

I just did some more testing with some helpful results. It isn't the size of the query name that is choking Access, it is the size of the name of the file you save it as (not including extension).

Hope this helps.

Thanks