Hi Members!
I have a question about SharePoint. I want to publish a database for various users. If I publish the database, will one of the users be able to: save it on his desktop, make changes in the form so that they are only useful for him and do not affect others?
Example: change the default city name.
And save it in ACCDE format.
Szymon
What does it mean to say "publish" a database? I hope you do not mean what theDBGuy warns against. I hope you don't plan to let multiple users try to
share a single accdb which is stored in a SharePoint location. That is a non-starter. SharePoint is not like a LAN and can't be used in the same way. It would be possible to distribute the Front End accdb to various users by placing a master copy in a SharePoint location for people to download and
use on their own computer. The Back End data, however, can't be shared that way, not safely anyway.
But rather than go on about that aspect, we ought to get the full context here.
Is this Access relational database application split into a Front End with interface objects and a Back End with the tables? If not, that is actually the first step needed. Each user SHOULD get a copy of the Front End (with forms, reports, queries and VBA) on their own computer. Everyone shares the data because it's in a single accdb Back End. But that Back End should NOT be deployed to SharePoint to be used.