A co-worker has designed a database in Access 2003 to open in a small window with a specific form showing to emulate a standalone app...for many complicated reasons, I find myself wanting to display his entire database app on a form within my own database app, while keeping all the functionality of his app. So far I haven't found any way to do this. Anyone have any ideas?
One database inside another
- Thread starter dbiggied
- Start date
Oh man I wish it was that easy...I'd really prefer that anyway, but the guy that wrote it doesn't understand the concept of "we are on the same team" and he REALLY doesn't understand the concept of "It's not your database, it belongs to the company", and has the thing locked down tighter than Alcatraz and refuses to let anyone else touch it.
My #1 preference would be to just re-create the front end myself in C# and point it to his backend tables, but the way it's locked down, I can't even do that, and I can't just make my own and to heck with his, because people on teams across the country use his. Hence my idea about somehow embedding his into mine.
Any other thoughts?
My #1 preference would be to just re-create the front end myself in C# and point it to his backend tables, but the way it's locked down, I can't even do that, and I can't just make my own and to heck with his, because people on teams across the country use his. Hence my idea about somehow embedding his into mine.
Any other thoughts?
Can't you use the 'Import' function and import all the necessary bits over from his. That way everything gets brought in at once and then you just make a form/subform displaying his opening form of the app?
I did this recently on 2007 at work to import and ink/toner management app i had made into the fault report system we already had in place.
I did this recently on 2007 at work to import and ink/toner management app i had made into the fault report system we already had in place.
I can import tables and queries, but the reports, forms, and modules are locked to prevent import, and it's the modules I really want...I'm sure I could recreate his work with just tables and queries...but I wanted it done sometime in the next millenium. 
I suppose if I have to, I could always put some pressure on his manager under the "It's the company's database, we are all one team" banner, but that doesn't make for very good working relationships, so if I can't embed the whole thing, I guess I'll just keep annoying him until he unlocks it just to shut me up.
I suppose if I have to, I could always put some pressure on his manager under the "It's the company's database, we are all one team" banner, but that doesn't make for very good working relationships, so if I can't embed the whole thing, I guess I'll just keep annoying him until he unlocks it just to shut me up.
Oh sorry i didn't realise that. There was me thinking i would be able to be helpful 
lol
My knowledge is limited as i'm teaching myself and learning stuff on here day by day for the fun of it.
So on that note, Im out (one for any dragons den fans out there)
lolMy knowledge is limited as i'm teaching myself and learning stuff on here day by day for the fun of it.
So on that note, Im out (one for any dragons den fans out there)
- Local time
- Yesterday, 19:10
- Joined
- Jan 23, 2006
- Messages
- 15,528
It may be time for your manager and his manager to talk. There are few viable companies that can afford to have their IT areas (especially shared database) going off in different directions. You may want to discuss the situation with your manager and see what sort of "management perspective" you get. Could be you're the odd man out -- I wouldn't think so, but there's a lot of turf wars in real life that hide or obscure any sort of corporate culture and team approach.
Good luck.
Good luck.
I don't really think I'm the odd man out so much...me and a bunch of the other guys are always sharing anything from code snippets to full databases...this guy is the only one who really goes to the trouble to lock down stuff that's going to be used by the rest of us. He's can't really take advice very well either...the other day a simple "This would probably work better as a radio button instead of a check box" got his back up. I'll make some quiet inquiries to my boss. Thanks!
Similar threads
