open another database within a database

toddbingham

Registered User.
Local time
Today, 01:32
Joined
Jul 8, 2003
Messages
93
Can I have a database load a form with command buttons that opens another database that will open the databse within the currect session of access.
What I have is terminal services setup and accessing a server using remote desktop. I have access execute upon login which will open a database. I had a command button that executed a batch file that will open up another database. The problem is, this works fine when I log in normally, but when i have Terminal services restrict, and only allow access to msaccess.exe, the batch file cannot open the other database. I guess because it is trying to open another session of msaccess. Anyone have any suggestions?
 
Combine them together?

Not sure how they are built, but you cant open a DB in a DB.
 
Todd,

Don't really understand your statement of the problem, but generally, it is
better to use Access's Linked tables than to deal with opening another
database and manipulating it.

Need more info,
Wayne
 

Users who are viewing this thread

Back
Top Bottom