
accessing records in one secure DB from another secure DB - programatically
Hi,
This is a typical issue. What you need to do is in your code, create a
worspace. Creating a workspace supports username and password. THen you
can open up connections to the remote secure DB, and since you provided
the username and pw at the time of workspace creation, you will create
the recordsets without a problem (provided the username has permission).
Then do whatever you wanted with the recordsets and at the end, iff you
no longer need the workspace, delete it from the collection.
I suggest you read up on the workspaces in Access help. It provides good
explanations and examples on how to accomplish all of this.
Good luck,
Peter Endisch
Quote:
-----Original Message-----
Hi all,
I have one secure DB working off a particular MDW file. It contains
tables
which I want to filter and then pass to another DB. Trouble is...the
other
DB is secured using a different MDW file.
All I want to do is programtically log into the other DB with a known
user
name and PW and delete/edit/add records to selected tables.
Is this possible?
Is there no arguments to pass these two variables?
All help appreciated!
Kind regards all,
Vince