Why wont my publish work?

[fixemup27]

Hey folks, when I publish my form to sharepoint I get the header and footer to display, but the middle contents of the form wont show up. What am I missing? I am on a company network, it allows me to publish, I "enable the contents" and I still dont get any contents shown in the middle of the header and footer. This form does have macro and VBA actions within it. Thanks.

 

[missinglinq]

I've never published like this, but in a normal Access app the situation you describe can only be the result of the Form being Bound, the Record Source being empty or non-accessible and the lack of the ability to add New Records.

The reasons that a Bound Form cannot have New Records added include:

1. AllowAdditions for the Form is set to No
2. The underlying Query the Form is based on is Read Only
3. User doesn't have Read and/or Write Permission for the Folder where the Data resides.
4. Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
5. Form's Recordset Type is set to Snapshot
6. All Controls on the Form being Locked or Locked and Disabled.

To see if #2 is the case, from the Objects Dialog Box go to Queries and click on the Query that your Form is based on to open it. Now try to enter a New Record directly into the Query. If you're unable to do so, this is the cause of your problem.

If your Query is Read Only, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Linq ;0)>