Mitch, A .BDS file is structured exactly like an INI file, I confirmed that this code
http://vbadud.blogspot.com/2008/11/how-to-read-and-write-configuration.h tml works perfectly for reading and modifying values- obviously before you open the file! Here I used that glob of code for a purpose- look at the value of directupdate / change the value Sub test() Debug.Print GetSectionEntry("General", "directupdate", "c:\Charge Codes.xls.bds") WritePrivateProfileString "General", "directupdate", "false", "c:\Charge Codes.xls.bds" End Sub Once the file is open, you can use D.Rename to rename fields -but that's it - I can see how access to the other stuff could be problematical since access the DataStation's access to the .BDS really is after the D.open command . T Thom C. Blackwell Vice President, Technical Services Boston Software Systems (866) 653-5105 ex 807 <http://twitter.com/thomcblackwell> @ThomCBlackwell www.bostonsoftwaresystems.com Learn about what we do <http://www.youtube.com/watch?v=Fbjk_4LUZYU> Please follow us on Facebook <http://www.facebook.com/pages/Boston-Software-Systems/122739774403349?> and Twitter! <http://twitter.com/Bossoft> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Wednesday, April 18, 2012 11:10 AM To: Talk Subject: [talkbws] Programmatic way to modify .bds? Is there a programmatic way to alter variables within a .bds after (or even prior) to opening a datasource? For example, change "workstation=1" to "workstation=4", or toggle "directupdate", etc. Thank you, Mitch Lawrence D(58)_D(41)^! Report Writer III (Lead Technical Analyst) Enterprise Data Standards - NPR/Automation CHRISTUS Information Management : [email protected] : Mitch Lawrence <http://www.facebook.com/Mitchell.D.Lawrence> : Mitchell Lawrence <http://www.linkedin.com/pub/mitch-lawrence/a/9aa/528> --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx CONFIDENTIALITY NOTICE: Confidential information, such as identifiable patient health information or business information, is subject to protection under state and federal law. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
<<image005.png>>
<<image006.jpg>>
<<image007.jpg>>
<<image008.jpg>>
<<image009.png>>
