I am working on linking a table in Access to a Sharepoint List. Deep within the bowels of access(!) I found the Macro action, "TransferDatabase".
Here are the Action Arguments:
Transfer Type: Link
Database Type: WSS
Database Name: http://gaisvr1/Team1;LIST=INS1;View=All
Object Type: Table
Here's the problem: Even though all these "arguments" appear to be correct, I get an error "The Microsoft Jet database could not find the object 'INSTemp'. Makes sure the object exists and that you spell its name and path correctly."
The INSTemp table DOES exist, and IS spelled correctly.
Any help would be appreciated! Thanks-