please visted this site for xoops2 module
http://www.gererstorfer.net/

hi,
(1)installed odbc layer, modified mainfile.php
(2)export MySQL tables into Microsoft Access 2000( xoops.mdb)
(3)created data source name xoops_access
(4)http://XXXX/xoops, i got a lot of error messages..

any body can help me!
Thanks
best regards
frank

Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\twxoops203_20030626\html\kernel\session.php on line 102

Notice: Undefined variable: rs_assoc in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 127

Warning: SQL error: [Microsoft][ODBC Microsoft Access driver ] query expression 'b.bid=m.block_id LEFT JOIN xoops_group_permission l ON l.gperm_itemid=b.bid' systax error (no operand)。, SQL state 37000 in SQLExecDirect in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 232

Warning: odbc_fetch_into(): supplied argument is not a valid ODBC result resource in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 121

Warning: Invalid argument supplied for foreach() in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 123

Notice: Undefined variable: rs_assoc in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 127