Macro autoexec and SQL server log in window

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I have an access databse with lined ODBC tables from SQL
server.

I create a autoexec macro in the Access database to run
nightly to do some updates.

But when the database started to run, the sql server log
in window will come out, so it cannot be run
automatically unless someone logs in.I have to use sql
log in not windows authentication, for we are not in a
windows domain.

How can I skip the log in dialogue, and make my
application runs automatically?

Thanks
 
Hi,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
".. have an access databse with lined ODBC tables from SQL server.
I create a autoexec macro in the Access database to run nightly to do some
updates.
But when the database started to run, the sql server log in window will
come out, so it cannot be run
automatically unless someone logs in.I have to use sql log in not windows
authentication, for we are not in a windows domain...."

Take a look at:
ACC2000: Storing SQL Database Login IDs and Passwords Locally
http://support.microsoft.com/default.aspx?scid=kb;en-us;209502


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Thanks, it works.
-----Original Message-----
Hi,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
".. have an access databse with lined ODBC tables from SQL server.
I create a autoexec macro in the Access database to run nightly to do some
updates.
But when the database started to run, the sql server log in window will
come out, so it cannot be run
automatically unless someone logs in.I have to use sql log in not windows
authentication, for we are not in a windows domain...."

Take a look at:
ACC2000: Storing SQL Database Login IDs and Passwords Locally
us;209502


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms0 3-026.asp> and/or
to visit Windows Update at
Click to expand...
 
Back
Top