Can I link tables from a secure back end?

  • Thread starter Thread starter HLCruz via AccessMonster.com
  • Start date Start date
H

HLCruz via AccessMonster.com

I created a database that I have secured and then split to a FE & BE. I did
this so I could roll out versions of our database while staff continue to
work in it. It's worked great up until today, when I needed to add a new
table to my back end and link it to a front end copy that will replace the
current version. This is a pretty typical occurence in my design plan.
However I can't seem to figure out how to link the table - I obviously can't
select the file from my network drive because it's secure ... is there a way
to get around this?

Thanks to anyone who has some advice!!

Heather
 
Please disregard this! I must have been experiencing a glitch when I tried
to link the first time - now I'm able! No need to reply
 
You'll need to wait for a time when no one is using the database. Then you can open the backend, logging in as the appropriate user, and add the table. I suggest you then compact the backend. Then open your copy of the FE, and use File Get External Data, Link Table and link to the new table in the BE.

Once your copy of the FE is set up correctly, you can then copy this revised FE to all the users. You can automate the updating of the FE to users. Tony Toews has a utility and webpage about this.
http://www.granite.ab.ca/access/autofe.htm
 
Thanks Joan, your advice is greatly appreciated. I will definately refer the
link you gave when I'm ready to update my FE!

Joan said:
You'll need to wait for a time when no one is using the database. Then you can open the backend, logging in as the appropriate user, and add the table. I suggest you then compact the backend. Then open your copy of the FE, and use File Get External Data, Link Table and link to the new table in the BE.

Once your copy of the FE is set up correctly, you can then copy this revised FE to all the users. You can automate the updating of the FE to users. Tony Toews has a utility and webpage about this.
http://www.granite.ab.ca/access/autofe.htm
I created a database that I have secured and then split to a FE & BE. I did
this so I could roll out versions of our database while staff continue to
Click to expand...
[quoted text clipped - 8 lines]
Heather
Click to expand...
Click to expand...
 
Back
Top