Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Hyperlink function in ms access

Hi, I need your help in using the hyperlink function i ms access database.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 48 Answers
Re: hyperlink function in ms access

To Create a Hyperlink Field:

Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.

Is this enough?

Posted on Dec 31, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Repair MS Access database without having program installed

Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more:

Oct 18, 2015 | Microsoft Office Business & Productivity...

7 Answers

MS Access database recovery

Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information:

If doesn't help, look here:

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-

1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

2 Answers

MS Access 2007 freezes when opening a basic TABLE. Please assist in resolving this frustrating problem.

You might try the "Compact and Repair" database option first before working on the database. Click on the "Office Button", then click on "Manage", then select "Compact and Repair Database". The usage dialog from there is straightforward. One that'srun, try opening the database again and opening the table as well.

Jul 15, 2009 | Microsoft Office Standard for PC

1 Answer


have to follow few steps.
1. new database - give any name
--> design table
e.g id, name and file (the datatype of the file should be hyperlink other wise it wont work)
--> enter some records (in file field write a, b ,c)
--> when you put record in file field then click on hyperlink option on top.. (like first record id=1, name=fahad, file=A) select the A and click on hyperlink option on top and give the hyperlink of the pdf file
--> design the form
--> run the form
--> click on desired file
--> it will open
--> looks complicated but its easy

it will work definitely

Mar 24, 2009 | Microsoft Access 2003 for PC

2 Answers

Steps in saving file in excel to database

severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer


You have not indicated what issue you are experiencing, and it is a bit of a guess as to your needs, as there is no one "MS Access driver". However, in an attempt to assist, the link here will take you to MDAC 2.8, which further links to it's SP1. This is a major component critical to Access functionality.
However, please be aware that versions of MDAC from 2.6 forward eliminated the Jet 4.0 database engine, which was a key element in Access 2003 and 2000. So, if you are using features and functions which require Jet, please see
I trust this will resolve your issue, and you will be able to rate this response as FixYa!

Apr 28, 2008 | Microsoft Office Professional 2007 Full...

1 Answer


ThinkDB2 is an easy to use database. Like most Palm databases it is based on MS Access, but no knowledge of Access is needed. ThinkDB allows you to design the Form, such as you see on the left, on the Palm itself. ThinkDB is freeware, but if you want to Sync to your Desktop and therefore to and from MS Access you need to download and pay for their Windows software. This ranges between $20 & $40 depending on which version you require.ThinkDB2 is 350Kb to download and takes 149Kb of room on the Palm. -- SOURCE

Although I couldn't find a 'manual,' I did find that you can get a list of functions in ThinkDB2: CLICK HERE.

Feb 19, 2008 | Business & Productivity Software

3 Answers

Viewing ms Sql Server database on Access

Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

3,077 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides