OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Password protected access database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
sjcosh
Newbie
Newbie


Joined: 23 Apr 2009
Posts: 2

PostPosted: Thu Apr 23, 2009 4:31 pm    Post subject: Password protected access database Reply with quote

Hi, Ive got and password protedted access database (which i do know the password for, as i created it) and i would like to open it through OO Base, but i cant see where i can enter the password, can someone please help.

Thanks.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Apr 23, 2009 4:57 pm    Post subject: Reply with quote

Hello

It does request for the pasword.
It does only request for the pasword when a certain checkbox is marked

how to do
menu --> edit -->database --> properties

Or

select a table right click and goto database properties

It seems only to work with registered databases.

Romke
Back to top
View user's profile Send private message
sjcosh
Newbie
Newbie


Joined: 23 Apr 2009
Posts: 2

PostPosted: Thu Apr 23, 2009 5:47 pm    Post subject: Reply with quote

Ive regersterd the database and when i goto database options there is nowhere for me to enter the password, i keep getting this message, The connection to the data source (name) could not be established. Not a Valid Password, but there is nowhere for me to enter the password!!!!!!
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Apr 23, 2009 11:47 pm    Post subject: Reply with quote

Hello


Did you find the mark place?
How did you make your database? I think you do it wrong

read this link for information.
http://www.oooforum.org/forum/viewtopic.phtml?t=79606&highlight=odb+copy

Romke
Back to top
View user's profile Send private message
path32
General User
General User


Joined: 17 Oct 2011
Posts: 10

PostPosted: Wed Apr 18, 2012 9:28 pm    Post subject: Reply with quote

go to ur database... right click properties and you will see your passwors Twisted Evil
Back to top
View user's profile Send private message Yahoo Messenger
danferman
Newbie
Newbie


Joined: 20 Dec 2013
Posts: 2

PostPosted: Fri Dec 20, 2013 5:53 am    Post subject: How to open an access database with password using Oo Base Reply with quote

This topic is opened since 2009 and nobody has answered well.
With OpenOffice 4.0.1 it is simple.
Everybody is trying open directly the access database using the Connect to an existing database and selecting Microsoft access connexion, and this option fails in case the database is protected by password.
In case you are finding this problem try this one:

1. Connect to an existing database
2. Select ODBC
3. Click on explore and select the data source name is pointing to your databes. In case you have not created the data source name we are going to create it now.
4. Click on Manage or Create (it depends of your language).
5. Click on Add.
6. Select Microsoft Access driver (*.mdb)
7. write a name for the new data source name.
8. click on Select in the data base and select your database.
9. Once you have selected the database and before to accept you must click on Advanced.
10. write here the password and accept everything
11. Select the data source name created
12. accept everything and finish

I have followed all these steps and it worked.
Hope can help you too.
Back to top
View user's profile Send private message
danferman
Newbie
Newbie


Joined: 20 Dec 2013
Posts: 2

PostPosted: Fri Dec 20, 2013 5:57 am    Post subject: How to open an access database with password using Oo Base Reply with quote

I forgot to write this link will help everybody:

https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group