split mdb file to Front End and Back end

A

AviA

Joined
Dec 21, 2005
Messages
6
Reaction score
0
Hi,​



I have split my mdb file to Front End and Back end. The point is that the BE remained without Password protection after the splitting. When I'm adding Microsoft Access Password to the BE, The FE can't log into the BE and a message "illegal password" appears. ​

How can I supply the password from the FE to the BE?​



BTW, I tried using this VB code, but it doesn’t seem to work (perhaps I'm not using it correctly..)​

Sub OpenProtectedDB()
Dim dbs As DatabaseConst
conFilePath = "C:\Program Files\Microsoft Office\Office\Samples\"
Set dbs = OpenDatabase(conFilePath & "Orders.mdb", False, False, ";pwd=topsecret")End Sub

Thank you for any help,​



Avi​
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protect BE with Microsoft Access Password 1
Split .mdb back-end 4
Front End / Back End & Password Protection 6
Citrix Deployment of Access 2007 Front End 0
Relationships - specify in front-end or back-end 3
1 front end, multiple back end mdb databases on server 5
Front End and Back End General Questions 33
Front End on Server or Local Machine? 12

Back
Top