MS Access
-
I am using a password protected DB. When i try to read from that table from another DB it is asking for the password. how to give the password. my query looks like this " insert into table select from table in 'database'" . in which the database is password protected. Any idea?.....
-
I am using a password protected DB. When i try to read from that table from another DB it is asking for the password. how to give the password. my query looks like this " insert into table select from table in 'database'" . in which the database is password protected. Any idea?.....
Are you using Access for development? If you are, it's advised to use linked tables instead of external tables. See for example: http://www.techonthenet.com/access/tables/link_table.php[^]
The need to optimize rises from a bad design.My articles[^]