Access 2010 Web Display Form error in Sharepoint 2010

I created an access 2010 form linked to an SQL database that I publish to the sharepoint 2010 site. The form is able to publish but when I launch the form from the sharepoint site I get this message ..."Alert: You have not selected a default Web display form for this database. Click here to learn more." I checked the options and have nothing listed under web display form. What am I missing?
 

Question Info


Last updated February 12, 2018 Views 4,181 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Hi Scott,

 

What happens if you set a default web display form?  I am assuming you are publishing your database to SharePoint as an Access Services web database.  If so, I would be curious how you are publishing it and still maintaining your linked SQL server tables while in the Access web database since you are unable to use linked tables in a published web database.

 

Best Regards,

Nathan Ost

Microsoft Online Community Support

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I do not have an option to set a default web display form -- a pull down list is available and the only choice is "none."

 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Faith,

 

A few questions I have are:

 

+>Do you have any forms in your database?

+>Is the Web Display Form option enabled or is it greyed out?

+>What is the file extension of your database (.accdb or .mdb)?

 

Best Regards,

Nathan O.

Microsoft Online Community Support

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

  • Hi! Yes - I have 3 forms. I created a navigation form, which I have designated as my "Display Form."
  • The "Web Display Form" is enabled--not greyed out.
  • The database extension is .accdb

 

 

 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Are you in a web database or did you create a normal .accdb file?  In addition to this, do you have actual Web Forms created in your database or did you create normal client forms?  Web forms will have a little globe icon next to them in the navigation pane.  In order for the form to show up in the Web Display Form list, it will have to be a web form.

 

Best Regards,

Nathan O.

Microsoft Online Community Support

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I created a normal .accdb file (created the database and then went to "File," "Save & Publish," "Publish to Access Services"). I ran the compatibility checker and then added the URL of my existing Sharepoint site and added a Site Name. I understood this created a subsite and my forms should have been converted to webforms. Looks like that did not happen automatically because there are no globe icons next to them. Can you walk me through that conversion?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Faith,

 

Unfortunately, normal client forms in an .accdb can’t be used on the web.  You need to first create a client web database by opening Access and then under the new database option select “Blank Web Database”.  In this database, you will then need to create your web objects.  Unfortunately, I don’t know of any way to convert a standard client form over to a web client form in a web database.  You most likley will need to recreate them as web forms in the client web database.

 

Best Regards,

Nathan O.

Microsoft Online Community Support

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I was hoping to be able to copy the tables from the Access database to the new web database. However, the tables are "locked." The icon shows a table with a globe at the center. Is there a way to unlock or unassociate the database with the web so I can modify and copy the tables over?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I'm having this exact same issue with the faculty database in Microsoft access. When will this be fixed or updated. this is rediculous. If you have to make the databases from scratch the whole thing is pointless. there has to be a conversion for the templates that were carried over from 2003 Access. Whats the point of being able to publish to my website if the templates in the software arent compatible  with the features of the software. I very dissapointed

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I actually did end out creating a new "blank web database" and was able to import my tables into the new web database. However, I had to create new queries, forms and reports to get them connected to the web (icon has a globe at the center). Now I am having a problem editing/adding to the tables. The normal design view is not available. I was able to add a field (column), but cannot add data to it. Any ideas on how to do that? Any way to get to design view in a web-based table?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.