f



open database from another database

I'm struggling with this, and I'm sure there's a way to do it. I would like 
to automate the back-up of an Access application to a writeable CD drive. 
I've got the process of creating a folder on the CD with the back-up date 
done, and I can copy the database objects (there are four MDB files in 
total) to the CD. All of that works.

Here's my problem: because Access databases cannot be copied when they are 
open, I need to have my CD writing code in a new MDB, and will need to 
launch the new CD writing MDB from within one of the existing databases. 
I've done this kind of thing before, but I don't have the slightest 
recollection on how I did it (used to be you had to do that kind of thing 
in order to compact/repair through automation).

So, I give up. How do you launch Access from within Access???
0
Mike
4/26/2006 1:17:10 AM
comp.database.ms-access 1111 articles. 0 followers. Post Follow

2 Replies
883 Views

Similar Articles

[PageSpeed] 38

Well this will do it:
Dim i As Variant
i = Shell("msaccess d:\persprop\CSCPP.mdb")

Just put in your own db path.
But this does come up with the warning that requires you to click to
get into to the db (in 2003).  If you know how to get by that I'd like
to know.
You could put the function in a macro and then close the db stat
started the new one.

Good luck
Ira Solomon

On Tue, 25 Apr 2006 20:17:10 -0500, Mike Easter <username@domain.com>
wrote:

>I'm struggling with this, and I'm sure there's a way to do it. I would like 
>to automate the back-up of an Access application to a writeable CD drive. 
>I've got the process of creating a folder on the CD with the back-up date 
>done, and I can copy the database objects (there are four MDB files in 
>total) to the CD. All of that works.
>
>Here's my problem: because Access databases cannot be copied when they are 
>open, I need to have my CD writing code in a new MDB, and will need to 
>launch the new CD writing MDB from within one of the existing databases. 
>I've done this kind of thing before, but I don't have the slightest 
>recollection on how I did it (used to be you had to do that kind of thing 
>in order to compact/repair through automation).
>
>So, I give up. How do you launch Access from within Access???
0
Ira
4/28/2006 10:04:48 PM
Ira, you're a lifesaver! I launched the application using shell followed 
by a DoCmd.Quit, then forced the new form to take center stage when 
opened (http://support.microsoft.com/?kbid=210500). Works like a charm! 
Thanks much!!!

Ira Solomon <isolomon@solomonltd.com> wrote in
news:c645529s2m1mc35b1t13gsggoh69mbdsdf@4ax.com: 

> Well this will do it:
> Dim i As Variant
> i = Shell("msaccess d:\persprop\CSCPP.mdb")
> 
> Just put in your own db path.
> But this does come up with the warning that requires you to click to
> get into to the db (in 2003).  If you know how to get by that I'd like
> to know.
> You could put the function in a macro and then close the db stat
> started the new one.
> 
> Good luck
> Ira Solomon
> 
> On Tue, 25 Apr 2006 20:17:10 -0500, Mike Easter <username@domain.com>
> wrote:
> 
>>I'm struggling with this, and I'm sure there's a way to do it. I would
>>like to automate the back-up of an Access application to a writeable
>>CD drive. I've got the process of creating a folder on the CD with the
>>back-up date done, and I can copy the database objects (there are four
>>MDB files in total) to the CD. All of that works.
>>
>>Here's my problem: because Access databases cannot be copied when they
>>are open, I need to have my CD writing code in a new MDB, and will
>>need to launch the new CD writing MDB from within one of the existing
>>databases. I've done this kind of thing before, but I don't have the
>>slightest recollection on how I did it (used to be you had to do that
>>kind of thing in order to compact/repair through automation).
>>
>>So, I give up. How do you launch Access from within Access???
> 

0
Mike
4/30/2006 7:20:06 PM
Reply:

Similar Artilces:

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://w...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

a database, is a database, is a err database
How many times can we see the same request from someone who wants to access data from a 'pick' database through what has come to be 'standard' practices (odbc, oledb) and still get the same old sloppy ' buy this proprietary utility (and above all, my services)' answer. I think most of these pick flavors should have some sort of layer (by now!) to handle this; If someone needs to do this, the service is really 'education' i.e to show them how. Lets cut the shit now and stop with this tired and silly BS and sad marketing schlock. Regards, -Jim Jim wrote: > How many times can we see the same request from someone who wants to > access data from a 'pick' database through what has come to be > 'standard' practices (odbc, oledb) > and still get the same old sloppy ' buy this proprietary utility (and > above all, my services)' answer. I think most of these pick flavors > should have some sort of layer (by now!) to handle this; If someone > needs to do this, the service is really 'education' i.e to show them > how. Lets cut the shit now and stop with this tired and silly BS and > sad marketing schlock. > > Regards, > > -Jim Jim who? I wonder? What is this? An attack on capitalism? Providing services for those who perhaps lack the time, skill, or knowledge to perform such tasks is hardly a crime. Maybe "standard" odbc and...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

Open Access Database Form from within Access database
I have included the following code to open an Access database form from within an exsisting Access database. But when I run the code, it appears that it opens the database because in windows explorer I can see the database has the .ldb file extension. So it appears that it's open, but I can't see the database or the form that I've tried to open. What am I doing wrong. The following is the code: 'This is in the declaration part of the module Dim appAccess As Access.Application ' Initialize string to database path. Const strConPathToSamples = "C:\Documents a...

Database Database Database Database Software Cheap #2
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Open a database from a database
I want to be able to open and run an Access database from within an already running one. The OpenDatabase command simply opens it but does not run the startup routine. Interestingly opening from Windows Explorer has a different meaning in that it opens and runs! What command enables me to open another database and get it to run its AutoExec macro, from code? Jim I don't know the answer, but I do know that when you use OpenDatabase the code in a startup form of that database does work. Martin "Jim Devenish" schreef in bericht news:0b4510ac-d415-4c2c-b200-7546aae178a4@gu8...

Opening Another Database from WITHIN a Database
I have a database (2000.mdb) which links to my data tables (Data2000.mdb). The database has a Main Menu screen (not a switchboard - a custom one). I need to import records from 5 text files into the 5 different Tables in Data2000.mdb. Here was my plan: Create various Import specs in Data2000.mdb Create a Macro (in Data2000.mdb) which calls each of the specs sequentially. Place a button on the Main Menu (2000.mdb), which closes the current database (optional), opens Data2000.mdb, runs the Macro (Import Reg), then returns the user to the original Menu in the original database (200...

Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Prevent database user to access another database
Hi, I have installed DB2 version 8.1 and created two databases, TEST1 and TEST2. Two operating system users test1 and test2 are mapped to two database users in TEST1 and TEST2 databases respectively. Even though test2 user does not exists in TEST1 database, I am able to connect to TEST1 database using test2 user. Also able to perform basic operations like CREATE /DROP table. After creating tables, it creates test2 SCHEMA and DB USER automatically in TEST1 database. How do I prevent this behavior? How do I prevent test2 user connecting to TEST1 database? Thanks Sameer ...

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS...

starting another Access-Database with database-password by Code
Hello! Since days I'm looking for a solution for the following problem for Access 2000: Can I starting by Code a database B.mdb (protected only with a simple database-passwort) from a database A.mdb by Code. The database-password must be a part in this Code. - Database: c:\ablage\test.mdb - Datapase password: 1234 Thank You very much! Greetings from Switzerland Thomas Ruf wrote: > Hello! > > Since days I'm looking for a solution for the following problem > for Access 2000: > > Can I starting by Code a database B.mdb (protected only with a > simple dat...

Another way to open an MS ACCESS 2000 database?
Hi! I've developed an ms access 2000 db. Then I'll protect the db with a password. But I want to open the access 2000 file from a Delphi 7 program, and try to have the program connect to the ms access 2000 db. 1. How can I have the OnOpen_event of the starting form in access check if the db is being tried open from doubleclicking the access 2000 file itself, and deny the user to open except from the Delphi program? 2. What is the connection string to the access 2000 file from the Delphi 7 program? The reason is that I'll write to the register from Delphi 7 and do ...

Another way to open an MS ACCESS 2000 database? #2
Hi! I've developed an ms access 2000 db. Then I'll protect the db with a password. But I want to open the access 2000 file from a Delphi 7 program, and try to have the program connect to the ms access 2000 db. 1. How can I have the OnOpen_event of the starting form in access check if the db is being tried open from doubleclicking the access 2000 file itself, and deny the user to open except from the Delphi program? 2. What is the connection string to the access 2000 file from the Delphi 7 program? The reason is that I'll write to the register from Delphi 7 and do ...

Need to Open Database from another Database and delete table within
I am trying to open Database #2 while in Database #1 and delete a table that is in #2 so that I can copy a table from #1 into #2 - all through a function. My Database #2, as part of the start up, opens a form for user sign in. It is not starting up with autoexec. I do not want the function to open the window and subsequently open the form in Database #2. Is there anyway to get around this? If I put the open form in the autoexec and not in the start up, can I work around it? And if so, can anyone offer any help or suggestions on the how to's. I have spent the day trying to find a way...

How to reset or disconnect all conections to an MS Access database if the database is hung up?
Hi, All: &nbsp; Sometime I do not knwo why my database in local C drive is locked. If I restart the LabVIEW software, it works fine. Is there a way to disconnect all connections before you make a new connection? I remember I used this function a couple of years ago but I could not find the function in new LabVIEW database connectivity tool kit. I am using LabVIEW 8.0.1. Thanks. &nbsp; Jim Is it DB Close Connection? You VI should contain one of these. <img src="http://forums.ni.com/attachments/ni/170/194552/1/DB%20Close%20Connection.jpg"> DavidMessage Edited by David C...

MS Access Script to import data from external mde database to mdb database
Hi, Does anyone know of a way I can write a script that imports a table from a particular .mde file? I don't seen any obvious way to do it as a macro. Any suggestions if it can be done as a macro or as a written module? My ultimate goal is to have script that clears info out of 1 table in an .mdb file, imports an identically structured table from a .mde file, runs an append query I have in place to copy the data from the imported table to the table in my.mbd file, and then delete the imported table. Any help that could be provided would be greatly appreciated. Best wishes, George Hadl...

Error on opening a database: MS JEt database says someone tries to modify the file
Hello, I've received a databasefile from a friend, which seems to be corrupted. When i try to open the file it gives the error: The Microsoft Jet Database Engine has stopped the proces, since you and another user are trying to modify the same data (translated from dutch). I can't do anythinh with this file. Even importing from another database or Compact and Repairing gives me the same message. Has anyone got a clue how to save the data in this .mdb file. Greetings, Remco Remco Groot Beumer wrote: > Hello, > > I've received a databasefile from a friend, which seems...

Web resources about - open database from another database - comp.database.ms-access

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Enterprises want to run databases in containers
More than three out of four IT decision makers are interested in running stateful applications like databases within containers, according to ...

NFL mock draft database 2016: Tracking Giants picks from around the Internet
Let's keep track of mock drafts from around the Internet as the 2016 NFL Draft approaches. Can we find a consensus for the New York Giants?

Consumer Group Sues DOT For Failure To Create Searchable Database Of Safety Defects
... about safety defects. One safety group says this hasn’t happened, and is suing DOT Secretary Anthony Foxx in an effort to make this database ...

TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers
TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers

Former Ohio cop uses cop database to stalk victim
... stalked her like an average person would, but stalked her in the way that only a police officer could: he stalked her utilizing a police database ...

U.S. Attorney Suggests Password Cardinals Used To Access Astros Scouting Database Was “Eckstein123"
... scouting director Christopher Correa plead guilty to five counts of unauthorized access to a computer for hacking the Houston Astros database. ...

Blinkbox Music's user database was just sold to... JD Sports
Of Tesco's three ailing digital Blinkbox services, its e-book store appeared to be the only one that would go gently into that good night. Eventually, ...

Resources last updated: 2/25/2016 5:44:51 PM