|
|
Posted by Jim Michaels on 01/23/06 09:47
is MySQL a consideration, if nothing else, for later? it has an
Access-to-MySQL Migration tool you can download, the database is faster and
more flexible (unless you are doing pivots and using plugins).
it would be worth the learning. Actually, both Access and database servers
are used in jobs.
MySQL usually comes with PHP when you purchase web hosting if you get PHP.
MySQL is also free for development use if you are developing things that are
not embedded - you can also use it to learn on.
You can also create your tables, databases, and your data in batch scripts,
and do backups in text-editable format. (or in code)
You can also create views, which are saved queries (similar to what Access
has), stored procedures and functions (Access's macros), SQL2's syntax +
additions.
It can handle more data and more users simultaneously. It has row locking.
or you can lock tables (row locking is better).
there is a longtext type (there are many more useful types), which can
handle as much text as you can throw at it - such as a whole web page.
Access's memo field can't do that.
SQL knows how to do time calculations and other calculations, string
manipulations, and very complex queries (including nested SELECTS).
It also has some special search functions, like MATCH() and FULLTEXT(), some
of which are likely used in search engines.
drawbacks:
you don't get Access's visual relationship diagramming tool.
you don't get reports and forms (you're probably not using those anyway)
higher learning curve (but good knowledge)
if you want to find out more about row locking,
http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html you will see
some code examples and ideas.
There may be a 3rd party DB client that has the relationship diagramming
tool, unless it's patented by MS.
"MrsBean" <linda@burnsidebiz.com> wrote in message
news:1137952986.185748.122670@g49g2000cwa.googlegroups.com...
> I've been working on learning how to use PHP with MS Access, and as
> long as I use ODBC, I can make it work. I want to use a DSNless
> connection. Everthing I have tried has failed. Can anyone show me a
> simple example?
>
> MrsBean
>
Navigation:
[Reply to this message]
|