General discussion

Locked

Access97 Problem

By misterymoi ·
I am creating a database in Access97 and ran into a problem. The table I was working in had too many fields in it. So I decided to create a second table but I'm having problems connecting the two tables. The problem is that the whole database search fields & Queries uses this first table and I need to include it in linking the forms. Is there a way to link the 2 tables so that it acts as one? Or is there a way to increase table one fields so that I can just use the original table? HELP.....

This conversation is currently closed to new comments.

15 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access97 Problem

by xchen In reply to Access97 Problem

Since the whole database uses the first table for searching, it would be better to keep only the first table. To add more fields to the table, open the table in table design view, then add any fields you want. Note that you can only modify the tabledesign in the database where the table is defined, not in the database which provides a link to the table.

Collapse -

Access97 Problem

by misterymoi In reply to Access97 Problem

The question was auto-closed by TechRepublic

Collapse -

Access97 Problem

by garethreynolds In reply to Access97 Problem

If you join the tables in a one-to-one relationship (it would help if they have identical primary keys) selecting all fields from each then you can use the query pretty much as a table.

It's also worth checking that the tables have the smallest possible field sizes ie never use Double when you can use Long, and never use Long when you can use Integer

Collapse -

Access97 Problem

by misterymoi In reply to Access97 Problem

The question was auto-closed by TechRepublic

Collapse -

Access97 Problem

by jds In reply to Access97 Problem

First of all, do yourself a favor and get a good book on data normalization (I recomend: "Access 97 Developer's Handbook"
by Paul Litwin, and Ken Getz, it sells on Amazon for $48.)
MS Acces allows for 255 fields (as per the specs) in a table. I cannot foresee a good reason why one should need to know 255 things about an object without using one to many relationships at some point.
Again, my advice to you is to get a good book and take a bit more time to develop the data structure. It will take more time in the beginning and add some complexity, but the rewards reaped in the end will be worth it.
If that is not a viable option then take the previous writer's advice and add an identicle primary key to both tables and link themone-to-one. Make sure that the table that you really need the most is on the left side of that link so that it's record can exist without the other table's coresponding record.
Good luck, and happy programming.

Collapse -

Access97 Problem

by misterymoi In reply to Access97 Problem

The question was auto-closed by TechRepublic

Collapse -

Access97 Problem

by ralanis In reply to Access97 Problem

Yes, There is a way to connect two tables so they act as one. First, insert a new field in both of your tables with the Data Type of AutoNumber. Be sure to name your new fields with the same name. Then create a query and link your two tables withthe new field and bring down all the fields of your tables in the query grid. Now save your new query so you can use it in a form.

Good Luck...
ROA

Collapse -

Access97 Problem

by misterymoi In reply to Access97 Problem

The question was auto-closed by TechRepublic

Collapse -

Access97 Problem

by creative In reply to Access97 Problem

The infomation above is good. There is one more thing to think of though, if youo not need to search all the fields, you can have another table linked in, but not necesarily with all the records shown in the qry, rather, place the entire table in the qry by double clicing the * symbol in the table, this way all fields are available to you.

Creae a couple of queries to hold your data and pop them in where you need it.

Please note though - as stated above - if you need 255+ data fields, youprobably need to look into normalization in a big way...

Collapse -

Access97 Problem

by misterymoi In reply to Access97 Problem

The question was auto-closed by TechRepublic

Back to Web Development Forum
15 total posts (Page 1 of 2)   01 | 02   Next

Software Forums