New Table/New Field

[D Pavlichek]

Hello all -

I have recently taken over maintaining a database that
grew larger than anyone expected. Recently we made some
operational changes that resulted in new requirements for
the database.

Currently, the database is set up with almost everything
in table "Sheet1" (are you getting how simple they made
this thing??). I added a table called "FamCodes", for a
new field that will be added to the current records. I
edited "Sheet1" to add this field with a lookup column
pointing to "FamCodes".

1) The switchboard has gone belly up on me and subsequent
attempts to rework it have been unsuccessful. I am not an
Access expert, so I have been referring to the unhelpful
help text and a book I picked up. No luck.

2) The queries now come back with no data. Queries that
were working prior to the added table and field now come
back empty. We have not reworked the queries to pull the
new field information.

Any ideas? Thanks in advance for your help...DP

 

[Tim Ferguson]

Currently, the database is set up with almost everything
in table "Sheet1" (are you getting how simple they made
this thing??).

Actually, I am getting that this was put together by someone who knew more
about spreadsheets than databases. And that usually means trouble down the
line :-(

I added a table called "FamCodes", for a
new field that will be added to the current records. I
edited "Sheet1" to add this field with a lookup column
pointing to "FamCodes".

This should go alright, but bear in mind that the ill-advised LookUp Field
datatype Wizard is a measly old soul who does his best to upset and
undermine new users. As long as you understand what fields contain what
data, though, things still should be okay.

1) The switchboard has gone belly up on me and subsequent
attempts to rework it have been unsuccessful.

Can't see any obvious reason why, but without knowing more about what the
switchboard is trying to call and open, it's not possible to guess. I think
you need to the database itself working properly first.

2) The queries now come back with no data. Queries that
were working prior to the added table and field now come
back empty. We have not reworked the queries to pull the
new field information.

You might need to post more details of the table and the queries.

A general rule is there comes a point where "growing beyond expectations"
and "operational changes" and "new requirements" mean "starting over from
scratch". And this time you might get someone who understands things at a
deeper level than "Sheet1"... <g>

All the best


Tim F

 

[John Vinson]

Currently, the database is set up with almost everything
in table "Sheet1" (are you getting how simple they made
this thing??). I added a table called "FamCodes", for a
new field that will be added to the current records. I
edited "Sheet1" to add this field with a lookup column
pointing to "FamCodes".

It sounds like you've created a query joining your spreadsheet to this
new table, and that it's returning no records. If so please open the
query in SQL view and post the SQL code here. It may be something as
simple as there being no matching records between the tables, or the
join type might be wrong, or... but seeing the query itself will help.