var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a MSDE database on 1 computer. I have an Access MDB file on the same computer which has table links to the MSDE database. Therefore, I have a SQL Server DSN on that computer.
Now, if I want to access that MDB file from a different computer on the network, it tells me that I need a DSN there as well.
Is there any way that I can do this without having to create a DSN on each workstation that will be accessing the MDB file?
No. Not that I'm aware of ... I don't think you can access a DSN setup on others PCs on a network.
You may be able to access the non-DSN linked tables through an ADO connection. This link may be of use:
All code ADO/ADOX unless otherwise specified.