Administrator
  •  Admin
  • Advanced Member Topic Starter
2012-06-25T14:50:00Z
Move the tables in an Access database to a SharePoint site and link to them

http://office.microsoft.....aspx?pid=CH101741461033 
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
  •  Admin
  • Advanced Member Topic Starter
2012-06-25T14:55:00Z
other limitations with Access database on SharePoint:

-select @@IDENTITY returns Invalid VALUE (during Insert from Outlook to DB)
Workaround:
1.Add a new number column to your table, make it unique so GeniusConnect can use it instead of AutoNumber primary key

2.Change primary key definition in GeniusConnect (Assign Table->Mandatory Keys)

Use this SQL Statement instead of select @@Identity:
select Iif(max(MyCol) is null, 1,max(MyCol) + 1) from MyTable
Set Identity(Auto Increment) to NO!





-ODBC driver returns SQL_ERROR for "Rows affected"
Workaround (from GeniusConnect 5.0.0.9):
New flag "Ignore row(s) affected" in GeniusConnect->Advanced options