security for table. 2

[kkgusta]

Hi there i have create an Access Db and an Access Front end where all the forms and reports are located. The from and report in the front end have link table from the access db.
I have set up a security in (login adn password) on the from end. However I dun know how to set security on the Accesss db (something like a passowrd login). Is anyone here know how to do that ??

 

[yummy7]

hi kkgusta,
I also had this type of problem but I resolved it in this way.
1.First save seperately your original .mdb file before making any change.
2.Then Set Db password from tools--> security--->set password.
3.Then go to Tools-->Startup--->Set your startup form and also uncheck show Db window .You can also uncheckother options.
But please dont forget to save your Db before making any change.If you face any problem then let me know.

 

[randy700]

Create one form for the back end. Make it your startup form. Place a large label on the form to notify anyone that enters that they are in the wrong file. Set the form to maximize in the Form Open event. Place one button on the form that, when clicked, quits the application.

Randy

 

[kkgusta]

Hi there Thank for your reply, I have tried both solution form Yummy7 and randy700. Both solution are working.


Cheers

 

[kkgusta]

Hi yummy7, i have a problem by using the password in fof my dabatase. After i set the password in the access database, i am having difficulty in accessing the database using the

set rs = currentdb.openrecordset(SQL)

The error message "in valid password" is popping up every time the frontend try ing to get access the database.

I am wondering is that a easy way to solve this problem without changing my recordset password ?

 

[yummy7]

Hi,KKgusta
Strange that why are you facing problem with recordset.I am also using it in DB.It works great.
See, When you set password in Db.So after logining,you should have access to all Db.
Does cursor come oves this line after showing this error msg.
set rs = currentdb.openrecordset(SQL)

 

[TheAceMan1]

How are ya kkgusta . . .

[blue]BackUp your frontend[/blue] so you can come back to square one if you have to. Then follow this:
[ol][li]Open the frontend and close any open forms.[/li]
[li]Delete all [blue]linked[/blue] tables to the backend.[/li]
[li][blue]File[/blue] - [blue]Get External data[/blue] - [blue]Link Tables[/blue].[/li]
[li]In the [blue]Link[/blue] window, find and select the [blue]backend DB[/blue].
When you do you'll be asked for the [blue]password[/blue]. Type it in to continue.[/li]
[li]Make sure the [blue]tables are re-linked[/blue] then save/close the frontend.[/li]
[li]Done! . . . Open the frontend and check it out![/li][/ol]

See Ya! . . . . . .

 

[kkgusta]

Thank The Aceman1,
It work again after I re link the table.