Programming Help

Web Development



What's Here?

  • Members: 149,951
  • Replies: 507,389
  • Topics: 79,979
  • Snippets: 2,668
  • Tutorials: 705
  • Total Online: 1,330
  • Members: 80
  • Guests: 1,250

Welcome to Dream.In.Code
Become an Expert!

Join 149,951 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,330 people online right now. Registration is fast and FREE... Join Now!




Access And Php

2 Pages V  1 2 >  
 Reply to this topicStart new topic

Access And Php
The Neoracle
17 Jun, 2002 - 12:34 PM
Post #1

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
Ok, do I have to create tables using the actual access program? Or can I run an SQL command via ODBC with CREATE TABLE in it?
User is offlineProfile CardPM
+Quote Post

shrikie
RE: Access And Php
17 Jun, 2002 - 12:57 PM
Post #2

New D.I.C Head
*

Joined: 30 May, 2002
Posts: 13
try this : http://www.webattack.com/get/accesstomysql.shtml

might be less hassle
User is offlineProfile CardPM
+Quote Post

The Neoracle
RE: Access And Php
17 Jun, 2002 - 01:01 PM
Post #3

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
Unfortunately I HAVE to use an AccessDB.
User is offlineProfile CardPM
+Quote Post

Cookie Mobster
RE: Access And Php
17 Jun, 2002 - 01:06 PM
Post #4

nooneenooneenooonee
Group Icon

Joined: 12 Oct, 2001
Posts: 4,723



Thanked: 1 times
Dream Kudos: 18
My Contributions
I should think that you would be able to, I have never used access myself but with oracle and sql server you can do that throught the ODBC using the c++ API, so I'd assume that php would work as well.

Cheers Sam
User is offlineProfile CardPM
+Quote Post

The Neoracle
RE: Access And Php
17 Jun, 2002 - 01:58 PM
Post #5

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
Shibby.
User is offlineProfile CardPM
+Quote Post

RE: Access And Php
17 Jun, 2002 - 03:44 PM
Post #6




Joined: --
Posts: 0
why do you have to run an access DB? Why would you want to do it in PHP? You need NT to run access so you might as well do it in .asp

Hoopster
User is offlinePM
+Quote Post

LammaDog
RE: Access And Php
17 Jun, 2002 - 03:49 PM
Post #7

D.I.C Head
**

Joined: 30 Sep, 2001
Posts: 114
if your using the accessDB, why don't you just use M$ Access to create your tables
User is offlineProfile CardPM
+Quote Post

The Neoracle
RE: Access And Php
17 Jun, 2002 - 04:26 PM
Post #8

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
1. I don't know asp nor is this job worth me learning anything MS has to offer. The server is an NT but he has PHP loaded.
2. I don't have Access or I would. Why, do you have access? wink2.gif
User is offlineProfile CardPM
+Quote Post

peedu
RE: Access And Php
17 Jun, 2002 - 10:44 PM
Post #9

New D.I.C Head
*

Joined: 17 Jun, 2002
Posts: 18
Persuade the client to install MySQL on his NT server. no hassle with odbc and such when creating web solutions...

:-)

If problems arise, exoprt sql data from access and get it into MySQL and still use php-mysql combo smile.gif
User is offlineProfile CardPM
+Quote Post

The Neoracle
RE: Access And Php
18 Jun, 2002 - 06:28 AM
Post #10

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
QUOTE(peedu @ Jun 18 2002, 03:44 AM)
Persuade the client to install MySQL on his NT server. no hassle with odbc and such when creating web solutions...

:-)

If problems arise, exoprt sql data from access and get it into MySQL and still use php-mysql combo smile.gif

No, no, you guys aren't following me here. He will not install 2 db servers on one system. It's got tons of accounts on it, I'm sure it can't handle all those programs going at once. I'm trying to get the guy I'm working for to just co-locate a server there though (he has like 30 clients). If that happens I'll have mysql but for now it's odbc all the way.
User is offlineProfile CardPM
+Quote Post

RE: Access And Php
18 Jun, 2002 - 06:38 AM
Post #11




Joined: --
Posts: 0
I have never connected to an access DB with PHP but it can be done. If you don't have access how are you going to run an access DB? The DB doesn't exist on the server until you create it, it's not like MySQL you need to actually create an access DB and upload it to the server (or at least that is how I have always done it). When I worked for Intel the server was local and I could use the access DB through the network or connect to it through the intranet via asp, but I never heard of anyone who was creating the tables on the fly.

I'll call someone I used to work with and ask him, if it's possible.

H
User is offlinePM
+Quote Post

The Neoracle
RE: Access And Php
18 Jun, 2002 - 06:45 AM
Post #12

Check, check, 1, 2.
Group Icon

Joined: 30 Mar, 2001
Posts: 4,069



Thanked: 1 times
My Contributions
^^ hahaha, that's my question! wink2.gif

Thanks for making the call. I think it can be done but I'm not totally sure. Right now I've got the server guy making a DB and seting up the DSN for it, but yeah, I don't know if I can create tables on the fly, hence my original question. biggrin.gif
User is offlineProfile CardPM
+Quote Post

2 Pages V  1 2 >
Fast ReplyReply to this topicStart new topic
Time is now: 1/8/09 05:41PM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month