need access to read to SQL db and Access frontend

P

Pat Hartman \(MVP\)

If you want to link to the SQL server tables from a new database, the
simplest thing is to create a new empty database and then instead of using
the link tables option, use the import option. In the case of linked
tables, this imports the links. It doesn't really import the data. So your
new database should have links to the same tables as the old database.
 

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