Moss Rawn wrote:
After opening an MS Access database in Open Office Base, and
registering it and saving it in Open Office Base, if I delete the
original Access database, the link to Base breaks, and Base will NOT
open the newly created file. Is there a way to make the Base database
INDEPENDENT of the original Access database? Please advise.
Hello Moss,
As you have found the term 'Connect to existing database', which you
needed to select when you created your Base file does not mean 'Import
from existing database'. and that is exactly what you would have to do.
Two ways to do that.
One -
create a new Base file, just a standard default odb file. NOT one that
connects to some other database.
Now open the new one and the current one that 'connects' to the tables
in the MS Access .mdb file.
Select the table section in both Base windows.
Drag and drop the tables ( one at a time ) from the 'Connect to' file to
the new Base file. Be sure to drop the file into the tables section or
onto the Tables icon.
This this will start the Table Copy Wizard.
or
Two -
Export the tables from the MS Access database to CSV files and import
them into a new Base file.
I would try the first way to start. You can get into to trouble however
if you have used the feature in MS Access where lookup tables can be
embedded in fields of an Access table. In this case, and a few others,
the copy table wizard fails. In this case you need to do the Export ->
CVS <- Import process. You will lose those lookup tables, but you can
recreate them in the new Base file.
HTH
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
