I have not tried this one myself, but I believe almost any statement
recognized by the backend will work in a "Pass-Through Query".
1. Open a new empty query in design mode.
2. Select Query|SQL Special| Pass-Through.
3. Enter "CREATE DATABASE dbname"
4. Run the query.
5. Configure your new data source (DSN) on the PC.
This method may be more trouble then it is worth, but it should work.
Sorry, I can't try it here at home. I only have a single dual boot
machine.
----- Original Message -----
From: Robert Chalmers <robert@chalmers.com.au>
To: Valerio Santinelli <tanis@mediacom.it>
Cc: <pgsql-general@postgreSQL.org>; <daveh@insightdist.com>
Sent: Monday, January 18, 1999 8:44 PM
Subject: Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
>Great,
>Thanks chaps. I have it working. Now just have to get used to it so I am
not looking up
>the instructions every time I make a move.
>
>I can load tables, and create tables in an existing database - which I have
running on
>the server, and probably even update the data.. but is it possible to
create a database
>on the server from Access? That way, I could do all the creation and
updating from the
>Access machine. It's not a major headache anyway. Indeed no problem at all,
as I can
>obviously just go to Unix, create a database, then back to Access to
populate it and
>update it.
>
>Anyway, thanks for the pointers. Saved me HOURS AND HOURS ....
>
>Best regards
>Robert