How do you open an Access database from in a Access database?

Question

I'm just starting to program in Access 2003 and need to know how I can use a form to open a separate database.
Thx

I'm using Access 2003 and need to alter the code on a standard form from opening something like another form to opening a separate database.

Answer 1

Like the others say use the ADO object

VBA code would be something like;
Set cnnAdo = CreateObject("ADODB.Connection")
cnnAdo.ConnectionString = ""
cnnAdo.Open

-- cnnAdo is now an open connection to the other database
-- to open a recordset use

Set rsAdo = CreateObject("ADODB.Recordset")
rsAdo.Open "", cnnAdo, 0, 1

-- The 0 & 1 indicate forwardonly and readonly
-- (Change this if you want)

Do While Not rsAdo.EOF
-- Your code on the recordset here
rsAdo.MoveNext
Loop

rsAdo.Close
cnnAdo.Close
Set rsAdo = Nothing
Set cnnAdo = Nothing



Remember if Option Explicit you need to define the Objects first

Hope this helps

Answer 2

Not sure what language you are writting in. But anyway you will need an ADO object an Oledb connection or something ( a connection string and connect to the database), a command( the query or whatever you want to perfom on the data table) and an execution call to execute the command. Search for ADO.Net you should find some tutorials.

Answer 3

Using a system ODBC connection to the database.

Start > Control Panel > Administrative Tools > Data Sources

Answer 4

my guess would be by adding an ADO.NET object to that form, connect to the database and access the tables in it