Re: MS SQL to MS Access ASP problem

From: CJ Llewellyn (invalid_at_example.con)
Date: 09/04/04 

Date: Sat, 4 Sep 2004 12:49:01 +0100

"Jaunty Edward" <smilesinblues@hotpop.com> wrote in message
news:1ec8978e.0409040206.451ee990@posting.google.com...
> 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.

Relevant Pages

  • MS SQL to MS Access ASP problem
    ... I am sorry to post this msg here but i could not find any group on ... ASP program to work with ms access instead of ms SQL... ... 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 ...
    (comp.lang.php)
  • Re: ASP, looping, and stored procedures.... error 800a0bb9 ...
    ... > page PER loop. ... The looping goes by month from and to dates selected ... > In pure ASP the page takes about 15 seconds. ... > Oh, and by the way, the test box has SQL server and IIS on it. ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL beginner help
    ... statements that are embedded in the code(Sorta like how I can use SQL ... statements to the server)? ... with the Asp code it will decide what how to handle what the user is able ... But I still need some client side execution;/ I think I got a good picture ...
    (microsoft.public.sqlserver)
  • Re: forum erstellen
    ... >> abhängt ob das Forum funktioniert und weniger von den ASP Kenntnissen ... SQL Abfragen. ... mal Beiträge löschen kann, ...
    (microsoft.public.de.inetserver.iis.asp)
  • Re: SQL beginner help
    ... statements that are embedded in the code(Sorta like how I can use SQL ... statements to the server)? ... so its up to the asp front end to manage security(I guess its better ... But I still need some client side execution;/ I think I got a good picture ...
    (microsoft.public.sqlserver)