MS Access is not supported but you can use PHPlens or PHPado to connect to a MS Access database and start building from there. If you set the database to SQL92 then import the tables from MySQL that will give you a jump start. there is nothing that MYSql has that cannot be done in MS access so you are good there.
the only caveat I can think of is that Drupal uses table locking commands. these are not necesssary with MS access.
If you take the database.mysql file and tweak it a bit you should be able to use it.
It may take a bit of work but not an enormous amount to get it working.
--------------------------- www.hivemindz.com (running PHP5) www.fireorb.org (documentation and hacks)
__________________________
Carl McDade
Information Technology Consult
Team Macromedia
I don't recommend doing this at all. I tried out Drupal 4.3 with MS Access and it was slow as hell. Took about 20 seconds for each page to render compared to MySQL on the same box taking less than a second.
You can get more speed by using stored queries. The compounded joins of Drupal slow things down considerably. You can get that time back by placing a number of the heavy queries into an Access stored query.
--------------------------- www.hivemindz.com (running PHP5) www.fireorb.org (documentation and hacks)
__________________________
Carl McDade
Information Technology Consult
Team Macromedia
Comments
No
See Drupal's system requirements.
--
If you have a problem, please search before posting a question.
MS Access is not supported
MS Access is not supported but you can use PHPlens or PHPado to connect to a MS Access database and start building from there. If you set the database to SQL92 then import the tables from MySQL that will give you a jump start. there is nothing that MYSql has that cannot be done in MS access so you are good there.
the only caveat I can think of is that Drupal uses table locking commands. these are not necesssary with MS access.
If you take the database.mysql file and tweak it a bit you should be able to use it.
It may take a bit of work but not an enormous amount to get it working.
---------------------------
www.hivemindz.com (running PHP5)
www.fireorb.org (documentation and hacks)
__________________________
Carl McDade
Information Technology Consult
Team Macromedia
I don't recommend doing this
I don't recommend doing this at all. I tried out Drupal 4.3 with MS Access and it was slow as hell. Took about 20 seconds for each page to render compared to MySQL on the same box taking less than a second.
You can get more speed by
You can get more speed by using stored queries. The compounded joins of Drupal slow things down considerably. You can get that time back by placing a number of the heavy queries into an Access stored query.
---------------------------
www.hivemindz.com (running PHP5)
www.fireorb.org (documentation and hacks)
__________________________
Carl McDade
Information Technology Consult
Team Macromedia