Unanswered: Password on the BE: Table LINKING Function now Haywire?
i put a database password on the BE ,and the I have DEV Ashish's code in my db to auto link the tables
i modified it to auto link to the folder path where the FE is being run from which is as under:
the error displayed is "not a valid password. error #: 3031"
strNewPath = Application.CurrentProject.Path _
& "\Pay Calc Data.mdb"
the line i have isolated producing the error is
Yes the password of my BE is 123456- which is opening if i open it directly
Set dbLink = DBEngine(0).OpenDatabase(strDBPath, , , "pwd=123456")
before i put the password it was linking perfectly to the FE Folder where the BE is also present. yes the BE is in the same folder and if i remove the password it still links.
the code bfore the password was
what must i do?.....anyone???
Set dbLink = DBEngine(0).OpenDatabase(strDBPath)
I am att the whole code as a doc files.
both modules are reqd to run this function , I have tweaked just a bit of it. what else do i do to get it to send the password???
Last edited by abhichoudhary; 04-01-06 at 11:29.
A2K3 WinXP Prof SelfLearner