I don't see this one as OT, Anthony....so you guys can continue to discuss this one here Even tho I haven't got a clue what you're talkin about LOL (maybe that's why I don't see it as OT?) Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Colli, Anthony G Sent: Wednesday, September 25, 2002 2:54 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Automation going OT here James- I am interested in your code. I have a SQL server db that gets populated every night with new data. Reports are written off this data, some are daily, most are weekly, others monthly. I usually connect to this db with an .ADP but these don't support autoexec macros, I suppose I could connect with a normal .MDB. Ideally I would like to run the SQL server DTS jobs (over night) and then the reports. Any help/advice is welcome. -Anthony ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************