A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VB open access database



 
 
Thread Tools Display Modes
  #1  
Old September 27th, 2004, 04:23 PM
Berlin Brown
external usenet poster
 
Posts: n/a
Default VB open access database

How do I open an access database from an already open database. For
example, I want to add tables and records from one database to an
exisiting database.

  #2  
Old September 27th, 2004, 04:41 PM
Bill
external usenet poster
 
Posts: n/a
Default


-----Original Message-----
How do I open an access database from an already open

database. For
example, I want to add tables and records from one

database to an
exisiting database.

.
Dim DB as database

Set DB = DBEngine.Workspaces(0).OpenDatabase
(strDataBase)
strDatabase = name of the database to be opened
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple VBA code to open other access database Berlin Brown Using Forms 1 September 27th, 2004 11:15 PM
Access and VB HS1 General Discussion 2 September 9th, 2004 09:01 PM
access 2003 can't open an access 2000 mdb Sean General Discussion 7 August 13th, 2004 06:41 AM
Open an Access Database under 97 John General Discussion 3 July 27th, 2004 12:34 PM
Please Help, The database is in an unexpected state; Microsoft Access can't open it. Gary A. Hollenbeck New Users 2 May 20th, 2004 05:42 PM


All times are GMT +1. The time now is 05:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.