Question Table Linked Access

[Kader]

Hi Gurus,

I understand the ODBC linked table (that's the table is linked to the external database table), but what does mean access linked table and how can I see (explore!) the definition of the table that is linked to?

Thanks in advance for your reply,



Kader

 

[Galaxiom]

You should be able to look at the design view the linked table in the front end database. But to change the structure you must open the original database.

 

[Kader]

Hi Galaxiom,
Thanks for your reply. My question what does linked access table?
If the table is linked to the external database (Oracle, SQL Server) it appears as OBDC linked table, that's right?
The acces linked table does mean the table is linked to another access table?



Kader

 

[DCrake]

You can link data from many sources and types of data. A linked table will appear in the tables list with an appropiate icon next to the name, and as mentioned the structure is read only. This is the correct approach for all applications so that the development side of the application is seperate from the actual data tables. Not only for structual safety's sake but this lets you develop the front end whilst users can still access the back end.

David

 

[Kader]

OK! Thanks David.
Now I have another question. I have two access databases. One has the front end applications (forms, reports, etc...) and another with extension md.mdb, I guess where data resides (sorry I inebriated this MS applications, I neophyte). The problem, I can't open the md.mdb file. The MS Access closes immediately!?
How can I access to the backend data and modify the the access linked table?

Thanks in advance for your inputs,


Kader

 

[DCrake]

Hold down the shift key when opening the front end to bypass the auto load. Then click on tables and hoever your mouse over a linked table. This should show you the path to the source mdb.

Navigate to the source mdb and do the same. This way you can amend the back end. Remember to take a back up first. All changes should now be reflected in the front end. If you add/delete fields this may have affects on your linked tables and resulting queries.

David

 

[Kader]

Great! Many thanks David.
Your inputs are very heplful for me and I appreciate that.

Have a nice day,


Kader