MDE file update issue

[jamest85]

Hi:
After migrate mdb database to sql server, I have created .mde and installed in each user's pc.

My question is: if I modify .mdb file later, and re-create a new .mde from my pc, can I copy the .mde to each user? The main concern is: do you think those table links (tables from sql tables) will still work?(or I have to relink them manually?).

Thank you very much.

Jt

 

[SQL_Hell]

Hi,

I doubt you will have to re-link them, but will they work? that depends on what authentication method you are using and whether the users have access to those tables.

Best way is to try it and see