Open a database within another database

[RTC]

I have a screen on my main database that has command buttons which open up various other mdb Access databases. All databases are in the same folder on each person's C-drive within the network, but the folders aren't called the same thing. The way I found before to open up a database from a command line was to use a hyperlink as you don't have to specify the folder name if it's within the same folder.
With Access 2003 it brings up constant security warnings when using hyperlinks to access other databases.
So what is the alternative code for opening another mdb database within the same folder on C drive without specifying the folder name?
thanks

 

[mark curtis]

put them on a server!!!

 

[RTC]

No it works fine the way it is thanks, I'm not about to change our whole network database structure for the sake of some security messages. Can anyone supply the code?

 

[mission2java_78]

No it works fine the way it is thanks, I'm not about to change our whole network database structure for the sake of some security messages. Can anyone supply the code?

Let me ask you something...when a change is needed to a database, do you change every single copy on each pc?

DB should be split, into front and back with the front being given to each end user. You're making your job a lot harder than what it really is.

Also you said all the folders names on each persons pc's are different. how are we supposed to give you code if the paths are all different

 

[RTC]

The databases are split - SQL2000 back end, Access front end. And the front ends are distributed to each user. And yes, deliberately, when make a change to one the rest are updated. This provides multiple copies of the same databases, an advantage if one goes belly up. It also makes for fast and efficient access.
We've been using this system for years and it drives our whole company and works flawlessley (and it only takes a minute to update each database after a change).

Regarding the code, with hyperlinks you do not have to specify a folder where the database you are trying to open is, you just put the name of it and it looks within the same folder as the database is that's calling it. Unfortunately M$ decided to plaster security messages everywhere.
There must be VB code that can be attached to the OnClick of a button to perform the same function as the hyperlink, without having to specify a folder name if the db is in the same folder.

 

[mission2java_78]

App.path

 

[RTC]

Could you elaborate on that a bit??
Not overly familiar with the VB side of access.
If I have a main database "CTS.mdb" and I want to attach code to an OnClick of a button on this to open a db called "CTS IT.mdb" that's in the same folder, what exactly would the code be?
thanks

 

[bradcccs]

Application.CurrentProject.Path & "\CTS IT.mdb"