C'est un message de format MIME en plusieurs parties. Hi, I'm building a MB program that ask the user to enter a land parcel number. Using this string, I'm connecting to an Access database using SERVER LINK TABLE, so my user can see a table with data about this land parcel. Here's the syntax: Drop table Role texte_connection="DSN=MS Access 97 Database;DBQ="+repertoire+"role\"+nom_projet+"_role.mdb" Server Link Table "SELECT * FROM Role WHERE [Role.id_lot]="+"'"+no_lot+"'" using texte_connection into Role File repertoire+"role\Role" ReadOnly Browse * from Role Position (0.0104167,5.34375) Units "in" Width 8.08333 Units "in" Height 0.989583 Units "in" This procedure is used over and over by the user. Problem is: Even though I drop the preceding table, the Access connection is not closed. The program then opens another connection and so on. So, when the maximum number of connection is reached, MapInfo crash. I know that SERVER_DISCONNECT is doing just that, but it needs an integer and all I have is a string expression (texte_connection). How can I get this damn connection number? Thanks in advance for answering, Jeff lepine GIS Specialist, Tecsult inc. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
