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

General :: Distributed Application - Variable Screen Sizes?

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

General :: Access FE User Auto Copy Most Recent File

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

General :: Update Name Fields From Related Table Along With Auto-number?

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

General :: Update Front End With New Back End File Location

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

Distributed Databases

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

12 Months Budget With Evenly Distributed Numbers

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

Auto-insert And Auto-update Help

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

General :: Mail Merge Word File (using Data From Access File)

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

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

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

General :: Make Accdr File Out Of Accde File?

Sep 10, 2012

How do I make an accdr file out of an accde file?

View 9 Replies View Related

General :: Follow Hyperlink To A File Without Using File Extension?

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

General :: Batch File To Check (version) Of A File?

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

Auto Update Of A Db

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

Auto FE Update

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

Auto Update..how?

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

Reports :: Save Report As PDF And Auto Populate File Name

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

Auto Update In Form

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

Auto Update Fields

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

Auto Update Form

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

Auto Update/reload

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

Auto Update Form

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

How To Auto Update A Report

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

General :: Saving Data - Update Or Cancel Update Without AddNew Or Edit

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

Modules & VBA :: Auto-export Query Record / Row To Text File

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

Modules & VBA :: Excel File Export Auto Cell Width?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved