Problem in accessing the Access Database

[jaz215]

Hi can anyone show me how to connect to an access database and also give me samples on adding and updating..(what i usually do is just by setting the properties of the adodc)

my problem is that i just have set a password in my access dbase so everytime i open my program (even though as set the password property of my adodc) it asks for the password of the dbase.. how do i overcome this?

[jaz215]

my problem is that i just have set a password in my access dbase so everytime i open my program (even though as set the password property of my adodc) it asks for the password of the dbase.. how do i overcome this? (sorry i was trying to delete this reply)

[QVeen72]

Hi,

You have to give Password in the Connection string.
Change the connection string of the ADODataControl :
[code=vb]
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=C:\mydb. mdb; Jet OLEDB:Database Password=MyPass word
[/code]

Regards
Veena

[jaz215]

Hi i just did what you send but i got error when opening it.. it says the workgroup file is missing or opened exclusively by another user.

[QVeen72]

Hi i just did what you send but i got error when opening it.. it says the workgroup file is missing or opened exclusively by another user.

Did you change the Connection string..? Post your Connection string here..

REgards
Veena

[jaz215]

Did you change the Connection string..? Post your Connection string here..

REgards
Veena

i've got it going now tnx! :)