Can Anyone Recomend The Best Way To Synchronise Different Versions Of Same DB
Jun 23, 2005
Hi I am trying to find the best way to synchronise several different versions of the one database, two of which are used by remote users so i can't really set one database on a central server, I am trying to come up with an as automated a process as possible as it will need to be done on a regular basis, has anyone any ideas??
it is a microsoft access 97 database
I will be updating it to a newer version as soon as possible
all help is greatly appreciated
Paddy
View Replies
ADVERTISEMENT
Aug 7, 2006
Please see the attached zip.
I want to synchronise the data in the Sales subform so that, when a different record is clicked, the data in the subfrmSales2 changes.
IE, when a user clicks on OrderID1 in the Sales subform, then the data for OrderID1 shows in subfrmSales2. And when a user clicks on OrderID315 in the Sales subform, then the data for OrderID315 shows in subfrmSales2.
View 3 Replies
View Related
Jul 5, 2007
I need to some advise on which is the best course of action.
I have a MS database with an SQL back end as a client server application.
Now the next step is to give stand alone versions (with a mdb back end) to off-site laptop users, to make updates or entries when not connected to the office network.
Hwr upon returning to the office or when connected on-line through a VPN connection, I would like the databases to synchronise.
I tried exploring the replication options in access but that doesn't seem to work.
What advise and or softwar tips could one offer me.
(ps .net web application is not an option yet as this means a complete revamp of the program, with no .net knowledge available yet)
Thanks for any assistance
View 1 Replies
View Related
Mar 18, 2008
Hi all,
I hope you might be able to help.
I have today setup an Access database for work as we were using Excel but it has become far too hard to manage.
We receive a list of properties which are empty every month in an Excel spreadsheet. I've managed to import my first set (March) successfully into Access. The idea is that we'll supplement Access with investigation notes etc having one access record per property (each property has its own unique ref. number).
However, next month (April) I'm going to receive a new list of empty properties which will include some from the previous month and some new ones.
I want to import this into Access but tell Access:
- Not to import ones which are duplicated (as there will already be case notes on file). I presume it'll be able to check the unique reference number;
- Insert non-duplicated entries (i.e. any new properties which have come on);
However, I also need to be able to identify those which are no longer empty and mark them as non-empty BUT not delete them (as we need the records on file).
That means that running a report in April will give me the same number of empty properties as the Excel spreadsheet.
Is there a way to do this (not manually as we're talking about 2,000 records per month!) or is it going to become too complicated for Access?
Thanks
View 1 Replies
View Related
Jul 29, 2005
Hi,
Scenario - I have one main form containing all the customer details. From this I can open several other forms, containing various other information about the services that they have applied for, and the stage of their application.
Some of these forms also have forms that can be opened from within them, so there can be at times three tiers of forms.
When I add a new customer on the main form, I then open the second form, add more info, then choose from another selection of forms. So at this stage there are 3 forms open. The final form contains a command button to run a report.
However to get the report to work, I have to shut down the last two forms and re-open them, even if I refresh the data on all of the forms.
Is there any way I can create a command button on the final form that will synchronise the data on all of the forms that are open and make the report work first time? Is there a way of doing this using Macros?
Hopefully this all makes sense, thanks.
View 1 Replies
View Related
Jan 7, 2008
Hi
I have a database which I have replicated and I am trying to synchronise the replicated copy with the design master - both at the moment are stored on the same network share.
Whenever I try to sync from the replicated copy I get an error message saying the "search key was not found" and the database won't sync.
What should I be looking for to correct this?
running Access 2003 - Win XP SP2
View 1 Replies
View Related
Aug 14, 2007
:o:confused:
I'm desperately searching for a way to synchronise different copies of the same access 2003 database i created. I have tried brief case synchronisation, and I have also tried the replication manager that comes with access but they both haven't been much help.
My experience with them leads me to believe that they both work best with a LAN or internet connection.
I'm seeking a solution that will work without a LAN or internet connection. Something that will copy my tables and other required objects to a folder that i can copy and move to another pc where another copy of the database resides. It should then import the same tables and objects and hence synchronise the copy of the database.
I recently saw a visual foxpro database that has the kind of synchronisation solution i'm looking for. I think it works this way;it exports all the tables and necessary objects to a folder that it creates allowing you to copy or move this folder via portable storage device to another computer. It then synchronises by importing the tables and other objects from this folder into the database resident on that computer.
I think there might be a way to do this using macro's or VBA but alas my knowledge of these areas of access is very weak. Is there a way to recreate this functionality in access 2003 using VBA code?
View 9 Replies
View Related
Nov 4, 2005
Should be a quick and easy question here... I'm getting close to splitting a DB. Back end mbd, front end mde. Searched the forum and a few other places. One subject didnt seem too clear... I developed the db in access 2002, a few of our computers are running 2003. Will I run into any problems with this setup??
Thanks
View 3 Replies
View Related
Aug 28, 2006
Hi all
Built an Access database using A2k3 but using the A2k format.
Having more or less completed the Database, I have tried it on several PC's that I have round the office here.
All works fine except for one form.
It works perfectly well on Access 2003 and also on Access 2000 version, but for some reason it wont work on on Access 2002.
I have added the screen shots. Anyone with any ideas?
View 1 Replies
View Related
Mar 20, 2006
Hello, I wrote an access program using version 2000 and the activex calendar 11.0 which came with the software. When i tried to run the same program on access 2003 none of my dates worked and I got error messages all over the place. Help!
View 4 Replies
View Related
Apr 2, 2007
Hi all, I have created a database for work in Access2003. I have two questions. The first is, many people at the work place use AC97 and some use AC2000. In order for everyone to use the database, i have saved it in AC97 format. It seems to open fine in Ver2000 and 2003, but i get this nag screen on load up with these versions saying "do you wish to convert the database". As I'm working off a shared drive, i don't really want anyone converting the dbase. Is there a way to disable this nag screen when loading in AC2000 and AC2003??
Second question, is it possible to have more than one instance of the database open at anytime? . If I've got the database open, my colleague can't open it. Its a simple database that writes records directly to a table. Thanks for any advice.
View 4 Replies
View Related
Mar 5, 2008
A few months ago I installed Office 2007 on my home PC and uninstalled Office 2003.
I am contemplating the re-installation of ACCESS 2003 on my home PC, but don't want to disturb my Office 2007 install.
QUESTION: Is it possible to have both versions of ACCESS (2003 & 2007) on my PC without creating problems for myself?
NOTE: I have two hard drives on my PC (C drive, the newer one; and E drive from my last PC). Perhaps I should install ACCESS 2003 on the E drive?
View 6 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 6 Replies
View Related
Nov 28, 2006
Would having Microsoft Access 2002 and 2003 on my hard drive cause me to have error with my code?
View 4 Replies
View Related
Mar 7, 2008
Hi,
My office has updated to Microsoft Access 2007, but one of the third party softwares used requires a previous version of Access. A result of switching between the 3rd party software and Access 2007, is that 2007 installs every time.
Is there any work around to over come this problem?
Thanks,
Chander
View 2 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 1 Replies
View Related
Mar 5, 2014
I have a database in Access 2007 - 2010 that I push out to a couple of different co-wokers.One of my co-workers is using MS Office 2013 and the buttons I have on the forms and reports look inflated.Is there anyway to prevent this in Design mode so what I see in my version is the same as the new version of Access?
View 2 Replies
View Related
Aug 26, 2005
I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new version of access comes out we will have to recreate the database from scratch because there are lots of problems converting between versions. I'm aware there might be some hiccups but I don't really agree with him. Plus once the database is up and functioning I don't see why we'd even have to upgrade it to a new version. It's just a small health centre patient database with info about patients and their treatments. Does anyone have any opinions about this. Thanks.
View 3 Replies
View Related
Mar 16, 2006
Hi, this problem came out of nowhere but looks like it's here to stay.
Our Access app generates various Access Reports.
Recently we installed a new version of our access app and since that version onwards, all pc's with Office XP/2003 print reports in black & white. Printing to PDF works fine though.
We can't find the reason for this. Which mean we had to go to all our clients to downgrade them from office XP/2003 to 2000!
We use mainly Xerox and HP printers.
Thanks!
View 2 Replies
View Related
Mar 14, 2007
Hi
I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare the queries/results to see where the problem was and have found that the changes have automatically updated in the production version. Can anyone explain this? They shouldnt be linked at all. The 2 versions both link to a datawarehouse through an ODBC link, but shouldn't be linking to each other (I'm using Access 2003).
Cheers :)
View 2 Replies
View Related
Sep 17, 2013
I have been asked to add features (and fields) to an existing database containing private medical data. The idea is to add features to the empty database, test it with fake data, purge the fake data and deliver it to the user in another state with a simple update button. The Access 2010 database is in one piece (No front/back end).
I am looking for the best/shortest VBA method to move a lot of preexisting field data from the old database to the new version. I think I have it mostly figured out; I have code for counting, reading and writing the table names, field names and field data.
However, because the data types vary within the tables and there will be new fields in the new versions tables, my only idea, so far, is to code through the data table-by-table and field-by-field, a lengthy process with a large footprint. Moving entire tables or complete records may not be effective. Any faster way to transfer all these tables field data?
View 3 Replies
View Related
Dec 4, 2014
Is there a way to make access be able to store software versions and product keys automatically? Programs I am most interested in is like Microsoft Office suites and Adobe Acrobat and Photoshop and whatnot like that. I am not sure if this is even possible but I am trying to get my database fully functional with all the data and efficiency I can for at least 5 people so that I can try to sell access as a better tool than the service they are using now.
View 4 Replies
View Related
Sep 13, 2005
I have a main form with combo box used for selection criteria. On the same form is a datasheet subform which show the records according to combo box criteria. I have also managed to insert (All) into the combo box to show all records but when I click "All" nothing happens. It does work for all other criteria in the combo box.
I attach the mdb so you can see what I have done so far.
Can anyone help me on the matter. Thanks
View 2 Replies
View Related
Nov 7, 2007
my post at www.thescripts.com was deleted. It seems they don't really want a true deployment solution help to all ms access developer.
Ms access is a true king RAD DB frontend dev't. tool but the deployment of the finish apps are very unstable.
Sagekey is almost there, but I want to make a single EXE on my Access Apps that run even on the usb flash disk.
I have already found the solution, perfectly done! using one of the tools available in the web. but I will not post it again, I'm afraid this post will be deleted again... I hope this forum truly helps.
View 14 Replies
View Related
Dec 28, 2005
Hello,
I have two questions related to deplying an Access project I have been working on.
1. I started developing the project in Access 2000, but midway upgraded to Office 2003 and so the remainder of the project has been developed in Access 2003. Things seem to be fine, except that in the top most title bar, after the project name, there appears the following text:
xxxxx: Database (Access 2000 file format)
where xxxx is the name of the .mdb file.
Why is this appearing and should I have done something or do something to make it a Access 2003 format?
2. I am at the point of deplying the db to a small group of users (about 5). Some of them may have Access 2000 or Access 2002. Should I be doing something in particular to make sure things work in their machines.
Any pointers to what may be problems or what I should do will be much appreciated.
Thank you.
View 2 Replies
View Related