General :: Backend Version Control?

Oct 23, 2012

I have completed the split and have deployed the backend to SharePoint. The front end is sat on my (and others) machines with linked tables to the SharePoint lists. This is all fine and works well.

Although this database is deployed, I am constantly working on a local copy of the database in design I.e. Tables being updated with fields and relationships and new tables being added. The reason for this is that work wanted something workable putting out there now and that I just continue its development in the background.

What is the best way to update the tables on SharePoint bearing in mind that users are putting new data on there? I don't want to lose what they are updating and then I need to redploy the 'new' backend to SharePoint again (no doubt in the same location) as that's where the front end is looking for it.how I can manage this version control of the backend without losing data.

View Replies


ADVERTISEMENT

Using Access With SourceSafe - Version Control

Oct 7, 2004

I need to start doing some sort of version control with my Access development.

I have seen rumors that SourceSafe can work with Access. (I know you can store a db as a file in SourceSafe but I mean more detailed i.e. Objects )

Has anyone out there successfully used SourceSafe? If so how does one set it up?

Any other suggestions concerning Version Control.

Thanks

View 1 Replies View Related

General :: Increment Database Version Number By 1

Feb 11, 2014

I am working on a section of code that when a user clicks a button it looks at a table called TBLVersion and increments the version number. The version number format is 1.0.1 what I need the code to do is increment the last digit by one for example to "1.0.2". I got the flowing code to work in excel but could not figure out how to translate it to access.

=LEN(A1)-SEARCH(".",A1,SEARCH(".",A1)+1)
=RIGHT(A1,B1)

View 1 Replies View Related

General :: Send Emails From Run Time Version With And Without Outlook?

Nov 14, 2012

Must Outlook be installed for Access to send emails?

Can I send emails from the Run-Time version of Access? (with and without outlook)

View 1 Replies View Related

General :: Cannot Open A Database Created With A Previous Version Of Application

Oct 22, 2012

I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.

View 1 Replies View Related

General :: Many Front Ends And Only One Backend

May 7, 2013

I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!)The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower.I am looking to separate this in to 3 FrontEnd files as to simplify and to lessen the file sizes etc.

My question is - are there any issues around a 3 x FrontEnd databases all connecting to 1 x backend database holding all the tables - over a network?

View 11 Replies View Related

General :: Automatic Backend Backup To Any Folder

Feb 5, 2014

Code to automatically backup backend to any folder or media in Access 2010?I need codes to be backing up my Back-End automatically. I am using Access 2010 format.

View 1 Replies View Related

General :: Backend Server Name Path Length

Jul 16, 2014

I've always practiced to keep my backend table names to no more than 8 characters because of speed issues. Can this also goes for the server name? My current location looks like this now orld71-testing-aFinance..I am wondering if changing the server name with speed or is that only for folder names.

View 5 Replies View Related

General :: Choose Backend Location From A Form

Dec 18, 2014

I'm making updates for the front end then i send it to 10 pc's in the office then i should change the backend location via linked table manager for every pc

So is there any way to let the user choose the backend location when he open the database nad then it will automatically update the tables link

View 4 Replies View Related

General :: Deploying A Password Protected Backend

Sep 23, 2013

I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the backend and then just write the ADO code needed in the app's front end to connect with the password.

View 2 Replies View Related

General :: Backend Path Syntax In Intranet

Aug 20, 2013

I have splited the system into foreend (FE) and backend (BE). FE and BE are located in different PC lying in company internat! However, I found there always give an error message 3219. And, nseems it is caused by not pointing correcly to the BE when I open tables, the syntax are as follows

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb()
Set rs = db.OpenRecordset("Invoiceyr", dbOpenTable)
rs.MoveFirst
rs.Edit
Me.THISYR = rs!Invoiceyr

The 3219 error appeared at statement "Set rs = "what's the syntax of the path that I should include in the statement in order to point correctly the BE.

View 9 Replies View Related

General :: Batch File To Allow Users To Copy Latest Version Of Front End Whenever Change Made

Aug 7, 2014

I have been trying to set up a batch file to allow users to copy the latest version of the front end whenever a change is made. The following is the code that I am trying to get to work properly. The first part works fine, the old front end is copied to a folder on the user's desktop as a backup. But I cannot get the copy of the server - the "P" drive, to overwrite the current copy on the user's desktop. Actually I cannot get the code to copy the new front end from the server and install it on the user's desktop. I think the path is correct for I seem to be able to run the new front end from the server.

When I look for the location on my computer, the server locations is listed as:

General (Servernamefiles) (P: ) (there is no space after the P: it seems to result in a smiley face when I type it and try to post it).

for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set year=%%c
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set month=%%a
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set day=%%b
set TODAY=%year%-%month%-%day%
rem echo %TODAY%

[Code] .....

This code works so I thought that the path was correct
rem this works
rem start the new DB front end
Start P:AccessMainSplitBENewFrontEndDBMain.accdb

But this code does not.
echo f | xcopy /f/y/ P:AccessMainSplitBENewFrontEndDBMain.accdb c:UsersUserNameDesktopDBMain.accdb

Neither does this:
echo f | xcopy /f/y/ ServerNamefilesP:AccessMainSplitBENewFrontEn dDBMain.accdb c:UsersUserNameDesktopDBMain.accdb

View 2 Replies View Related

General :: Detect Broken Backend Connection At Startup

Feb 17, 2015

I have a split Access 2010 database. If the backend file is not accessible (for instance, if our shared folder connection is broken), I get no warning message at all when opening the front end. Just the home screen you would get when launching access from the Start menu. I was thinking of adding some VBA code to my startup form to give users a warning that there is a connection problem, but Access won't even load the startup form.

View 8 Replies View Related

General :: File Sharing Windows MS Access Backend?

Oct 19, 2014

I want to deploy an access database at a small office with 5 computers, small network. However I do not intend to create a server in order to have a domain etc. Operating system is win 8.1 pro. Should I use a homegroup or workgroup ? Would it require password in case of workgroup? Which is a recommended way to setup this and keep some security like a guest cant access these files?

View 14 Replies View Related

General :: Transfer Tables Directly To Backend Database?

Mar 12, 2013

I'd like to to import some large oracle tables from a remote server using "DoCmd.TransferDatabase..." on a daily basis. Currently, the system works, but my database is getting quite large (800 Mb) and I'd like to split off the tables to a back end database.

Is there a way to import directly to the back end database? The postings that I've seen seem to imply that one must first import the tables into my front end, then export them into the back end. Does that sound correct?

I'm at home right now, but will give it a try when I get to work. It just seems like there's got to be a more direct way!

Jon Mulder
Department of Water Resources
Red Bluff, CA

View 4 Replies View Related

General :: Forcefully Closing Backend Database Before Compacting

Oct 8, 2012

I have a Ms Access split database where in the backend database grows up very fast and needs to be compressed everyday. I have written a batch script to compact the same and have scheduled it to be run every night. But the script is unable to compress the backend every time since the users tend to leave the application open at the end of the day. Ideally i am looking for a command line script to forcefully close the back end database if open before attempting to compact it.

I searched on web but could not find a command line script for forcefully closing the back end database.

View 3 Replies View Related

General :: Copy Structure From Existing Linked Table In Backend

Jun 9, 2012

I have a need to copy a table structure from an existing linked table in the backend

i have done this by

a) copying the table structure into a new table in the fromt ebd
b) exporting the new table into the backend
c) dropping the table in the front end

just wondered if there was an easy way to do this directly in the backend?

View 1 Replies View Related

General :: Split Database - Modify Backend File And Make A New Front End

Jun 12, 2012

So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive. This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.

As far as I could tell all I had to do was modify the backend file and make a new front end. However it seems like it is not as easy as I thought it would be. How do you modify a split database without corrupting the files or using a non-split copy?

View 1 Replies View Related

General :: Block Pathway To Backend Folder But Allow Access Via Frontend Database

Jul 17, 2012

If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db?

Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck with MS Access for now. I just don't want someone looking at, say, a link table path and then navigating to that folder and getting access to backend information.

View 14 Replies View Related

General :: Hyperlink Location - Hide Entire Path In Backend And Show Only Name Of File

Sep 26, 2013

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.The location filed looks like

M:New1234.pdf
M:New1111.pdf
M:New2222pdf
M:New4444pdf

If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.

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

General :: Create A Button That Will Create A New Empty Backend

Oct 31, 2013

I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.

View 7 Replies View Related

General :: Stop Tab Control With VBA

Jan 17, 2014

I'm trying to stop a couple fields from being able to tab to based on other field value in a form. I have the following code but this didnt work.

Code:
Private Sub Step42_GotFocus()
If Me.Step42.Locked = True Then
Me.step43.SetFocus
End If
End Sub

I then tried this. but it still allowed the tab stops. How can I stop it?

Code:
Me.Step42.Locked = True
Me.dat18.Locked = True
Me.dat19.Locked = True
Me.dat20.Locked = True
Me.Step42.TabStop = False
Me.dat18.TabStop = False
Me.dat19.TabStop = False
Me.dat20.TabStop = False

View 10 Replies View Related

General :: Using MS Access To Control SAP?

Mar 6, 2014

I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.

I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.

View 2 Replies View Related

General :: Tab Control - Same ID Forms And Subforms

Feb 24, 2013

I have a form with a 'tab control' on it

Tabs 2-9 have a subform on them

Each form/subform writes to a seperate table

The form is the main table

When a record is created with by the form an autonumber Id is generated

I want to pass this ID to each of the subforms so that the tables can all link

Form-1 Table-1 AutonumberID
Subform-1 Table-2 AutonumberID from table-1 (can be new field in table)
Subform-2 Table-3 AutonumberID from table-1 (can be new field in table)
For all subforms and tables

View 2 Replies View Related

General :: Navigation Control With Query?

Jan 21, 2013

I have a form for testing purposes only it is named "Navigation Form". It has a tab called WorkingInitial. Within WorkingInitial I have a form called QueryTester. With a list box called List0.

Basically I want to click on the tab and the query to automaically filter based on the criteria I create. I dont want to have to create a bunch of forms with each seperte query. I want VBA to modify the Query.

This is what i have an I have no clue why it doesnt work or what I am missing.

Code:
Private Sub WorkingInitial_Click()
Dim strSQL As String
List0 = strSQL
strSQL = "SELECT * FROM [Table1 Query].[My.StatusInitial] WHERE StatusInitial = 'Working';"
End Sub

View 5 Replies View Related







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