Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

Posted on Aug 26, 2008

Autonumber help in Ms Access 2003

I have a primary key called Employee_Id as aotunumber i want it as E001
in which 001 should be automatically incremented
& so on. I am using MS Access 2003. Please help

1 Answer

A

Anonymous

You cannot store the E in the autonumber field, but you can make the data look that way. Therefore, use the following format for the Employee_Id column:
\E000

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1helpful
8answers

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 .

Or:
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: http://access.erepairtools.com/

If doesn't help, look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/933-ms-access-database-recovery
1helpful
1answer

How can i download ms access 2003?

Hi Mariano

MS ACCESS 2003 DOWNLOAD

Full, genuine, licensed versions of Microsoft Products cannot usually be downloaded.

Microsoft have withdrawn downloads and direct sales of MS Office 2003 applicationss, including MS Access 2003, the only remaining support services being updates and security patches during Automatic Updates.

Here are some constructive, useful, helpful, practical options to consider instead.

One option is to download MS Office 2010 Pro 60-Day Trial and install it, carefully following each step:

Go to:
http://office.microsoft.com/en-us/try


If you do not want to buy or cannot afford a full, licensed copy of MS Access 2003 and/or prefer to pursue the downloading option, consider the latest version of genuine, similar free comprehensive Office Suite applications - OpenOffice and LibreOffice- downloadable free, from their original source, at:


www.openoffice.org


http://www.libreoffice.org/


You can use OpenOffice and LibreOffice simultaneously with MS Office 2010 Pro 60-Day Trial. If you delete MS Office 2010 Pro 60-Day Trial, well before the 60 day expiry date, and Remove all components of it from Add or Remove Programs (or its equivalent in your Operating System) and Restart before downloading and installing it again, it is usually possible to enter into further 60 Day trial periods.


If you are determined to continue using the full version of MS Access 2003, then you will have to purchase a full, genuine, unused and licensed copy of the software from a reputable, reliable supplier, such as Amazon:


(www.amazon.com)


Online offers of Free Downloads of MS Office products are probably almost universally either not genuine, illegal, unlicensed or pre-used licence versions, downloadable only from illicit download sites or sites that are masquerading non-existent MS Office products as camouflage for the marketing of other (often unrelated) software, products or services. Even if you do succeed in finding a Product ID or download site that seems to work for MS Access 2003, you will still have to purchase a separate, genuine, unused Activation Code for the product before you can successfully install it, use it with confidence, register it, activate it and download and benefit from Updates and Security Patches for it from Microsoft.


I hope this helps.


If this Answer goes some way towards helping to resolve your Query, Problem or Fault, please take the time to Rate it. Doing so helps Solution Providers, like me, better understand the needs and the point of view of Askers, like you, and guides us in exploring the best ways to provide the most comprehensive, useful and high quality Responses and Solutions we can. If you need further help, please do not hesitate to post another Question or add a Comment to this Question.

Thanks for using FixYa.

0helpful
4answers

Query About Access Database

Is your ODBC driver set for this database in the control panel as well?

Just checking............
0helpful
1answer

MS access 2003 problem

I do not know the pogramme in MS access I know the simple course of MS Access.Please kindly send me full verson of MS Access programme course in my mail Id
[email protected]
1helpful
1answer

How many primary keys in MS.Access

No, there cannot be two primary keys in one table. You can specify more than one value to make up the primary key. For example, instead of just the last name column - you can have the last name and employee ID fields make up the primary key. If you don't specify a primary key, MS Access will usually ask you if you would like them to create it for you. You may be thinking about foreign keys. A table can have two or more primary keys in them but they would serve as foreign keys. For example - lets say you have table A with primary key "A" and table B with primary key "B". You can create table C and have both primary keys from tables A & B in it, however, they would be foreign keys in table C and not primary keys (they are only primary keys in their respective tables).
Not finding what you are looking for?

123 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...