H
Huckle
I will be connecting a lot of individual databases. Assuming I am dealing
with a .accdb databases that are password protected:
Can I open one database from another through code (I currently do that in
Access 2003 with automation).
Can I access data from another database through code (return a recordset)?
With automation and linking, can the code contain (pass-thorugh) the
password so the user is not prompted for it?
Can the automation and/or link work in a run-time environment (this was not
allowed with Access 2003 run-time, very frustrating...)
Am I understainding correctly that the developer extentions are available as
a free download as well as the run-time version of Access 2007?
Sorry in advance if my wording/descriptions are not very good, I know enough
of Access to be dangerous, but not enough to be good
with a .accdb databases that are password protected:
Can I open one database from another through code (I currently do that in
Access 2003 with automation).
Can I access data from another database through code (return a recordset)?
With automation and linking, can the code contain (pass-thorugh) the
password so the user is not prompted for it?
Can the automation and/or link work in a run-time environment (this was not
allowed with Access 2003 run-time, very frustrating...)
Am I understainding correctly that the developer extentions are available as
a free download as well as the run-time version of Access 2007?
Sorry in advance if my wording/descriptions are not very good, I know enough
of Access to be dangerous, but not enough to be good