MS SQL to MS Access ASP problem

[Jaunty Edward]

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

[CJ Llewellyn]

"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.

[steve]

"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