Replies

Well, maybe not necessarily ‘archived’, as used in that context, but taking me to another eventual desire, I’d like the database to be backed up at least once a day without manually having to do so, because often times the other database custodians working on it (from the 5 companies) will turn off their computer without closing the program, or do some other funky stuff like trying to delete the lockfile, causing the database to ‘crash’, and it is unable to repair itself. If I could keep, say, a day old snapshot of the database until the next day comes…that would be perfect. I just want to be able to not worry about recreating all the changes that occur throughout the day if the last time I manually backed it up was sometime last week. Then I must try to recreate all the changes that occurred….it’s truly a royal pain…thanks for your help!

The fields are for personal information pertaining to each individual Marine, (blood type, addresses, etc….). I understand that having multiple tables is possible, but if I’m using queries to filter the info, do you suggest I still make separate tables? Is there anything negative about having so many columns?

The fields are for personal information pertaining to each individual Marine, (blood type, addresses, etc….). I understand that having multiple tables is possible, but if I’m using queries to filter the info, do you suggest I still make separate tables? Is there anything negative about having so many columns?

What do you mean by knowing the structure? Right now it’s about as basic as possible, with very few variables, except of course dates and addresses. As of now, we just use queries to pick the info we want to update. On a slightly related note, is there a way to import data from an excel document into access tables linking by SSN? or even importing the excel document into access as a table and then moving the data?

What do you mean by knowing the structure? Right now it’s about as basic as possible, with very few variables, except of course dates and addresses. As of now, we just use queries to pick the info we want to update. On a slightly related note, is there a way to import data from an excel document into access tables linking by SSN? or even importing the excel document into access as a table and then moving the data?

I’d like to take a shot at this…if I’m undermining your intelligence or anything of the sort that is NOT my intention…..

Have you made sure that your input fields in your form are linked to the columns/fields you want to enter the data into? If you’re using separate tables (I.E. a separate table for things such as address, one for Christian names, etc.) and you’re inputting the data in the same form, you need to have some sort of common denominator between them for access to recognize them as belonging to the same person (primary key, social security number, etc)…something different for all. With that primary key, Access can then know to export the info from your form into specific columns throughout your tables.

That’s how I’d start with it…but I consider myself a beginner user and I’m posting not only to try to help, but also for my own knowledge….

I’d like to take a shot at this…if I’m undermining your intelligence or anything of the sort that is NOT my intention…..

Have you made sure that your input fields in your form are linked to the columns/fields you want to enter the data into? If you’re using separate tables (I.E. a separate table for things such as address, one for Christian names, etc.) and you’re inputting the data in the same form, you need to have some sort of common denominator between them for access to recognize them as belonging to the same person (primary key, social security number, etc)…something different for all. With that primary key, Access can then know to export the info from your form into specific columns throughout your tables.

That’s how I’d start with it…but I consider myself a beginner user and I’m posting not only to try to help, but also for my own knowledge….