By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,268 Members | 1,262 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,268 IT Pros & Developers. It's quick & easy.

MS SQL to MS Access ASP problem

P: n/a
Hi,
I am sorry to post this msg here but i could not find any group on
ASP. Please forgive me for posting OT msg here but I need to get this
ASP program to work with ms access instead of ms SQL... I have
converted the DB now I just wanted to know should I just change the DB
connection settings or there is more to be seen and taken care of.

will I have to change the intire sql commands or its just the database
connection setting.

Warm Regards
Jaunty Edward
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Jaunty Edward" <sm***********@hotpop.com> wrote in message
news:1e**************************@posting.google.c om...
Hi,
I am sorry to post this msg here but i could not find any group on
ASP. Please forgive me for posting OT msg here but I need to get this
ASP program to work with ms access instead of ms SQL... I have
converted the DB now I just wanted to know should I just change the DB
connection settings or there is more to be seen and taken care of.

will I have to change the intire sql commands or its just the database
connection setting.


In theory, just the connection settings. MS Access & SQL Server should be
very compatible, unless you've been using some of SQL Server's more advanced
features.

Jul 17 '05 #2

P: n/a
"Jaunty Edward" wrote:
Hi,
I am sorry to post this msg here but i could not find any group on
ASP. Please forgive me for posting OT msg here but I need to get this ASP program to work with ms access instead of ms SQL... I have
converted the DB now I just wanted to know should I just change the DB connection settings or there is more to be seen and taken care of.

will I have to change the intire sql commands or its just the database connection setting.

Warm Regards
Jaunty Edward


Go to http://groups.google.com/ and type "asp" in the search box.
You will see archive of a few groups that apply, e.g.
microsoft.public.inetserver.asp.general

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-MS-SQL-M...ict146471.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=490478
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.