Hi, I have one mdb file and I want to run it in the run mode without linking tables again and again.
Every time after closing the mdb file ... we are relinking the tables tools->data Base Utiliies->linked table manager..any provison to save Network Library Name,Network address,DSN,Username,Password,DATABAse in the mdb itself or in the form tha will take these inputs and will run automatically and will link the tables. My run mode flow should be like this.. 1.Just double click mdb file 2.Press the button that will run the applicaton(macros and all)... 3. the form which will trigger the code should automaticallly get connected to the tables outside using the default values we give some where(where exactly I am not aware and ..u should suggest me) 4.Pull data from the external tables and 5 keep them in the local tables Most importantly is that..... every time I close and open the application I should not reconnect the "linked table manager...options"... Just the mdb sould run like exe file.portable file Please suggest me .. Any reference material .... thanks and regards Raja ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/