How can I make Access 97 "see" tables in a remote database after creating those tables with a query???

[MLH]

I used the following SQL to create a new table in a database on
a remote MySQL server by copying one already there. I know the
table exists SOMEWHERE in cyberspace. I can read its data, write
to it, delete from it. But I cannot see it. The only way I know it
exists is by running this SQL from Access 97 pass through query:

SELECT ALL new_tbl.name FROM new_tbl

The database resides on a MySQL server that was created with
a single table (named test) in it for testing purposes. I ran the
following SQL to create another copy of the table in the same
database named: new_tbl

CREATE TABLE new_tbl SELECT * FROM test;

I cannot see the new table in the Access 97 database window
under the Tables Tab. Anybody know how to overcome this?
Its a severe drawback to programming efforts not to KNOW what
tables are in your database.

[Rick Brandt]

"MLH" <CR**@NorthStat e.net> wrote in message
news:h4******** *************** *********@4ax.c om...

I used the following SQL to create a new table in a database on
a remote MySQL server by copying one already there. I know the
table exists SOMEWHERE in cyberspace. I can read its data, write
to it, delete from it. But I cannot see it. The only way I know it
exists is by running this SQL from Access 97 pass through query:

SELECT ALL new_tbl.name FROM new_tbl

The database resides on a MySQL server that was created with
a single table (named test) in it for testing purposes. I ran the
following SQL to create another copy of the table in the same
database named: new_tbl

CREATE TABLE new_tbl SELECT * FROM test;

I cannot see the new table in the Access 97 database window
under the Tables Tab. Anybody know how to overcome this?
Its a severe drawback to programming efforts not to KNOW what
tables are in your database.

Tables on server-type databases are never "seen" in your Table window unless you
create a link to them.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[MLH]

You're exactly right. It was a braindead moment in time for me.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxx

On Tue, 14 Oct 2003 19:26:37 -0500, "Rick Brandt"
<ri*********@ho tmail.com> wrote:

Tables on server-type databases are never "seen" in your Table window unless you
create a link to them.