none
Deleted contents are not being moved away from Access Web database memory. RRS feed

  • Question

  • Hi All.

    I have been asked to build a web database in MS access and am running into lot of problems now.

    1. I used Project web database template by modifying its structures and also deleted few of columns there.Now i am almost at the end of my project completion. When i tried to publish it to the share point, USysapplicationlog table shows me lot of compilation errors(Screenshot attached). But i have deleted those records from my database and i am wondering how do those records not vanish from the memory. I have thoroughly checked that none of the records shown in the 'USysapplicationlog' are present in my existing web database. Could someone help me understand what error am i committing here?

    2. I need to use 2 combo box namely Employee and Month. My web database has data for several employees for last 12 months. So one employee can occur 12 times.. I have been able to use set filter along with set tempvar macro commands to achieve this. However it is not working as i intended. My questions are below. 

    a. I need to show only the unique records taken from my access table in my  Employee Combo box but when i searched the forum i read that DISTINCT and GROUP BY is not supported in access web database. Similarly with Month combo box. It has to show only 12 months. But my table has duplicated records for month column as well.. Please help me how to achieve this.  

    b. Secondly the above one is Month combo box which i can use to filter the respective month data. I also have another combo box namely 'employee'. when i try to filter the Employee using second combo box, the first Month combo box would be unfiltered. What it means I need the data for an employee for the month of Jan but i can use only one combo box at a time. Either one combo box would be unfiltered when i try to use both.

    I greatly appreciate your response on this. 


    Santhosh

    Tuesday, September 8, 2015 11:09 AM

Answers

  • Hi Santhosh,

    For your first issue, if you have removed all of the objects, and still get this issue, I suggest you create a empty web database instead of modify in your “Projects” template.

    For second issue, unique values are supported in Access 2013 web app. But it is built-in function with a button, we could not use the distinct or group by sql statement. It will depends on your fields, if you have two fields, and both of the fields value are the same, then the repeat value will be removed.

    For third issue, I could not reproduce your issue with setting filters on two combobox at client with access web database. Anyway, this function is not supported in web site. If you open the web database in sharepoint, you could not find such filter on the web database. As my above reply suggest, you could use button event to filter the records in web database.
    Here is a simple demo:

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, September 10, 2015 8:06 AM

All replies

  • It appears you're building a new Access/SharePoint application in Access 2010. If that is true, that's a bad idea. MSFT decided they made a mistake with this version, abandoned it, and started over from scratch with A2013. There is no upgrade path; this version is DEAD.

    I recommend you start fresh in A2013.


    -Tom. Microsoft Access MVP

    Tuesday, September 8, 2015 1:46 PM
  • Yes. I am using Access/SharePoint 2010. Thank you for your reply

    Santhosh

    Tuesday, September 8, 2015 1:59 PM
  • Hi Santhosh,

    >> But i have deleted those records from my database and i am wondering how do those records not vanish from the memory.

    Do you mean you delete the records from USysapplicationlog? If so, I am afraid that it would not work, you need to modify your database according the error message in description. After you web database do not have any web compatibility issue, your web database will be published correctly.

    >> when i searched the forum i read that DISTINCT and GROUP BY is not supported in access web database
    Just as you found, we could not use Distinct or group by in Access web database. Unfortunately, there is no better workaround.

    >> What it means I need the data for an employee for the month of Jan but i can use only one combo box at a time. Either one combo box would be unfiltered when i try to use both.

    I am not sure what you mean with this, do you mean that you want to filter records according two comboboxes? If so, I suggest you use a button to filter instead of using event in combobox.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Wednesday, September 9, 2015 6:19 AM
  • I have deleted contents from 'Projects' template web database. when i try to sync to share point  USysapplicationlog table shows that the deleted columns are missing reference. It is completely an new app now and it does not contain any objects that was previously present when i downloaded. 

    Secondly Regrading GROUP BY , I am hoping that feature is available in 2013 version.

     Lastly the Multiple filter combo boxes. What i am trying to achieve here is i have two combo boxes namely Month and Employee. Lets imagine i need a score of an employee for a particular month. I need to apply filter on Month combo box. For example i choose month January from month combo box and in the second combo box i choose an Employee name. What is happening in my case is when i try to select an employee name from Employee combo box filter is applied to Employee combo but my first combo MONTH will lose the filter. I am not able to select values from both filter one after another. 


    Santhosh


    Wednesday, September 9, 2015 10:05 AM
  • Hi Santhosh,

    For your first issue, if you have removed all of the objects, and still get this issue, I suggest you create a empty web database instead of modify in your “Projects” template.

    For second issue, unique values are supported in Access 2013 web app. But it is built-in function with a button, we could not use the distinct or group by sql statement. It will depends on your fields, if you have two fields, and both of the fields value are the same, then the repeat value will be removed.

    For third issue, I could not reproduce your issue with setting filters on two combobox at client with access web database. Anyway, this function is not supported in web site. If you open the web database in sharepoint, you could not find such filter on the web database. As my above reply suggest, you could use button event to filter the records in web database.
    Here is a simple demo:

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, September 10, 2015 8:06 AM
  • Thank you very much Ed. Filter using buttons did work for me. 

    Santhosh

    Tuesday, September 15, 2015 2:45 PM