You are here: MS Access Frontend for remote sql server « MsSQL Server « IT news, forums, messages
MS Access Frontend for remote sql server

Posted by aspsql on 09/27/79 11:38

I have a website which runs off a Access database which I am currently
converting to sql server database. I would like to still use my access
front end for reporting and queries..
I created an odbc connection on my computer to the remote sql server
and created a link in access to my sql server tables. All my report and
Queries run fine I just have one problem it keeps on prompting me for
ther password of the remote sqlserver database. I check the odbc
connection and I see the password is not saved in there even though I
put it in. Is there a way I can have the password saved. I do not want
keep on having to enter the password.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация