473,498 Members | 1,793 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to Update a Database time to time ??

8 New Member
I have Developed a Small Business Inventory System for my own business, But the system is not complete i have made progress halfway and i use that system at my business to do Data Entry so i wont loose any of my current data...

My Problem is : i do changes and modification to my Database in my resident but i am currently using that in my work place.

i need a way to update the database that i use in my workplace protecting its data with new changes that i have made to the database??
Jun 21 '20 #1
1 1910
NeoPa
32,557 Recognized Expert Moderator MVP
That's an easy one. See Front-End / Back-End (FE/BE).

If ever you change the data/table design then this will need to be handled appropriately, but generally speaking, keep the data separate and releasing new versions should be simple & straightforward.
Jun 21 '20 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
5928
by: Emmett Power | last post by:
Hi, I have a small online survey in two parts designed to allow users to rank a few organisations that they have dealings with from a large list of organisations. I want the users to be able to...
1
3931
by: Fie Fie Niles | last post by:
I have IIS installed on XP Professional workstation machine. I have an ASP page that open connection to an Access database, then when trying to update the database, it gave me the error "cannot...
0
1324
by: iwebgi | last post by:
I have an asp:textbox that has "mm/yyyy" as a string. I like to covert the string to a date format and update converted date to the database and append the current time to it in US format. So if i...
1
1702
by: Mike Hnatt | last post by:
I'm baffled. My data store (database) is not updating with a refreshed dataset. Here's what is going on: 1) Create a dataset from a table in a database. 2) Create a copy of this dataset and...
16
3459
by: Ian Davies | last post by:
Hello Needing help with a suitable solution. I have extracted records into a table under three columns 'category', 'comment' and share (the category column also holds the index no of the record...
2
1541
by: esscher | last post by:
Without going into great detail (which I can do if it turns out more info is needed), I would like to: All on one page, using ajax: 1. In a text field, have the user enter a plant name to insert...
1
15129
by: adsaca | last post by:
here's my code in filling a datagridview,which i retrieve from database mysql, dim sql as String sql = "SELECT * FROM table_user" Dim myData As New DataTable ...
8
13992
by: ritesh272004 | last post by:
Hi, Could you help me with the below code from Ms Access. I am trying to add data to an access table. FE and BE in the same file. However i get the error as Run-time error '3027': Cannot...
9
2437
by: AMickey | last post by:
I'm getting a run time error with this vba code and can't figure out how to get it to work. It runs from a button on a form and should update a table. Any help would be appreciated. The code is...
0
7004
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
7167
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
7208
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
5464
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4915
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4593
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3095
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1423
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
657
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.