k i hav a secured database using DATABASE SECURITY (let say db1) Tool and not the workgroup secutiry. now i hav another ms access (let say db2) w/ link table from db1 w/c and serve as the application that connect to the database (db1). the prob is it will now required the SECURITY PASSWORD of db1 before i can establish connection. saon man to pag insert the db1 security password? most my sql command carried out by EXECUTE method and when i do this:
sSQL="SELECT * FROM TABLE1;pwd='dbpass'"
currentproject.connection.execute ssql
it return an INVALID PASSWORD err...
Results 1 to 4 of 4
Thread: ms access security prob
-
09-20-2006, 10:39 PM #1Junior Member
- Join Date
- Mar 2005
- Posts
- 405
ms access security prob
-
09-21-2006, 09:22 PM #2Site Keeper
- Join Date
- Sep 2003
- Posts
- 1,426
Re: ms access security prob
Im too noob for this but no offense is MS Access really a secured DB?
ALONE:Hated and Punished
-
09-23-2006, 11:47 PM #3Junior Member
- Join Date
- Mar 2005
- Posts
- 405
Re: ms access security prob
NO for sure! but i hav a lot of things considered why i use ms access... dats 4 me...
-
10-19-2006, 11:42 AM #4C.I.A.
- Join Date
- Sep 2006
- Gender
- Posts
- 2,705
Re: ms access security prob
I think you are right. there are lots of things to consider for using ms access.
Originally Posted by hybrid_X
NO for sure! but i hav a lot of things considered why i use ms access... dats 4 me...
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|