I know they ain't the best, but I use MSAccess 2000 Databases for my UltraDEV sites. I know SQL DB's are faster and better, but I just don't have the skills yet for that.

Anyways, I was wondering if someone could explain the difference with UltraDEV between using SQL Databases, and Access. (Security, Programs, Ease of Use, Flexibility, that kinda stuff)

If you know how to work with tables, queries, relationships... migration to SQL Server will be pretty easy. All databases work in, more or less, the same way. Store information in tables, create relationships between them and queries that will display data the way you want. Differences are in names (query in Access is View in SQL Server, Relationships are Diagrams...). You'll find that SQL Server offers lots of additional things comapring it to Access. Most important issue is that SQL is made to work on net, Access isn't. Speed, performance, security... are much better in SQL. To shorten things, if money/server isn't problem, move to SQL as soon as possible. You're life will be made much easier and you're pages will start to "fly".

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I know they ain't the best, but I use MSAccess 2000 Databases for my UltraDEV sites. I know SQL DB's are faster and better, but I just don't have the skills yet for that.

Anyways, I was wondering if someone could explain the difference with UltraDEV between using SQL Databases, and Access. (Security, Programs, Ease of Use, Flexibility, that kinda stuff)
<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

Sweet. That about seals the deal. One thing though.

Can I ask what a relationship is? I've heard a lot about them. TO my knowledge, it's when 1 tables's field relates to another table's field. There's a relationship between them. But what does that mean? If you change 1 tables field that has a relationship to another, will the other be updated as well? (That's be cool!)

One of the things relationships can do is update/delete related records. If, for example, you have 2 related tables, whenever you delete record in one of them, all related records will be deleted.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Sweet. That about seals the deal. One thing though.

Can I ask what a relationship is? I've heard a lot about them. TO my knowledge, it's when 1 tables's field relates to another table's field. There's a relationship between them. But what does that mean? If you change 1 tables field that has a relationship to another, will the other be updated as well? (That's be cool!)
<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