|
|
Posted by MrsBean on 01/23/06 15:45
I am an Access developer. I have a customer who was interested in
developing a PHP interface to their Access database on an intranet.
This is more of a learning experience than anything. Thanks everyone
for your input. I guess we'll just use DSN.
Linda
Jim Michaels wrote:
> 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]
|