accessing records in one secure DB from another secure DB - programatically 
Author Message
 accessing records in one secure DB from another secure DB - programatically

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



Sat, 07 Dec 2002 03:00:00 GMT  
 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



Sat, 07 Dec 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. setting permissions to Unsured db from secured DB

2. how to access secured access db?

3. Access secured Access DB from VB .40

4. Accessing a secured Access 2.0 DB with VB4.0 16-bit

5. Using a Data Control in VB5 accessing a user-level secure Access 97 DB

6. Accessing a secured db via VBA?

7. Securing Access DB

8. VBA: linking a table from a secured access-db

9. Linking to a secure Access DB from VB5.0

10. VB 5.0 to Secure Access DB

11. secure db in Access 97

12. Problems ADO VB reading secured Access DB

 

 
Powered by phpBB® Forum Software