access 2000 vba passw. and export

  • Thread starter Ljiljana Posavec
  • Start date
L

Ljiljana Posavec

Hi

Is it possible to export a form from db1 to db2, when db2 is protected with
a vba password?
If not, what are the best ways to send a new object for example to remote
sites?

any suggestions
Thanks
 
A

Arvin Meyer

It wouldn't be very secure if you could simply export a form (or any other
object) into a secure database. Permissions would need to be set on the form
from security in db2. You can do it 2 ways though:

1. Import the form into db2 and create the permisssions.
2. Run code from db2 which creates the form and sets the permissions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
L

Ljiljana Posavec

Thanks for answer, but...

my problem is :
client have program (db2) which is protected with 'Password to view
project properties' ( Protection Tab (Project Properties Dialog Box) ) and
'lock project for viewing'=true.
I want export one form from db1(also protected) (small base *.mde something
like 'service pack') into db2 but don't know how...TransferDatabase method
produce error...because of psw.
 
Top