Is It Possible To Synchronise By Exporting And Importing Database Objects?
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?
I have an access database that was set with security about 10 years ago.
I have now created another database in 2010 and I am importing all the objects to make a clean non secured database.
When I import tables it imports system table objects like MSysRelationships, but as it already exists it adds another MSysRelationships with a 1 on the end (MSysRelationships1).
Should I delete the original MSysRelationships and then rename the MSysRelationships1 as MSysRelationships.
There are numerous others like MSysAccessstorage, MSysACEs etc...
I am gathering that if I don't rename MSysRelationships1to MSysRelationships then the relationship data would be incorrect and the database wouldn't work correctly, but maybe I am wrong.
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.
One of my tables has a couple of OLE Object fields. This has embedded Word, Excel, and PDFs. I'd like to know if there is a way to export these to a folder. Ideally, I'd like to save them with the record id and then a dash and then the file.
The fields are Attachment1, Attachment2, and Attachment3
When I view the table for these fields, if it's a word doc all I see is "Microsoft Word Document".
I import/export data from MS Excel. Access will not allow me to use the Browse function to select the directory and/or file to work with. I do not get an error message, just nothing happens.
I am a novice when it comes to the MS Access interface. My experience has been designing the database and then using ASP pages to query, update, etc. I am now in a new position where I have to modify a switchboard to point to other data sources (i.e. databases) who have been renamed. My problem is that when I open any of those databases all I get is a form (switchboard) that has links to reports. It appears to my novice eye that the switchboard is the only thing that exists within the "main" database and it points to other databases -- when I open those databases another switchboard comes up and I still cannot view the database objects. I hope this makes sense -- believe me, I am attempting to understand this all.
I hope someone can explain to me what's going on -- there has to be a database that I can open and see actual database objects by going to the top menu bar and selecting, "View --> Database Objects --> Tables, Queries, Forms, etc.
I want to display 8 thumbnail images at a time per form of records that matched a search critera in a form. But it seems like a form is suppose only to have one record at a time? I want to have a "next 8 thumbs"-button so it gets easy to browse the pictures.
I'm very thankful if you could help me with this! Please give me some advice.
We have an Access 2000 db, which has been used for some time and is split between a front and back end. We've come in today and tried to open the back-end, which contains only tables, and when it opens it's completely blank. We can't see any of the objects or the normal menu to access the tables, queries, etc. We can, however, import the tables into a new database, so they must be there.
Any idea why this has happened or how to stop it happening again.
I have recently updated my version of Access. Within a tbl i have a series of hyperlinks. All of these hyperlinks are linked to an object within the database, a macro as an example. When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?
I'm using Access 2007. I have designed a database for one of a two division set up. All of the raw data in the tables is similar yet there is one unique identifier for the two divisions. Let's call it DivID, four characters in length.
To keep the maintenance simple I want to have one set of forms, queries and reports. I do not want to duplicate all of these. To the user they will only see one set of the menus, which will show all of the necessary sub-menus.
The first or main menu will have two buttons, Division A and Division B. The user simply clicks on the appropriate division button, and off they go. I'm thinking that it would be easiest for me if the DivID is stored after they click on their division button, and this value is used for any form or report that they run afterwards. Also, this DivID value would generate custom headers at each menu and submenu to confirm which division they chose.
I have greyed out objects in my Access database. I didn't create them and don't know what they are. I tried to delete them but couldn't. Why did they come to my database -or they were already there but now they are appeared- and how can I get rid of them?
Imagine you have a split database with two users making reports on their own front end. Lets say user 1 wants to share a report they built with user 2. is it possible to send this Object through vba so that user 2 would received a working editable copy that they can use on their front end without sharing the actual accdb front ends?
I thought about creating a Database that would just host the reports but again if I cannot send or access secondary database objects then this method would not work.
This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch.
I have a problem. This problem is that I cant see the Database objects (Forms,Report,...) in the Windows task bar. I want the user to be able to see any opened form, or report directly in the task bar as any file opened by the Windows user.
I have tried to check on the (Show Windows in TaskBar) option available in the Tools -> options of the MS Access, but it doesn work with me.
What is happening now that I am forced to show the Menu Bar and use the Window menu to switch between the objects, however, This will not be OK for me because my system hides all the command bars the MS Acccess use.
I have Access 2007 and I use to be able to Hyperlink to an object in my database 9no upgrade0 But suddenly this option is not available. What can I do?
I have a database with a main menu which opens up on start-up it works fine and all but I want to go the extra step, I wish to disable / hide the ribbons (Top and Bottom) - Or Hide the whole Microsoft Access Window and display my form with the desktop behind it.
The next thing is once I click the X or the button to close the form I want Microsoft Access to appear again as in everything to show itself again.
I have a database that runs a macro/report every 2 hours, however our network has been up and down lately. This causes the macro to fail when trying to log into the system because the table that is storing your username is no longer in the database. When I check, all tables, linked tables, forms, reports, macros and modules are all gone. I find the only way to get them back is to close the database and reopen.
What I want is a way to reconnect the objects without closing and reopening.
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.
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)
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?
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?
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
I am trying to export a calendar form from one database to another.. I click on export, choose the database I want it to be exported into, and it seems to work..the form shows up in my new database, but:confused: when I click on the form I get a page of code that pops up with an error message
