I am looking for a way to automatically refresh a linked DBMS table upon opening.
1) I tried to open the DBMS table (actually an Access query) in "live access" mode (by unclicking the "Download data" button on Step 4 of 4 of the Open DBMS Table wizard), but MI complained about not having a single numeric key column (even though I tried including in the query a field called MAPINFO_ID that was an autonumber). 2) I tried putting a "server refresh myQuery" in the myQuery.TAB file, but that didn't seem to have any effect 3) I had limited success by creating a second TAB file (call it myQuery2.TAB), containing the following text: !Table !Version 100 open table "myQuery" server refresh myQuery However, this forces me to open the second table every time, and saving the workspace only saves the 'open table "myQuery"' line. I suppose I could edit all workspaces that I create to either open the myQuery2.TAB file, or insert a server refresh line, but I would like something more foolproof than that. Anyone have any hints on additional things to try? Ways to open an Access query in live access mode? The proper syntax for putting a "server refresh" line in a TAB file? Anything would be appreciated. ------------------------------------------------------------------------ Keith Miller Principal Planner: GIS and Modeling North Jersey Transportation Planning Authority, Inc. One Newark Center, 17th floor Newark, NJ 07102 973-639-8444 [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
