A
Ajay Deshpande via AccessMonster.com
App xyz is processing system for abc which will run on terminal server. Front end of the system is in Access and back end is Sql Server 2000. Connection to database is maintained using connection string method using sql server driver to maintain one connection for one user (ODBC connection method requires connection for each table for every user).
Issue using Access 2000.
? Values can not be assigned to dropdowns using recordset method.
o To fix this problem ?value list? method can be used which has limitations of 3000 characters. Most of the dropdowns require more that 3000 characters.
? Work around for this limitation is to use lookup screen for these dropdowns. But no of dropdowns is very high ( More than 50).
-- Microsoft has recommended to use Access 2002 or later version to overcome this issue
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=dba9125ccc754d6da077500d8346ddad
*****************************************
Issue using Access 2000.
? Values can not be assigned to dropdowns using recordset method.
o To fix this problem ?value list? method can be used which has limitations of 3000 characters. Most of the dropdowns require more that 3000 characters.
? Work around for this limitation is to use lookup screen for these dropdowns. But no of dropdowns is very high ( More than 50).
-- Microsoft has recommended to use Access 2002 or later version to overcome this issue
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=dba9125ccc754d6da077500d8346ddad
*****************************************