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