Question Web Compatibility Issues of the table

[kbsudhir]

Hi All,

I want to create a database & publish the same on to the sharepoint 2010. I have five master tables which provides input data for the Main_Table.

List of data is linked to particular columns in Main_Table using a query using the lookup option.

To make all the tables web compatible, I have added Primary Key in all the master tables to make them web compatible.

Now, I have below issues in the Main_Table

1. Table Pursuit_Tracker Column Pursuit_Category Limit To List ACCWeb107019 Property value should be set to 'Yes' to be compatible with the Web.
2. Table Pursuit_Tracker Column Pursuit_Category Data Type ACCWeb102007 Property value is incompatible with the Web.
3. Table Pursuit_Tracker Column Pursuit_Category Row Source ACCWeb107018 The bound column should be set to the Primary Key of the table and it should be the first column to be compatible with the Web
4. Table Pursuit_Tracker Column Pursuit_Category Row Source ACCWeb105011 The lookup row source SQL statement must include the source table primary key field and that field must be the bound column.

[/QUOTE

1. For the first issue, I am using a query to bound the column to list of data. I have selected "List Box" as control type. I am not able to find "Limit to List" property.
2. For the last two issues, I can't bound the column to the primary key as the data required is in the Non-Primary ket column, primary column was created only to make the table web compatible.

:banghead::banghead::banghead:

Please guide me how to solve these issues.

Regards
Sudhir

 

[kbsudhir]

Hi All,

I was able to resolve the above issues by recreating the columns which are bound to the master tables by using "Modify Lookup" feature of Access 2010.

But now, only the below issue with the web compatibility remains.

Property Name: Data Type
Issue Type: Error
Issue Type: ID ACCWeb102007
Description: Property value is incompatible with the Web

But the data type is "Text".

Please guide how to get this fixed.

Regards
Sudhir

 

[kbsudhir]

Hi All,

I was able to resolve the above issues by recreating the columns which are bound to the master tables by using "Modify Lookup" feature of Access 2010.

But now, only the below issue with the web compatibility remains.

Property Name: Data Type
Issue Type: Error
Issue Type ID: ACCWeb102007
Description: Property value is incompatible with the Web

But the data type is "Text".

Please guide how to get this fixed.

Regards
Sudhir

 

[kbsudhir]

I recreated those fields. That solved the issue.