Well, if I remember correctly, about all you'll need to change besides your
connection string and any Access specific functions, is in your sql statements
change # to ' for the dates and % to * for your wildcards.
--- worldsolutionmk <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Heres my problem: We have an ASP application that will probably go
> corporate wide. Our current data is sitting in an MS Access 2000
> database. Were thinking of moving to SQL Server 6.5 or 7.0. Is it
> possible to just use the upsizing wizard that comes along with
> Access to migrate the database to SQL server db? Will my classic
> ASP connection string be the only thing that will have to change?
> Or will I have to make changes also to my SQL statements? If there
> are any other things I should be aware of please let me know,,,, I
> greatly appreciate anyones help! (we might even think of going
> to .NET ... but thats another topic).
>
> Thanks Again,
>
> Moe
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
