Deleting specific fields from 'Northwind template by Microsoft Office'

[sufian.naeem]

Ive been trying to customize Northwind template as per my requirements... but I fail to do so...



this is what i get...

i know its interlinked... so i want to remove all the links and vanish this field... please help . . .



ask for further details if needed...

[June7]

What happens if you respond Yes?

Delete the calculated field first.

If you delete fields, will have to modify queries, forms, reports, code.

[sufian.naeem]

than U gotta tell Me the whole way step by step please...

What happens if you respond Yes?

Delete the calculated field first.

If you delete fields, will have to modify queries, forms, reports, code.

[June7]

Step by step for what?

Open table in design view and delete what you need to delete.

Then go find every use of the deleted fields in the database design and change what needs to be changed.

Does Northwind have relationships defined in Relationship Builder? Better just delete everything from the Builder first.

If you miss something, the database will probably let you know when it crashes.

I use Rick Fisher's Find & Replace For Access to find stuff. It is a 3rd-part add-in that costs about $50.

[sufian.naeem]

First thing is... it doesn't have a design view...just a layout or form view...

Step by step for what?

Open table in design view and delete what you need to delete.

Then go find every use of the deleted fields in the database design and change what needs to be changed.

Does Northwind have relationships defined in Relationship Builder? Better just delete everything from the Builder first.

If you miss something, the database will probably let you know when it crashes.

I use Rick Fisher's Find & Replace For Access to find stuff. It is a 3rd-part add-in that costs about $50.

[June7]

This is the web version? Do you need web database?

[sufian.naeem]

it is a web version...
for me...web database or other... doesnt really matter . . .

[June7]

Web database does not have Design view for web objects. All editing must be done in Layout view through the ribbon tabs. There are other limitations with web database. If you don't need web db then get the non-web version. There are several variations of 'Northwind'.

Northwind Traders (Desktop Product Inventory database)
Northwind Services (Desktop Services template)

I don't know about Access 2013, but in 2010 these variations are available for download: File > New > Small Business

[sufian.naeem]

Found the databse You told about...
Now I want the data thats already in the template to become blank... so I can start adding My own . . .
how? ? ?

Web database does not have Design view for web objects. All editing must be done in Layout view through the ribbon tabs. There are other limitations with web database. If you don't need web db then get the non-web version. There are several variations of 'Northwind'.

Northwind Traders (Desktop Product Inventory database)
Northwind Services (Desktop Services template)

I don't know about Access 2013, but in 2010 these variations are available for download: File > New > Small Business

[June7]

Delete records.

[sufian.naeem]

but how?

Delete records.

[June7]

Can you see the tables in the Navigation pane? Are relationships established in the Relationship builder? Are Enforce Relational Integrity, Cascade Update, Cascade Delete all set to yes?

Go to each table and select records then click Delete.

[sufian.naeem]

Its getting really frustrated... I cant get what Ure saying. . .

Can you see the tables in the Navigation pane? Are relationships established in the Relationship builder? Are Enforce Relational Integrity, Cascade Update, Cascade Delete all set to yes?

Go to each table and select records then click Delete.

[June7]

What specifically do you not understand?

Do you know what the navigation pane is?

Do you know how to create/modify tables?

Do you know how to delete records?

These are all basic Access functionality.

Crud! I just downloaded those two databases and they are both really web databases, not just desktop versions. Use this source instead http://office.microsoft.com/en-us/te...rthwind&av=all

[sufian.naeem]

I do know about the navigation pane...
Dont really know bout Creating/Modifying tables... and deleting records...
Sorry. . .

What specifically do you not understand?

Do you know what the navigation pane is?

Do you know how to create/modify tables?

Do you know how to delete records?

These are all basic Access functionality.

Crud! I just downloaded those two databases and they are both really web databases, not just desktop versions. Use this source instead http://office.microsoft.com/en-us/te...rthwind&av=all