Recent content by kreskin

Sorry for the confusion, I seem to get another error now. I looked it up and it seems to be an 'access denied' error. I tried my own login, with domain and everything, but to no avail... SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data...

Sorry I split this in two posts... Running SELECT a.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', '\\Rfax\FaxRpt\Reports\Rfax.mdb';'admin';'', Faxes) AS a GO or SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\Rfax\FaxRpt2\Reports\Rfax.mdb"; User...

Hello, Thanks for a quick reply. I ran the following in SQL Query analyser: exec sp_addlinkedserver @server = 'Rfax1', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet', @datasrc = '\\Rfax\FaxRpt\Reports\Rfax.mdb' It successfully created the link. However...

Hello. I'm trying to create a stored procedure which would compare an ID from external MS-Access table with an ID in a table within SQL and succeed or fail based on their comparison. Is there a way to do it using T-SQL, something like select @var = max(ID) from \\server\database.mdb\tablename...

Thank you vongrunt. I've used your code and it works well.

It works now. Here it is: function displ(that, id) { if (that.src=="http://localhost/folder/images/blackD.gif") //click on down, show table { window.document.getElementById(id).style.display='block'; up(that); } else { window.document.getElementById(id).style.display='none'...

Hi. Thanks for the two tips. As for the src, it actually works fine. I checked it with alert and, even though it displays the full path, changing src to /images/smthelse would automatically append the path. The error is still showing...

Hello. I m trying to create an expand/hide button. It would be an image that, when clicked, would either expand or hide a table and change the img src from arrow-up to arrow-down or vice versa. I'm getting an "object expected" error in the following code: <script type="javascript"> function...