General :: Auto Update Of Distributed MDE File?
Jun 3, 2014
We keep a backend and a master frontend of a database on a network drive and distributed a .mde version of the frontend to the users who save a copy of it on their hard drive. There is a separate version table on the frontend and backend of the database for version comparsion. Whenever there is change on the master frontend, I shall change the version # on those tables and make a new .mde file on the network.
When user open their own mde frontend, there are scripts to check its version with the master frontend on the network and any mismatch will trigger off the following scripts (on the default form) to replace the old version with a new one from the network.
Private Sub Form_Load()
Dim strFEMaster As String
Dim strFE As String
Dim strMasterLocation As String
Dim strFilePath As String
' looks up the version of the front-end as listed in the backend
[code]....
This process works fine for everyone in Access 2010. However, these scripts appear to have conflicts with Win 7 when users upgraded to the O/S. They keep getting database unstable error message and the process fails to work. Whether we can change the scripts to make them compatible with Win 7?
View Replies
ADVERTISEMENT
Mar 26, 2013
Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.
View 2 Replies
View Related
Jun 4, 2013
I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.
With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.
Questions: Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?
I am not sure how to create a bat file and what the code should be?
For version tracking I need to put a version table in the BE and in the front end correct?
have made a few significant changes but I'm holding out e-mailing it if I can get this version copying figured out and in place first.
View 4 Replies
View Related
Jul 1, 2014
The "PersonalDetails" table is related to the "Application" table using the autonumber from table, "PersonalDetails".
The "PersonalDetails" table has "StudentID" (autonumber), "First Name" and "Last Name" fields.
The "Application" table also has "StudentID", "First Name" and "Last Name" fields.
The "Application" table is related to the "PersonalDetails" table using the "StudentID" field.
How do I make it so that the first and last names on the "Application" table are automatically updated when the StudentID is entered?
View 2 Replies
View Related
Dec 12, 2013
Access 2010
Objective?: I'm attempting to change the file location of the back end portion of my split database.
What I've done so far: I've used the linked table manager to update the back end location of all tables in the front end portion of the database.
Symptoms: When making a change to the OLD back end: If I change the name or move the old back end and then try to re-open the front end, Access opens as if I'm opening the application itself without any database associated with it until I restore the OLD back end to its appropriate state.
When making a change to the NEW back end: If I change the name or move the new Back end and then try to re-open the front end, I get a: "Could not find file" error message until I restore the new back end to it's appropriate state.
I've just discovered a query that I think put me one step closer to resolving this issue. [URL] .....
When I run this query:
Code:
SELECT MSysObjects.Database
FROM MSysObjects
GROUP BY MSysObjects.Database, MSysObjects.Type
HAVING (((MSysObjects.Type) In (4,6)));
It returns 2 results:
1. The path of my old back end
2. The path of my new back end.
Unfortunately I'm not able to update the values from the Datasheet, but this does confirm to me that the old back end is still some how being used by the front end even after my tables have all been updated.
View 5 Replies
View Related
Nov 28, 2005
Hi,
I have an MS Access database on a server which acts as a back end, with about 30 users using the data. They each have a copy of the MS Access front end located on their PC's.
Every time I make a change to the front end, I have to redistribute the new version to each PC.
What I am wanting to do is put a single copy of the front end on the server, and adding a shortcut to this front end on everyone's PC's. This would allow me to make changes to the front end without having to redistribute to all users.
What I was wondering is, if I put a single copy of the Front end on the server and simply shortcut to that front end, will it cause any problems, or are there any issues that I should look out for?
Any help or advice much appreciated!
View 2 Replies
View Related
Jul 13, 2012
I am dealing with 12 months budget with all evenly distributed numbers. However, there are some departments have unevenly distributed numbers for 12 months. I would like to take out the rows with unevenly numbers. how should I do it? Or what criteria? I am a basic Access user.
View 1 Replies
View Related
Sep 1, 2005
Hi all!
I was wondering if you guys can help me out with this one:
I would like to have data auto-inserted from a particular colum in table 'x' in to a defined column in table 'y'. similary, I'd like to achieve auto-updation of this data as well as deletion. Can anyone please provide some guidelines?
A little more detail :
I have a column "Client ID" in the table client_personal_info, the rows of which I'd like to have updated in the "Client ID" column in the client_business_detail table.
So if say, ClientID_1 is a row that has been added by the user, I'd like to have it auto-inserted in the client ID column in the client_business_detail table
thanks in advance for your help
View 5 Replies
View Related
Mar 11, 2014
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
View 3 Replies
View Related
Oct 5, 2014
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
View 4 Replies
View Related
Sep 10, 2012
How do I make an accdr file out of an accde file?
View 9 Replies
View Related
Sep 6, 2012
Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
View 3 Replies
View Related
Aug 28, 2012
I use a batch file to distribute the front end of a database application. Currently, everytime the user clicks the shortcut on her desktop, the batch file executes and copies the front end from a network location to user's local machine. The FE is updated like every couple of days. The users run the database more frequently.
I would like to modify the batch file so that it checks some attribute of the FE file to decide whether it needs to be updated. I can't rely on file size, since the FE includes temporary tables. I essentially need something like the "tag" property of form controls, only for files. It would be ideal if it was me who sets this property, like "version number". Except it has read without opening the file itself.
View 14 Replies
View Related
Nov 24, 2005
If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like that?
Thanks
View 1 Replies
View Related
Dec 21, 2005
hi all
i searched for this but didnt get it clear. how can i update the FE for my users?
View 1 Replies
View Related
Jan 19, 2006
Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...
How could i do these automated:
1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..
2. how could i put row count.. so i could know how many items i have and on what row are they...
pls help..
thanks in advance....
Eric
View 5 Replies
View Related
May 8, 2013
My reports are saved as a PDF at the moment I click the print report button, select cutePDF Writer then manually add the Quote number stored in Field from the Table or form into the file name, then select the location to store the PDF file
Can I make this process automated when I click the print report button to auto select PDF Print, then auto populate the file name with the quote/Inv Number and then save to nominated directory.
View 6 Replies
View Related
Nov 28, 2005
I have a form I need to enter basic info into, and would like to know Iif there is a way based on the primary key id when I enter info on an individual's account, the rest of the info will get updated, i.e. contact info, full name, etc.?
Thanks.
View 1 Replies
View Related
Feb 17, 2006
Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table?
Thanks
View 3 Replies
View Related
Sep 21, 2006
Sory about my english.I have a table that records data.Name-Surname-adress-payment time etc.The payment time is very important because all event is progress around this.Is that possible to remind me before the payment time?Thank you very much for your help.
PS: I send a photo about my question.
View 1 Replies
View Related
Sep 26, 2006
I am building this little project for work, and came up with this problem.
It's basically a database of the works in the workshop.
Each car comes in, the service advisor adds a new job in to the database.
And at the other end of the workshop, ppl can see it on the screen.
What I have managed to do now is that if someone modified any details of the existing jobs, it will be automatically updated on the other computer.
(ie, computer 2 has a form opened and showing all the current records in a continuous form view, computer 1 modified 1 record, then a couple seconds later, the form will update itself with the new data on computer 2)
The problem now is, if computer 1 ADDs a new record, it will not show up/auto update on computer 2's form, until I close the form and reopen it again.
Now I have no knowledge in VB and have no idea on how it work together with Access. I do however has some skills in other programming language like Java and C, so learning shouldn't be a problem if that has to be done through VB.
Any suggestion?
View 4 Replies
View Related
Nov 12, 2006
I have a database with a Source Table related to a Product table in a Master/Child relationship. The source table has a SourceID field as the primary key and a SourceName field. The Product table has a SourceID field as a foreign key and is related in a many to one relationship to the Source table (the source table is the one and the Product table is the many).
I have a form used to update the Product table. The form includes Combo Box controls for both the SourceName field (which fills in a Source field in the Source field in the Product table) from the Source table and the SourceID field from the Source table (which fills in the SourceID field in the Product table). I need to know how to automatically fill in the SourceID control based on the selection made in the SourceName control.
I would also like to know how to automatically open a form to update the Source table if I enter a SourceName in the Product.SourceName Combo Box that isn't already in the Source table.
If you can help me, please send your replies to james.ballotti@gmail.com
thank you
View 1 Replies
View Related
Aug 18, 2013
i have a complete access database with forms and queries and reports.
the only problem i am facing is that when i create a new report it only takes the data already entered.
if i modify or change a record in the form or table the report doesn't update the modifed data it stays as it is before and i have to re-create a new report.
is there any way to deal with this and make the same report auto refresh the data modified or no ?
View 5 Replies
View Related
Apr 13, 2013
My membership database has worked fine until recently. Now I cannot save inserted data. On attempted saving "Update or CancelUpdate without AddNew or Edit" appears.
The problem. relates to 2 tables Member and Addresses. PK in the parent table Member is ID. In the Addresses Table the FK is ID. There is a One to One relation between the tables and Referential Integrity is set. I know 1 to 1 is not good but it worked fine in this small database.
Browsing the all of the existing records is fine.
View 9 Replies
View Related
Oct 24, 2013
I have 3 queries that provide the same printer information. Each one is queried by a different field: IP address, asset tag, and serial number. This may not mean anything in the long run, though I figured it is worth mentioning.
The users need to be able to quickly query a printer utilizing one of those criteria and then copy and paste it into our ticketing system. Is there a way to automatically export the record from the query to a text file? I have extensively searched online and have tried to come up with something but I have found that I don't know where to start. This is the code for the query:
Code:
Dim intCount As Integer
intCount = 0
If DCount("Location", "Phone numbers Query") > 0 Then
intCount = intCount + 1
DoCmd.OpenQuery "", acViewNormal, acReadOnly
[Code] .....
View 9 Replies
View Related
Jun 26, 2014
I have the following code to export a query into a excel file:
Code:
Dim outputFileName As String
outputFileName = "C:AccountSpreadsheet est.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Q_Search_Invoices", outputFileName, True
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open "C:AccountSpreadsheet est.xls", True, False
Set xlApp = Nothing
This works almost exactly how I want it to work.
The only thing wrong is that the columns are all the same width and they are all to narrow.
Is there a way to make the columns automatically become the width of the longest text within them (exactly what happens when you double click on the side of a squashed column in excel)?
View 5 Replies
View Related