ACCESS FEED

Rabu, 19 Januari 2022

Re: [MSAccessProfessionals] ReLink procedures

Relationships are in the back so they shouldn't be affected. I recall there is a checkbox that forces changing the links to the original or at least a different back from the current. This should be the same as when you prepare for vacation.

No Zwift for me at the moment. I'm using the free RGT but it's not as engaging :-(

Duane

Sent from my mobile

On Jan 19, 2022, at 12:31 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

I tried Relink and have 4 tables that said "Table's relationships will be deleted before relink. Do you want to continue?"

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, January 19, 2022 12:06 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] ReLink procedures

Bill,

Simple, don't take work on vacation! Take your bike.

Do you edit data in the back-end? Does anyone else edit data while you are on vacation? Have you considered having a PC set up at work that you can remote into? If you simply make changes to the front-end, you should be able to use the linked table manager to connect to the work back-end.

Duane

Sent from my mobile

On Jan 19, 2022, at 11:11 AM, Bill Singer <Bill.Singer@at-group.net> wrote:

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

Re: [MSAccessProfessionals] ReLink procedures

After reading, I see how to set up remoted desktop but I am not sure how to make it secure at this point. I will keep working on it.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, January 19, 2022 12:06 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] ReLink procedures

Bill,

Simple, don't take work on vacation! Take your bike.

Do you edit data in the back-end? Does anyone else edit data while you are on vacation? Have you considered having a PC set up at work that you can remote into? If you simply make changes to the front-end, you should be able to use the linked table manager to connect to the work back-end.

Duane

Sent from my mobile

On Jan 19, 2022, at 11:11 AM, Bill Singer <Bill.Singer@at-group.net> wrote:

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

Re: [MSAccessProfessionals] ReLink procedures

I tried Relink and have 4 tables that said "Table's relationships will be deleted before relink. Do you want to continue?"

Bill

Bill Singer

Bill,

Simple, don't take work on vacation! Take your bike.

Duane

Sent from my mobile

On Jan 19, 2022, at 11:11 AM, Bill Singer <Bill.Singer@at-group.net> wrote:

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

Re: [MSAccessProfessionals] ReLink procedures

Duane,

Yes, I wish it was a biking vacation. It would be much more fun than Zwift.

I use the database for reference. I don't edit the date because it doesn't save on the master copy. I wish I could but ….

Yes, other people use the database while I am gone.

I would like to be able to set up that I can remote into. I have Windows 11 professional so I think it is possible, but I do not know how.

When I open the front end and go to the linked table manager I see the data source name and data source information pointing to the location of the original back end.

What next? Do I relink or Add. When I add, I get duplicate tables. I just tried to relink and it is going through the tables one at a time.

Any tips on setting up Remote PC.

Bill

Bill Singer

Bill,

Simple, don't take work on vacation! Take your bike.

Duane

Sent from my mobile

On Jan 19, 2022, at 11:11 AM, Bill Singer <Bill.Singer@at-group.net> wrote:

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

Re: [MSAccessProfessionals] ReLink procedures

Bill,

Simple, don't take work on vacation! Take your bike.

Duane

Sent from my mobile

On Jan 19, 2022, at 11:11 AM, Bill Singer <Bill.Singer@at-group.net> wrote:

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

[MSAccessProfessionals] ReLink procedures

Periodically I take a copy of my front end and back end and put them on a laptop computer so I can take my work with me on vacation.

I continue to struggle with the proper procedure to re-link the two data bases on the new computer. I seem to end up with duplicate tables every time and have to go through and delete and rename.

Bill Singer

Re: [MSAccessProfessionals] Error 70 permission denied

Duane,
Thanks, I solved the issue by adding me.refresh after me.allowedits.
The form has a lot of code and subforms,

Norbert

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_