473,326 Members | 2,108 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,326 software developers and data experts.

Working concurrently in MS Access

99
Me and my colleague are working on an ms access 2007 based application.(The database is sql server 2005)It is all about making certain changes on the application by creating some sub forms, forms or just adding a grid or a button to the old one.We have divided our work and plan to merge them later.Since both of us are new to access we do not know how to merge our works(we are working on different servers).Shall I simply copy and paste his work into mine?HOW?Or is there a better way of doing it?
Feb 12 '12 #1

✓ answered by Mihail

Just an idea:

Work each one on a different FE (Front End database) and to different parts using the same BE (Back End database).
When one of you have finish a part, the other one can import that part (a form, a query, a module, a report) in his FE. This way you (both) will have all the time a general view. Also you have a kind of back-up.

It is ONLY an idea. Because, as NeoPa point, there are a lot of things to think to.

Good luck !

15 1707
NeoPa
32,556 Expert Mod 16PB
I'm afraid there's no easy answer to that one. Working together on such a project can mean 101 different things. All I can suggest is that you make clear notes of all you change then discuss how the merging can be accomplished when you both understand the changes that are involved.
Feb 12 '12 #2
HiGu
99
every change to be made has been documented.The only thing that is troubling us is how to combine them so as to get the final application without affecting the macros and other forms.
Feb 12 '12 #3
NeoPa
32,556 Expert Mod 16PB
I can only repeat myself :-
NeoPa:
All I can suggest is that you make clear notes of all you change then discuss how the merging can be accomplished when you both understand the changes that are involved.
Feb 12 '12 #4
Mihail
759 512MB
Just an idea:

Work each one on a different FE (Front End database) and to different parts using the same BE (Back End database).
When one of you have finish a part, the other one can import that part (a form, a query, a module, a report) in his FE. This way you (both) will have all the time a general view. Also you have a kind of back-up.

It is ONLY an idea. Because, as NeoPa point, there are a lot of things to think to.

Good luck !
Feb 13 '12 #5
NeoPa
32,556 Expert Mod 16PB
That could certainly work as far as it goes. There are parts of a database that wouldn't fit within that description though. That is why I suggested what I did. It certainly seems a solid, fundamental approach though Mihail :-).
Feb 13 '12 #6
Mihail
759 512MB
Hy NeoPa !
This is a chat post so I think you remove it after you reed, but not necessary.

As far as I know (and this time is very very far), they can't finish the job if they don't start it.

On my keyboard the DELETE key is more useful than the ENTER key :)) .
And I am sure that this is the situation for many other coders more or less skilled.

So my advice for HiGu and his co-worker is to start the job. Now ! :))
Feb 13 '12 #7
HiGu
99
Sounds like a promising idea.Both of us are actually using the same backend database but different front end. I hope we can also import subforms. Need to check that. Thanks a lot!
Feb 13 '12 #8
NeoPa
32,556 Expert Mod 16PB
Forms, Reports, Tables, Data, Queries. These are all importable from one database to another. Forms and reports also have the facility of exporting to the file system. This means that they can even be copied and sent via email for instance should that be required.
Feb 13 '12 #9
HiGu
99
So, I guess I need to delete the old forms and import the new forms in which changes have been made. Will that not affect the forms' relationship with other forms in the application? If it will, then we need to study the relationship of all the forms with each other.Herculian task.There are around 60 forms and some 15 reports.
Feb 14 '12 #10
Mihail
759 512MB
The relationship are established between tables in the BE database. Not between forms. So I don't see any problem here.

Do not forget to make copies to both databases before start.

Good luck !
Feb 14 '12 #11
HiGu
99
What about relationship between a form and a subform?If I import a subform then how would I link it to the relevant form? I'm talking about Link child field and Link Master field.
Feb 14 '12 #12
Mihail
759 512MB
The sub-forms ARE forms.
You can see that in the tree manager: No difference between them.
More, maybe you know that you can design a "stand alone" form (I am not sure that is in true English what I say) and use it as a sub-form.
So, as long as you have both, main form and the sub-form, in the same database, Access will do the job without your intervention.

But is no need to ask every time.
The computer will not become angry if you try something wrong.
Feb 14 '12 #13
Mihail
759 512MB
Between the form and the sub-form is not a relationship. Is hard for my English to describe why. It is hard even in my mother language because I am also a beginner in databases. Bu I know that i am right. Maybe someone else will enlighten you (and me too).
Feb 14 '12 #14
NeoPa
32,556 Expert Mod 16PB
The relationship between one form and another, which appears on the first as a subform, is defined within the subform control and is a simple name reference.

IE. If form [frmA] has a Subform called [sfmB] then [sfmB] might have a Source Object property of "frmB". If [frmB] is replaced in the database then the new version of [frmB] will be loaded into [sfmB] on [frmA] in place of the old version.
Feb 14 '12 #15
HiGu
99
Hi all!thanks a lot!
Feb 15 '12 #16

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

Similar topics

1
by: lphuong | last post by:
I'm working on a db on Access 2000. I'm also linking that db to some tables on SQL Server Enterprise Manager. My code is stop running at the statement, set db=CurrentDb()? Is that the reason I...
2
by: worldbadger | last post by:
When I moved my Access 2000 program to Win XP Home, none of the wizards are working. Anyone know why? Since I know it will come up (at least it was the first question Microsoft asked) I do have...
0
by: Lauren Quantrell | last post by:
I use this code in my Access 2K apps to check for multple instances of my Access2K apps and it works fine on XP and WIn2K OS. However, trying it on Access 2003/ XP OS it doesn't work and gets...
9
by: shaddock | last post by:
Hello, When trying to run the InstallUtil.exe, I get the error below. Any insights? 'installutil' is not recognized as an internal or external command, operable program or batch file. ...
2
by: Anthony Bollinger | last post by:
I don't know if this is the best group to ask this question, so redirect me if necessary. I have a valid query that uses the LIKE operator. I know it is valid because it works directly in Access....
7
by: Trevor | last post by:
I have created a small DB in Access, I then created the datasource and got the data through to the app in detail and it shows me 6 columns and each of the 6 columns holds a number. I then have a...
2
by: stuart.medlin | last post by:
I have recently converted an Access 97 database to Access 2003. However, I am running into a problem with using Application.Filesearch to locate a file in my directory. The code follows: ...
2
by: TroutmansRegistrar | last post by:
I have a web programming task that has me stumped. I hope that one of you could give me some insight or might know someone who could guide me in the right direction. This is the final piece of the...
1
by: hvtarn | last post by:
Hi all, I am testing the reports on the new server with access 2003 installed. strFileName = "C:\FILES\pricingtool\ReportsOut\test.rtf" strDynRptName = "rpt_WebStdQuoteSum" DoCmd.OutputTo...
4
by: daved | last post by:
SOLUTION NEEDED FOR ACCESS 2003 / VBA, NOT FOR ANY VERSION OF VB. I need to differentiate between the Enter key on the main keyboard and the numeric keypad and obviously tried using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.