Miscrosft Access link to SQL 2000 table view is #Deleted

S

sales

I had this problem and noticed a few other people have experience this
also. No real solution has offered by most groups. I believe the best
work around is to use the SQL import and Export utility to export the
view or table you are after into Microsoft Access and then setup to
schedule the process. Works like a dream!!!
 

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

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Access 2007, SQL 2000 3
Linking tables access - sql server 2005 4
dbSeeChanges problem in Access with linked SQL Server table 4
Linked tables to SQL and how to handle triggers on SQL ??? 4
Replacing a Table with a Table from another database - reference issues 1
Importing Access tables into SQL Server 1
Why won't Access assign a Primary Key ID to my linked SQL Table? 2

Top