yes everything is working fine..its just that when the macro runs the screen stops where i require to put in the username & pwd for the SQL server...which i want to automate...coz this macro has to be scheduled to run at a time when no one is near the machine (beyond office hours)..TIA...

the SQL Server machine is a separate machine, and MDB file is on a separate one (however both are on the same network)...

I have created a SQL Server Database on one machine on my network, on another machine on the same network I have linked the database using MS Access. I have now created a macro to extract the databases on this machine, now the problem is that whenever I schedule this macro (by creating a batch file), the SQL Server login screen pops up and the macro doesnt advance.
How can I put the username/password automatically so that the macro can run...