Forums
This topic is locked
UD, Access and MSSQL?!
Posted 08 Feb 2002 14:17:50
1
has voted
08 Feb 2002 14:17:50 chris jones posted:
Hello! I posted this on the ultradev forum, but some of you SQL gurus may know...I have just about got to grips with UD and Access, all I want to know is that if I create a site using UD/Access, how easy it would be to upsize Access to MSSQL? Obviously I would need to upsize the database, but how much of my UD .asp pages code would need changing?
Cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Replies
Replied 08 Feb 2002 14:39:26
08 Feb 2002 14:39:26 Viktor Farcic replied:
It all depends how complicated your Access DB is. It's usually simple and quick process.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello! I posted this on the ultradev forum, but some of you SQL gurus may know...
I have just about got to grips with UD and Access, all I want to know is that if I create a site using UD/Access, how easy it would be to upsize Access to MSSQL? Obviously I would need to upsize the database, but how much of my UD .asp pages code would need changing?
Cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello! I posted this on the ultradev forum, but some of you SQL gurus may know...
I have just about got to grips with UD and Access, all I want to know is that if I create a site using UD/Access, how easy it would be to upsize Access to MSSQL? Obviously I would need to upsize the database, but how much of my UD .asp pages code would need changing?
Cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
Replied 08 Feb 2002 15:13:17
08 Feb 2002 15:13:17 Mark Labordus replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello! I posted this on the ultradev forum, but some of you SQL gurus may know...
I have just about got to grips with UD and Access, all I want to know is that if I create a site using UD/Access, how easy it would be to upsize Access to MSSQL? Obviously I would need to upsize the database, but how much of my UD .asp pages code would need changing?
Cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
That's right, it depends on the complexity of your site.. It's very hard to answer this.
But anyway, if you want to use Access now but think you might upsize in the future, consider searching MSDN for info like this:
msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconBeforeYouUpsizeAccessDatabase.asp
Mark.
Hello! I posted this on the ultradev forum, but some of you SQL gurus may know...
I have just about got to grips with UD and Access, all I want to know is that if I create a site using UD/Access, how easy it would be to upsize Access to MSSQL? Obviously I would need to upsize the database, but how much of my UD .asp pages code would need changing?
Cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
That's right, it depends on the complexity of your site.. It's very hard to answer this.
But anyway, if you want to use Access now but think you might upsize in the future, consider searching MSDN for info like this:
msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconBeforeYouUpsizeAccessDatabase.asp
Mark.