Updating a table that has primary keys in it | Access forum

Resolved · Medium Priority · Version 2007

Wed 29 Jan 2014, 13:25 Delegate Martin said...

Martin has attended:
Access VBA course
SQL Server course

Updating a table that has primary keys in it

Hi,

I have a database with several tables in it each linked by not one but five (5) fields that form a primary key. The normal way of inputing data is via a form but I have 150 records to add and I have all the data in an excel spreadsheet so would like to do a bulk add and update.

All the data I want to add is to a single table that has all the keys contained within it. I have tried importing the data to the table and this works, in that I can see the additional data in the table. However, when I look at the data via the form I don't see the new records.

Any help would be much apreciated.

Regards

Martin

Fri 31 Jan 2014, 09:19 Trainer Doug said...

RE: Updating a table that has primary keys in it

Hi Martin

Sounds a bit of a puzzle. If the data gets imported into your table it should appear in your form. Would you be able to email your database to info@stl-training.co.uk ?

Best to zip the file and ask for it to be forwarded to me.
Thanks.

Regards
Doug Dunn
Best STL

Tue 18 Feb 2014, 13:51 Delegate Martin said...

RE: Updating a table that has primary keys in it

After several attempts I have managed to write an update query that not only updates the primary table but also its linked table that also has all five primary fields in it.

Little convoluted but can see why I needed to it this way.

A good learning session.

Thanks

Martin

Tue 18 Feb 2014, 16:58 Trainer Doug said...

RE: Updating a table that has primary keys in it

Well done.
Sounds like you have solved it!

Doug
Best STL

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips