On 05/21/2007 02:43 AM, Marleen Jongen wrote: > Hello, > Thank you for your reply, no, I didn't open it with ODBC, because in User > FAQ it says "Microsoft Access .mdb". The error message is "cannot connect to > database". I downloaded from Microsoft some application in which it says > could convert to openoffice database. > Kind regards > marleen
Perhaps this will help: http://wiki.services.openoffice.org/wiki/MSA-Base_Faq <quote> Can I use Microsoft Access databases (.mdb) in Base? On Windows: yes. You cannot open them directly via File|Open, but you can access the data therein. For this, you need the Microsoft Data Access Components, which are available from Microsoft for free. (In Windows XP, they're already included, so you need them for older Windows versions only.) Then, go to File|New|Database, choose "Connect to an existing database", and select the "Microsoft Access" database type from the list. On the next page, you then select the .mdb file you want to access. If your database does not have a password, this will allow you to read and update the data in your Access tables. If your database has a password, try ADO instead. You cannot read / modify or use the Access forms, queries, or reports. </quote> I would expect the MDACs is already present in Vista, if not here is the link from the FAQ: http://msdn2.microsoft.com/en-us/data/aa937730.aspx Here is a older, yet still relevent, FAQ for using ODBC to open MS Access files: http://www.openoffice.org/FAQs/ms-access/ms-access.html For linux users: Here are some helpful links. http://dba.openoffice.org/index.html http://dba.openoffice.org/drivers/mdb/index.html http://sourceforge.net/projects/mdbtools (I've send a cc to you because you are not subcribed to the mailing list; Please mail to the lists only. To subscribe to this list, send an empty mail to: [EMAIL PROTECTED] etc. and reply to the message that follows. See: See: http://www.openoffice.org/mail_list.html for details) > ----- Original Message ----- > From: "Dan Lewis" <[EMAIL PROTECTED]> > To: <[email protected]> > Cc: "Marleen Jongen" <[EMAIL PROTECTED]> > Sent: Thursday, May 17, 2007 8:12 PM > Subject: Re: [users] [moderated]data base conversion > > >> On Thursday May 17 2007 1:44 pm, James Lockie wrote: >>> Marleen Jongen wrote: >>> > Hello, >>> > I have a Microsoft Access database and although followed >>> > instructions in help, cannot open it in Openoffice. We have Vista >>> > Home on our PC. What else can I do ? >>> >>> You tried to open it as an ODBC data source, right? >>> Does it show up but won't open? >>> Is there an error message? >> >> Copy to Marleen. >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
