Can i link an access database to sharepoint lists and still use Access and it's forms that I created for data entry while the sharepoint list automatically gets updated??
Seems like i have to first export the Access tables into sharepoint lists, and then i have to import the list into a new Access database to create the link where both get updated with new data entry.
The problem is that I have necessary back ends scripts associated with the Access data entry form that does some house keeping during form events.
Can I export the forms from the original Access database into this new Access/Sharepoint linked database and bind them to the appropriate tables import from Sharepoint?
Is this impossible because the scripts are VBA and will only work with an Access database and not an SQL one.
The Sharepoint list created from the Access table is in SQL format. If I import this to Access as a linked table, is this in Access format or SQL?