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

C

cs

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?
 
T

TC

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]
 
C

cs

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top