Front and Back End Database

jump25a

New Member
Joined
Mar 2, 2011
Messages
17
When updating a front end database what needs to happen to cause a update on another front end database?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
what do you mean by updating ?

do you mean changing the data in the tables ?

or do you mean changing the appearance of the data entry screens ?

or something different ?
 
Upvote 0
If you are updating a query, form, or report (and not the data) on a front-end that you would like everyone to have, you will have to re-distribute the front-end to your user group.

Here is how I make sure everyone has the latest copy automatically at my office.

I keep a copy of my current front-end on the network, with a version number on it (with each update, I update the version number). I then created a batch file on the network that copies the front-end over to their hard-drive, and then launches it from there. Actually, the batch file checks to see if they already have the latest version on their hard-drive. If it does not, it copies it over then opens it up. Otherwise it just opens it up on the hard-drive. I then place a shortcut to the batch file on their desktops, and this is what they use to open the database.

So whenever I do an update, I just need to update the version number on the front-end database name, and update that version number in my batch file.

A co-worker does something similar, but a little easier. His batch file just copies the front-end database from the network over to their hard-drive every time and opens it up. That way, you don't need to worry about maintain version numbers.

As long as the users only open the database using the batch file shortcut we put on their desktops, it works pretty seemlessly.
 
Upvote 0
Changing the data in the tables. I can't figure out what a change is based on.
If your databases are properly split and all linked to the same back-end, any change in data on one should be reflected in all, since all data should reside on the back-end database.
 
Upvote 0
As soon as whoever makes the change moves off the record that was changed, the changes should take affect (and cane be seen by others).
 
Upvote 0

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top