Hi There,

Run visual Studio and open the Server Explorer window.

Select Add Connection

Select Microsoft SQL Server Client

Select the running Server instance from the drop down box. Click Refresh...

Hi,

An Access image is an OLE object and these carry some header data. The link below describes in detail how to extract the image from an OLE object. ...

Hi There,

Could you clarify your request? For example, are you trying to import a single image into SQL Server or do you want to import an access table into...

Humble Apologies,

Many thanks for the heads up on that one. I was unaware that current time was used in generating the hash.

Hi,

If all you are doing is comparing passwords you will not need to decrypt anything. Simply encrypt the supplied password and compare it with the password stored in your...

Hi,

I have solved the problem. The error is generated when I add a linked server but fail to add my Management Studio user name as a local log in....

Hi Eric,

The Workbook (spreadsheet) Open event occurs when the workbook (spreadsheet) is opened. So all you need to do is open the Excel file. If Excel is installed on...

Hi Eric,

I have only just seen this post and I am not entirely sure that I understand your requirements but:

There is an event associated with the opening of a workbook...

Chirag,

I am sorry I can't help with the timings but I see that you are using a client side cursor.  This suggests that you are draggging data down the line and...

Hi,

I suggest that you use the version of Crystal Reports that comes with Visual Studio 2003.  This can generate a report using data from a datasource such as SQL Server and...

Hi,

You are going to get this error because you are attempting to instantiate an object that is different from the one that you declared.

You entered:

Touchpos_SQL_serverDataSet.Transaction_HeaderRow Row = new Touchpos_SQL_serverDataSet.Transaction_HeaderDataTable();

Perhaps you...

You can also link the Informix DBMS.  This may be the better option if you will be regularly importing data.  It allows you to query the Informix data directly from...

As I recall, you have to create a system DSN.  Then when you select add new linked server, you specify Microsoft Oledb Provider for Odbc drivers.

You can stick anything you like into the product...

Rich,

I just tried linking the MySql database from Access 2002 SP3 and that worked fine too.

I wish I could be of more help!

Shaun

Rich,

I have just noticed that we now actually have version 5.n of MySql rather than version 4.n.  It might be worth making a test installation and seeing if that works.

regards

Shaun