tables - access db

[zac1234]

i'm using coldfusion with an access db. i currently have two tables in my db
which i am able to query no probs. i now wnat to add a third table but for some
reason its not displaying in the "application / database / tables" panel in
dreamweaver, therefore i can not connect/query it.

ive tried verifying the db via coldfusion control panel
ive tried refreshing
ive tried restarting
ive tried deleting and recreating

please elp !!!

[Dan Bracuk]

Have you tried a cfquery tag in code view of dw?

[zac1234]

yes i tried this. i tried just ignoring the fact that it wasnt listed in the
applications panel and hand coded but ij just throws up an error when tested.

its almost as if the table hasnt been created....

[Dan Bracuk]

When you said you tried deleting and re-creating were you referring to the table or datasource? If table, try datasource.

[zac1234]

yes tried deleting and then reinstating the datasource but still no joy. just ct understand it, ive triple checked everything .... i think!

[paross1]

How did you create this table? Did you actually go into Access and create it and/or have you actually gone into Access and verified that the table exists?

Phil

[zac1234]

yes correct, i simply opened up acccess, then opened up my db and created a
table the same way i did with the other two and when i go back into access the
table doe exist ok and doesnt give any indication that there might be something
wrong/different about it.

[Jochem van Dieten **AdobeCommunityExpert**]

zac1234 wrote:

> i'm using coldfusion with an access db. i currently have two tables in my db
> which i am able to query no probs. i now wnat to add a third table but for some
> reason its not displaying in the "application / database / tables" panel in
> dreamweaver, therefore i can not connect/query it.

Try creating the table from inside CF using a query:
<cfquery datasource="...">
CREATE TABLE tablename (
ID INTEGER,
name varchar(25)
etc.
)
</cfquery>

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[jdeline]

Have you looked at the database with the Access application? Is the table
really there? Access will create a .ldb file that locks updates out certain
things you can do with the .mdb file.

Is the database on a remote server or on your local machine?

[elDonrico]

i'm thinking you are looking at the wrong database. do you have access to the
server the db is on? if so, check your cf administrator to make sure you are
referring to the db on that server... then open up the db from that server. i
think you are using some local copy or something. if its a standard table in
access that you have a dsn set up for, you should have no problems.

[elDonrico]

and when i say access to the server i mean do you have the ability to go to the server other than ftp? not access the program (man, what a stupid name to call a program)