Unwanted fields

[baronvont]

I have converted a DB from access97 to 2000. Now I have 3 extra field in each table S_Guid, S_Generation and S_Lineage. I can hide them but they keep coming back? Can anyone please tell me how to get rid of them. Can I just delete them?

Thanks

 

[RickSpr]

I believe these fields support Replication. I'm not sure how to get rid of them, but I would start by trying to remove Replication--unless you're actually using it, of course, in which case don't delete these columns.

If you are using Replication, why is it a problem that these columns are visible? You're not exposing them to your users are you?

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[baronvont]

Well the users can't see them but they are a pain when I am working in tables. You are right is as much as they are a hangover from whem I had the tables replicated but they aren't any more. Don't know why the fields are visible tho?

I have found a fix by running a create-table query for each table without those fields & making a new set of tables.

Thankx for your input.