Addendum:
I double-checked:
- It is the tables that were included in the MSAccess querry that can no
longer be accessed by MSAccess.
- The tables in question can be viewed with psql and PGAccess.
Is there a way to save the work or do I have to re-create and re-export
data?
Any suggestions are highly appreciated.
Mihai
-----Original Message-----
From: Mihai Gheorghiu <tanethq@earthlink.net>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Tuesday, July 31, 2001 5:47 PM
Subject: [GENERAL] Corrupted tables?
>Is there anything like that?
>I was exporting some MSAccess tables via ODBC, and it was taking a long
>time.
>I tried to do something else in the mean time (open Forte).
>The export ceased and I started to get "ODBC connection failed".
>If I open a blank MSAccess db and fill it with new files by linking to the
>PG db, it works. Then I try to open them one by one, and some open, some
>don't (it seems those that were accessed in the query that was running at
>that moment).
>Is there a way of repairing PG tables?
>
>Thank you all,
>
>Mihai
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly