Linking/refreshing Back-end with front-end

[rehanemis]

Hello,

I have Access DB with Front-end and Back-end. I want to trying to run the front-end on client computer on Local Network(the client has only the Access Runtime installed). I am facing the problem to link with back-end.

Please see attachment.

Any advice or solution?

Thanks

 

[NauticalGent]

At first glance it appears your FE is looking for the BE on the local "C:" drive when it appears to me on the "T:" drive.

You would need to relink them as such...also I strongly suggest using the UNC method for assigned the BE and not virtual drives.

 

[rehanemis]

Thanks for your reply.

Can you please tell me about UNC method.

 

[NauticalGent]

Sure, it's using the actual path vice a virtual drive. In your case it looks like it would be
\\COLINDALE\FCI Database\...
vice
T:\FCI Database\...

This will save your users some frustration if they happen to assign a drive other than T to the back end.

 

[rehanemis]

So I have to keep the front-end and back-end in "COLINDALE" computer network.

Thanks for your guidelines and patience as i am not expert person.

I also want that user can only access to front-end as the back-end is not secure or password protected.

 

[NauticalGent]

So I have to keep the front-end and back-end in "COLINDALE" computer network.

Thanks for your guidelines and patience as i am not expert person.

I also want that user can only access to front-end as the back-end is not secure or password protected.

Not sure if I understand you correctly, but if users are using the same front end on a shared drive, you are asking for a heap of trouble. Every user should have their own front end, preferably on a local drive, that links to the back end.

If you are unsure of what I am talking about, there are many threads on this forum that can walk you through the Split database routine.

Anything I can do,to help get you started, let me know...

 

[rehanemis]

Thanks.

I will keep the files on specific folder as you told and will let you know tomorrow. If I need further assistance then will post you message.

thanks a lot for your kind help.

 

[rehanemis]

Much thanks it works when the files on the server computer instead of Virtual drives.

Again thanks

 

[NauticalGent]

Good to hear it worked out, best of luck!