How do I keep an imported non-relational database intact?

[erikl1]

I have a simple non-relational database that has been following me quite a while and which I now have imported from Access 2003 to Access 2010. I want to keep the database non-relational (I am a conservative guy) since it has been working so well for me. However, the Access 2010 has analyzed my database during/after import and finds that the same information (e.g. store name) has been stored several times. The analysis comes up with a suggestion to split one table into several tables. In this particular case I do not like the suggestion. I want to keep my original and simple structure in one single non-relational database.



Is there any way to override the routine for the “simplification”?

[June7]

I never done this import. Does the import INSIST on splitting or is it an option you can reject?

Instead of import, can you just open the mdb in 2010 and let it convert to accdb or do a SaveAs?

[erikl1]

June7: I have tried your last suggestion. When I open my old file in 2010 everything initially look fine and promissing. The trouble starts when I initiate a query. Then Access INSIST on splitting my 1 table into 4 tables. If you want to see exactly how the problem develops I can send you the database.

[June7]

Yes, follow instructions at bottom of my post. Send the original mdb.

[erikl1]

The database opens as a query "Filter by form"

1. Enter the search criterion: Euro* in the Field "Forhandler"
2. Do the search by entering "Filter by form" (Alt T on my PC), and then "Apply Filter/sort" (B on my PC)

Try to enter these keystrokes. I am curious to learn what happens at your end.

[June7]

I've never worked with anything like this. The form and controls are bound. The form opens blank and input does not appear to be saved.

I can't get the ALT shortcut to work. Alt+T just opens a popup tip that instructs to continue typing the Office 2003 key sequence. I type B and nothing happens, Alt+B is same.

I right click and select Filter by form then click the Ribbon filter toggle and records filter.

No suggestion to split table. However, I am testing with Access 2007 now. Will open with 2010 later.

Tested with Access 2010. Got a warning message didn't see with 2007 "The command or action 'ClearGrid' isn't available now". Otherwise, same behavior as 2007.

[erikl1]

June7. I had a good relation to Access 2003, it is not so good with Access 2010. It seems like I have to start from the bottom. I don't know how much time I can spend. However, Access has been an important tool for me.

I have now two Microsoft books to guide me through the new version: "Step by Step Access 2010", and "Access 2010 Inside Out". The last one is absolutely impossible for a fast hands on guide, the first one is a bit slow.

The first thing I see when I open the "Step by Step" is "Modifying the Display of the Ribbon". There are 8 ribbon tabs. On version of Access 2010 there are 7 tabs. By inspecting the case in detail it seems like the "typical program window displayed" is from another application than Access (could perhaps be Excell). I get sceptical to a book with such a bad opening.

Do you have any recommandations for a compact and fast book?

[erikl1]

June7. I was too fast with my negative comment. The book is gooood. Have a nice weekend.