Bound ComboBox to external database (1 Viewer)

[Capitala]

I have two databases; one for forms (db1) and the other (db2) where I kept my tables (protected with password)
Now, I need to bound data in a form; form or sub-form recordsource, combobox, listbox ...etc. to that external database without linking tables.
NB: linking tables will enable the user by a way or another to access the tables and update them manually.
Attached both files. db2 password= 12345
Thanks in advance

 

[theDBguy]

Hi. Check out @isladogs' no linked table demo.

Encrypted Split No Strings DEMO Database | Access World Forums (access-programmers.co.uk)

 

[isladogs]

If the link given by the DBGuy looks worth following up, please look at the updated app & info on my website: Encrypted Spilt No Strings - Mendip Data Systems

 

[CJ_London]

If you are not looking for a fully secured system then the essence of what you need would be your form recordsource or control rowsource to have sql along the lines of

SELECT *
FROM myTable  IN '' [ms access;pwd=password;Database=C:\path\BE filename.accdb];

note the two single quotes

an alternative for single tables is

SELECT *
FROM [ms access;pwd=password;Database=C:\path\BE filename.accdb].myTable

both of which will produce an updateable query

During development, you could link your tables and having got your query working as required, put the connection string in the query properties

then copy the sql to your record/row source. Then you can delete the query and linked tables. So when you create your .accde the sql containing the password is not available to users. And the FE does not contain any tables or queries

However do note that this can be easily 'discovered' even with .accde by someone who knows how to look for it. If you want higher security, then take note of Colin's examples

 

[Capitala]

Thanks, I'll work in it. Kindly let me revert to you later

 

[arnelgp]

If the link given by the DBGuy looks worth following up,

it will require you much code, and i doubt if the man will just throw his code without any price?
use suggestion on post #4.