Cory Posted November 28, 2007 Report Share Posted November 28, 2007 I have several macros that rely on data stored in an Access database. At the moment I export special queries that pump the data into a tab separated values file for ME which is obviously silly because it requires someone to manually jump thru a series of hoops every time something is changed in the Db. This morning I plan on writing a solution but I hope you can give me suggestions. Oh, and I fully accept that the suggestions might not involve ME directly. I have a few thoughts on how to do this so I’ll toss them out here for comment: 1. Read directly from the Db with vb script: Obviously the best method is not to export at all but link to the data. I know VBScript can tap Access databases but this one is secured with a WIF (Workgroup Information File) which requires every user to log in with a password in order to access the Db. Is there a way to use VBScript in this case? 2. Link queries or tables to a text table: I know one can link to text files and they appear as tables in Access but I’ve never experimented with them. Probably will this morning. 3. Export manually using VBA: Might be a simple way to have a user button in the Db GUI where a user can push a button and all would be exported. 4. Export with ME: As a last resort I can make the queries appear, copy them with the clipboard and run with them using ME. Probably the easiest method and I know I can do it quick but… Ick! I know a lot of you do databasey things all the time with ME so I’m hoping that this is not an uncommon problem and I can learn form other’s experience. Thanks! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.