Differnt ways of Connections in access database...

[pedie]

Hi, i need help with different ways of Connections in access database which is password proetected...
Open different database and perform task in the table/query and close it back.


Thanks alot in advance for helping.

 

[HiTechCoach]

Access as a back end is basically unsecured.

Connections to what?

Will you give more detailsl on exactly what you need to do?

 

[pedie]

Boyd, thanks alot for quick reply...
Yes, 'm specifically wanting to open database2 with password from database1 and copy all data from table1 database1 and paste it in database2 table1.


Thanks again for helping.

 

[HiTechCoach]

If you are wanting to automate the process then I would not use copy and paste. I would use an append query.

The simplest method is to use a linked table

You could open a recordset. See: How to use the OpenDatabase method to open password-protected databases


Why are you wanting to copy data between databases? Why duplicate the data? Why not just link to it?

 

[pedie]

Thanks again Boyd...that is helpfull....