473,394 Members | 1,752 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Updating Database

I have a database that is being shared on the network. The database it
split up into front end and back end. The back end is residing on the
shared network drive while the front end is on each local pc and just
linked to the back end. All that's contained in the front end are forms
with combo boxes and text boxes that is used for data entry. Is there
a way to code or create a macro to update all the front ends on each
local computer when a new form is added to the front end versus having
to make a copy of it to each pc and overwriting the previous version
that was there. Thanks in advance for any insights and help.

Apr 20 '06 #1
5 1353
HJ
The easiest way that I know, is to place your new version on a shared
network drive and to have your login script copy this version to the local
pc. That way you do not have to copy the front end to each pc yourself and
each user has the new version when they log on to the network.

Another, not so user friendly, way is to send your users an e-mail with a
link to a batch file on a shared network drive. The batch file then performs
the copy.

You may also use Group Policy, but that's a more extensive story than these
simple scripting options.

HTH,

HJ

<fo*******@martecgroup.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I have a database that is being shared on the network. The database it
split up into front end and back end. The back end is residing on the
shared network drive while the front end is on each local pc and just
linked to the back end. All that's contained in the front end are forms
with combo boxes and text boxes that is used for data entry. Is there
a way to code or create a macro to update all the front ends on each
local computer when a new form is added to the front end versus having
to make a copy of it to each pc and overwriting the previous version
that was there. Thanks in advance for any insights and help.

Apr 20 '06 #2

Try Tony Toews' Auto FE Updater

www.granite.ab.ca/access/autofe.htm

It works like a charm

Jim Devenish

*** Sent via Developersdex http://www.developersdex.com ***
Apr 20 '06 #3
Check out Tony Toews' auto FE updater, at
http://www.granite.ab.ca/access/autofe.htm.

<fo*******@martecgroup.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I have a database that is being shared on the network. The database it
split up into front end and back end. The back end is residing on the
shared network drive while the front end is on each local pc and just
linked to the back end. All that's contained in the front end are forms
with combo boxes and text boxes that is used for data entry. Is there
a way to code or create a macro to update all the front ends on each
local computer when a new form is added to the front end versus having
to make a copy of it to each pc and overwriting the previous version
that was there. Thanks in advance for any insights and help.

Apr 20 '06 #4
tony knows a lot more about this than I do, so read the article on his
website...

http://www.granite.ab.ca/access/autofe.htm

Apr 20 '06 #5
Thanks guys and Tony. I was able to download the fe updater and got it
to work.

Apr 21 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Jason | last post by:
Let's say I have an html form with 20 or 30 fields in it. The form submits the fields via POST to a php page which updates a table in a database with the $_POST vars. Which makes more sense? ...
1
by: gaosul | last post by:
I am non-programming scientist and I am using a Program called Easyarticles from Synaptosoft Inc., which is based the database program Access. Unfortunately, the owner of this company has...
3
by: Bucko | last post by:
How important do you guys feel locking a database is while updating/adding information? Do you do it with every app you make? Only very high volume (traffic) apps? I'm trying to decide if my app...
5
by: junglist | last post by:
Hi guys, I've been trying to implement an editable datagrid and i have been succesful up to the point where i can update my datagrid row by row. However what used to happen was that once i updated...
1
by: Luis Esteban Valencia | last post by:
Hello Everyone, Iam an intermediate ASP.Net programmer and iam facing a challenging task. I have a table in MS-SQL server database called 'Members'. The table has following fields... ...
3
by: | last post by:
Hello, I have created an ASP.NET 2.0 application that utilized a Gridview Control to display and update/delete data. The problem I am having is that the gridview control is displaying the data...
10
by: jaYPee | last post by:
does anyone experienced slowness when updating a dataset using AcceptChanges? when calling this code it takes many seconds to update the database SqlDataAdapter1.Update(DsStudentCourse1)...
2
by: Alexey.Murin | last post by:
The application we are developing uses MS Access 2003 database (with help of ADO). We have noticed that during massive records updating the size of the mdb file increases dramatically (from 3-4 to...
4
by: Geoff | last post by:
Hi I'm hoping somebody can help me with the following problem that has occurred to me. Suppose I have two tables in an SQL Server database. Let's call these tables A and B. Assume that A has...
1
by: jonbartlam | last post by:
Hi There I'm not sure what exactly is going wrong here. I'm writing an application that retreives a table from a database (tbl_internalfaults) and updates it. (Actually, just the status column will...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.