View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Get data from Access file


"mjones" wrote in message
...

It says 'record(s) cannot be read; no read permission on tProduct.'



....then you likely have some different type of security set up in Access.
I'm not a big Access user, so I can't offer much help there.

You could try some of the other connection string listed here for Access:
http://www.connectionstrings.com/access
Look at the strings for "Microsoft Jet OLE DB 4.0" The one I used was
"With database password".

Tim