How to set up connectivity to a Access Database

[121854]

Can someone help me out on setting up connectivity to an Access Database for access?

The database name is Project_names and I would like to set connectivity and read the database sequentially. How should I set up connectivity and set up the SQL instructions?

Thank you,
Access Beginner

 

[LittleSmudge]

Sorry OM - really can't get my head round what you're asking.

Where are you reading this database from ?

Are you talking about connecting two databases together - Frontend containing Forms, Reports, Modules and the BackEnd containing Table - or what ?

Are you wanting to extract this data into a MailMerge of some kind ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[121854]

What I need is to join two databases. Then select all the data elements from both them and display them in an access datasheet.

 

[lespaul]

So what you are saying is that you have two Access databases, in each of the databases you have a table that you need to combine into a single recordset?

 

[121854]

Yes.

 

[Golom]

You can use "IN" in the FROM clause
[tt]
Select * From tbl1

UNION

Select * From tbl2 IN "C:\thepath\OtherDB.mdb"
[/tt]