Software

Ask something
Question Locked

Update table in BE database

0 helpful
6 replies

by sabine.nelis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Hope that somebody can help me.
Have split my database into BE and FE. Users now want an extra field in a table.
Inserted this field in the table in the BE and refreshed the link between the BE and FE, but the extra field doesn't appear. Does somebody know how to do this?

Sabine

6 replies

by ben.rattigan

Is this Access? which version.

Is everyone using the same Front End file from a shared location or do they all have a copy of the FE stored locally?

If they are all stored locally then have you updated link tables in them all?

Check the path that is displayed for that table in the Linked Table Manager and make sure its the correct BE version you have updated, if you have multiple versions.

You could also try removing the linked tables and recreating them again.

by sabine.nelis

Sorry,

Yes it is. I'm working in access 2007 with file format 2002-2003. I have one BE and multiple FE stored locally. So I made some modifications to a table in the BE and checked it in one of the FE (My test version). And there i don't see the modifications, even when i recreate the table links. (It is the correct path to my only BE)

Don't know why. When I make in another mdb file, that has not been splitted and has no security, a table link with an excel table it works fine.

Can the security be a problem. I've already checked the permissions and I have administer rights on all tables.

Hopes you have a clue.

Sabine

by ben.rattigan

or did you manually split them by creating a copy and creating the links yourself?

Have you refreshed all tables using the Linked Table Manager?

Are you looking a the design view of the linked table in the front end?

It is unlikely to be a security problem if you created Access file and split it. Have out applied any of the security wizards in Access or protected it with encrypted password? You could check your macro security levels.

The other option is to create a new BE database file and import the tables and relink the FE to the new file.

by sabine.nelis

hi,

I manually split it, because i've read somewhere thats the best way.
I've tried out the other option (create a new databse and import the tables) and now it works. Strange, don't understand it, but i'm glad it works.

Thanks for your help.

Sabineke

This discussion is closed to new replies.