Recent content by Cadius

Thank you very much for your responses, my apologies for the late reply but it has been a bit hectic at work. I very much like the thought of letting the code do the work and after reading various articles this is what I ended up with... Public Function LinkTbl() Dim sConnect As String...

In short, I have a MS Access DB using a single linked table from a SQL DB on our work server. I'm having trouble setting up the DNS correctly... I can open Access and view the table fine, however others on the network get some type of -obdc connection error. Both the SQL data table and...