Access 2003 to SQL Server 2005 Express no hyperlink

I upgraded an Access 2003 database to SQL Server 2005 Express with the upsize wizard- worked great! Have a field that needs to be a hyperlink data type. There is no datatype in SQL that is hyperlink. Even if it were a text field, possibly inserting a hyperlink would work, but the insert hyplink in Access is unavailable, because the datasource is sql, maybe. I have a command button that ties to this function which won't work, obviously since it is not available. I need this field, it points to a file containing data that is being imported into the database. Huge piece of the database functionality. Making it easy for the user to find the file and using the vba to convert the data.

Saw the option of jump to url, but I don't think that will work? couldn't find the exact syntax either.

Any ideas would be greatly appreciated!

Robin

I guess you are talking about two different things, the database engine upgrade and the reporting upgrade. Which one is making your problems ? If I am wrong, please let me know, that we can help you fast with your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Sorry, I didn't see it as two different things...didn't even realize I was talking about a reporting upgrade? I have a sql server 2005 backend - so the fields are in that database....I refer to all of those fields in the Access 2003 database and I need one of those fields to be a hyperlink field....it was a hyperlink field when the data was in Access and I need it to be a hyperlink field now. There must be a way to keep that consistency,right?

Thanks for your input....sorry if it was misinterpreted about what was going on.

Robin

|||

There is no SQL Server equivalent to the Hyperlink field in Access, you will need to code a solution for following hyperlinks directly in your application. If your application is still in Access, you should explore the FollowHyperlink function. If you are moving to a Windows Forms application, you should check out the DataGridView, specifically the DataGridViewLinkColumns Namespace and the DataGridView.CellContentClick event to handle following the hyperlink.

As far as storing the hyperlink, I would suggest just using an nvarchar.

Mike

|||

Mike, thanks for responding to my dilemma. I am going to keep the front end in Access so I'll check out the followhyperlink function. It was great with the insert hyperlink dialog box, but we'll have to work around that.

I'd also like to add, I've looked at a number of threads on this site and appreciate your input - you are to the point, explain things very well and make sure the person you are addressing gets the point. I was hoping you would respond to my issue because I knew you would answer it correctly.

Thanks again!

Take care

Robin

|||

Mike, sorry to pick this up again, but is there any way for a user to easily find a file to insert into a field that is from a sql server be. I want them to be able to point to a file and have it copied into a field, insert hyperlink did it well. The field tells the database where to find a file\which file that is going to be imported into the database. Perhaps there is a more direct way in sql using the access front end?

Thanks!

Robin