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

Posted by Danieltbt05 on 01/31/06 18:36

Hi, i was wondering how do you create a connection to sql server. I'm a
novice in sql server. Pls advise. Thanks

Daniel

aspsql wrote:
> 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

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