Forum home » Delegate support and help forum » Microsoft Access Training and help » Updating tables

Updating tables

ResolvedVersion 2003

Mon 14 Jul 2008, 16:24 Delegate Neil said...

Neil has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Updating tables

how dcan I get users to update tables if they do not have access to access ie web or other form of front end

Mon 14 Jul 2008, 16:27 Trainer Pete said...

RE: updating tables

Hi Neil

Thank you for your post, welcome to the forum, I guess that is a difficulty which could be overcome by having your tables in Excel and then linking the Excel Tables to your Access Database.

I hope that helps, if so please click the resolved link, regards Pete

Wed 6 Aug 2008, 15:30 Delegate Neil said...

RE: updating tables

thanks

Training courses

98.6 % recommend us

More live stats...

Training information:

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Updating tables

Updating tables

RE: updating tables

RE: updating tables

Access articles

Access tip:

Prefixed Autonumbering