If I am linking my database to SharePoint for other users to be able to use it, do I need to split the database or just create an encrypted version? If I need to split it, do I split it first then link to SharePoint? Or do I link to SharePoint first then split it?
I have a database I want to distribute. I watched the seminar on how to host it in SharePoint. My database has log in security. Do I need to upload the log in form, main menu form, etc. to SharePoint in order for it all to work for the person who is using an ACCBDE?
No. Sharepoint only holds your tables. Your ACCDE file will contain all of your forms.
Sharon Esdaille 6 months ago
Thank you. Final follow up question - I exported a table that had a calculated field to SharePoint. Now that field shows as #null in SharePoint. Is there a problem with exporting tables that have calculated fields?
That shouldn't be a problem. Once you have them set up as linked tables in Access, they should work fine joined together in a query. You lose referential integrity, meaning Access can't cascade update or delete, but you lose that with ANY linked tables.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.