Split database help?

[Weresmytriple]

hi i have created a database and just use the feature to split the database. i then set a password on the back end database. however now when i use a macro to open a form in the front end it won't open the form and just says incorrect password. any idea how to fix this issue?

 

[pr2-eugin]

Try deleting all the table links in the front end file, then relink them again. This will prompt for the password. Enter the password then try again !

The reason is because, when you split the DB the link information stored within the MSysObject would not have any password. When you created a password in the backend after the split and then try to access the tables from the front end it will need the password. Since the password was applied after the split, this information is not available. Relinking them again will solve the problem !