By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"MLH" <CR**@NorthState.net> wrote in message
news:h4********************************@4ax.com...
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
Nov 12 '05 #2

P: n/a
MLH
You're exactly right. It was a braindead moment in time for me.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx

On Tue, 14 Oct 2003 19:26:37 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:
Tables on server-type databases are never "seen" in your Table window unless you
create a link to them.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.