Question How to link you own database with custom database?

[dai2809]

Hi everyone

I need to collect statistics on gender, ethnicity and attendence based on data which has been entered on a third-party Access database. I have browsed a saved database file, but found headings only. I do not know how to link these demographic data on the third-party Access database with an Access database file which I have created on my own. Please give me suggestions for troubleshooting.

Thank you

 

[genesis]

cant you open the third party access database?

It is probable if you have linked it and only headings appear, there are no records in it.

 

[dai2809]

The database opens in Access and I see numerous tables linked to each other. But all the same, I cannot see any records. Do you have any idea what file the records will be saved in?

Thank you

 

[genesis]

I think you terming the tables linked to each other as linked table, while I think what you are seeing is link relationship of tables. You should differentiate that.

I think what you want to say is you want to view the records from table 2 of database2 that is linked in table 1 of database1? In that case, you should be seeing an arrow in a Table Object, and that is the linked table from database2.

If you dont see records in that linked table, therefore, there are no records inside the table2 of database2.

Solution: try to input some records in your linked table1 and open table2 in database2. if you see records that you input then your link table is working just fine. if not try to post what happened.

 

[dai2809]

Oh, I've found one with records using Object Dependencies. It has one to many relationship with other tables. I will be able to modify this to fit our needs.

Thank you