linking an access front end db tbl to a backend tbl lnkd to SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We currently converted all the tables of in our backend access DB to sql, I
am trying to reastablish the links to the front end db and I am unable to
link to the tables linked to SQL, Access will only allow me to import the
tables into my front end db.
How do I link the frontend tables to the backend db?
 
File : Get external data : Link tables, or somesuch.

Note: in normal Access parlance, the "front end" is the database
containing the forms & reports. The "back end" is the one containing
the actual tables. The front end links to the actual tables in the back
end - not vice versa.

HTH,
TC [MVP Access]
 
Thank you for your time on this. I did figure out my answer. SQL became my
"backend" and I do not need to link the tables of the front end to the old
back end. I just have my front end work off the linked tables to SQL.
 
Back
Top