Jaunty Edward wrote:
Hi,
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.
Look up the correct OLEDB connection string for your database at
www.connectionstrings.com or www.able-consulting.com/ado_conn.htm. I
recommend avoiding the ODBC examples since the OLEDB Provider for ODBC
(MSDASQL) has been deprecated. This means that if you are currently using a
DSN, you should switch to a DSNless connection string using the OLEDB
Provider for Microsoft Jet.
will I have to change the intire sql commands or its just the database
connection setting.
Start here:
http://www.aspfaq.com/show.asp?id=2214
Your best recourse is to use the Access Query Builder to test your queries.
For one thing, if your queries involve joins of 3 or more tables, you will
find that Jet insists upon the use of parentheses to group those joins. It's
very maddening and the Query Builder allows you to avoid errors.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"