I recently had to add a new database role for an existing Access.adp database using SQLSERVER 2008. I already have 4 other roles working just fine, but I cannot connect (We use NT Authentication) when using this new role. It bombs out and says that it's "Unable to verify login. Program Aborting". I cannot determine what I am missing. I use the following procedure to verify who's trying log into the database based on the assigned role. For...

How DO I link A tab control subform to the mainform that is unbound?



I plan to try a few different options unless I get a better suggestion from someone. Thank you very much!...

Linking tab controls subform to an unbound mainform



Thanks for the quick response. Everything you said is correct. However, I did originally start off with a Record source, then deleted it, but I continued to have challenges. I considering just putting in command buttons to open the subforms instead of using tab controls. Is that a better way to go?...

I have a mainfom that uses a stored procedure with parameters as the recordsource, but is not bound (recordsource property is blank). In the mainform I wrote code to indicate the record source is equal to the stored procedure & the parameter. On its own, it runs fine. I inserted a tab control with 3 tabs and each has it's own sql view based record source. When I did this, the autolinking didn't occur. I manually assigned the master an child...