If you change your Access databases into Access projects with SQL backends then all you do is set your SQL hyperlink field to a varchar in SQL.  In the form,...

I modified Jasons response above to solve this problem.  I added a seq number in the PC table and get the sequence number.  Then I did a join on the PC...

The 4 serial number fields are matches to the 4 part number fields.  So it also has PC_SubpartSN1, PC_SubpartSN2, PC_SubpartSN3, PC_SubpartSN4.  So the serial numbers have to match...

I believe the data for the DTS package is stored in the sysdtspackages table in the Binary field packagedata.  You would have to pull the data out of this field...

Another thing you can do is convert the database to an Access project, then all the tables will be stored in SQL and you can have SQL control the security. ...

Do you need to have the security on the Access database?  I have always controlled who has access to the database through network security.  We never had to get granular...

Have you gone into the ODBC data sources on the Server Access in on, and tested the connection?  Try this to make sure the connection is working.  Next go into...

Make sure you have rights to delete in SQL for the table you are looking at.  If you are looking at the table through Access, then you need to look...

PW,

That works great.  Thanks for the help.  Iv'e never come accross that situation before, so its nice to have a solution.

David

I have been using Access since 2.0.  I agree the mdb problems got realy bad with Access 97.  The bloating was a problem and also corruption.  I have migrated several...

I have had the title of DBA for a few years now, but am realy a developer/dba.  I started creating Access databases for the company, now I have converted them...

Ususally when you set up the DSN you should set the protocol to TCP/IP.  Are you using the SQLServer driver?