Front-End vs Back-End Question

[RainLover]

This is an old thread that I have been trying to find the time to write an answer.

The original question is located here.

http://www.access-programmers.co.uk/forums/showthread.php?t=272900

I started a new thread so as not to get confused with other people's posts. I first wrote this about 3 years ago with the help of ChrisO (RIP). The original concept was much broader than what I will eventually post.

I am using this thread to explain the workings of the new project. There are several files located in various locations. Some on the files are found on the user's machine and others are on the server.

Don't be surprised if something does not work at first. I will fix eventually.

PLEASE DO NOT post your thoughts on alternative methods. If you wish to do that then it would be better to go back to the original thread so as not to confuse.

 

[Ranman256]

I have a FE with some tables on the server, some on the users local PC.
The local files are in a folder EVERYONE has...like c:\import files
My front end will run a MKDIR to build it for them and/or copy the files to the folder.

NEVER store files in 'my documents' because everyone's 'my documents' is different.

 

[RainLover]

Ranman256

Thanks for the input. You may have missed it but I am trying to make this thread exclusive so that I can write my solution progressively as I develop it.

The original thread is still open if you would like to continue with that one.

The Address for the original is:

http://www.access-programmers.co.uk/...d.php?t=272900

 

[RainLover]

INSTALLATION PART ONE

Assuming I have completed writing and tested the database. Written in 2003.

For the CLIENT Create two separate folders.

C:\Roger
C:\RogerInstall

Place the Database front end "RogerFE.mde" and a Text file Token.txt under C:\Roger

You may prefer to use a .mdb version, however that would require changes to the code.

Place the Installation file "RogerInstall.mdb" Under C:\RogerInstallation.
Create a Shortcut to the Installation file "RogerInstall.mdb" and place that on the Desktop.

You can change things around like installing on a different drive however some code will need to be altered. Suggest you don't do this until you are comfortable with the original installation as outlined here.

 

[RainLover]

INSTALLATION PART TWO

It is better than a good Idea to make regular back ups.

Suggest something like a dozen or more an hour.

ChrisO wrote this.

D:\Shared Folder\AutoBackup.rar

Naturally this link will not work on your machine. You will need to download your own version.

More tomorrow.

 

[RainLover]

There may not be an update today.

Brisbane hits coldest temperature in 103 years | The Courier ...

I can't handle the cold.