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 Replies


ADVERTISEMENT

Front End DB Error - Back End File Path Not Valid

Dec 7, 2011

I have recently created a db for a large Printing operation in our company. Previously, the process was all paper-based and extremely inefficient, so obviously this is a huge step in the right direction.

Upon completing the db and providing a demo to the staff, I saved a copy to a shared folder on the network for them to access (.accdb file). We've done this with other dbs before, but with smaller groups (3-4 people). With this db, since there will be anywhere up to 15 people that may want to access it at the same time, the db started crashing during the first phase of pilot testing this week.

I did some more research and found that the db should be split.the users can't open the db anymore.I have a Printing Services shared drive in which created an "Administrator" folder for the back-end (the front-end is in the same location as that folder). When I split the db, I select the back-end location to be within the Administrator folder.

TrackerAdministrator OnlyOS Tracker_be.accdb" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.I know that the file path is valid, b/c I selected it specifically when using the wizard to create it, and I know that the staff have access to the shared drive as they had to open it in order to gain access to the front-end. Plus, it's working for me when I try to open it, just not the others.

View 2 Replies View Related

General :: How To Link One Front End With Many Back Ends

Mar 8, 2013

i have one front end access database and want to connect with more than one back end at time but both back ends have same table names

View 2 Replies View Related

General :: Added Table To Back End Not Linking Up To Front End

Jun 22, 2012

I did a search in here as well as Google to figure out why when I relinked the front end to the back end after adding 2 tables to the back end that the tables did NOT show up on the front end. Only the original tables that I began with.From what I have read there are different ways to do it. One suggestion on here was to create the table on the front end and export it to the back end. I guess I will have to do this going forward.

But my question is, after searching pages upon pages with no luck, since I already have the tables in the back end how do I tell the front end to find them and link them?

View 2 Replies View Related

General :: Using Dropbox To Host Front End / Back End Database

Sep 28, 2012

Using Dropbox to host a split database. Ulimately I would like to create a run version for users with the back end held in a drop box directory.

As an unsplit database everything is working fine on dropbox records are saved in a timely manner and great.

Once I split to FE /BE only some records are saved on the BE and some are dropped. Was getting conflicted copies of Back end but manged to stop this happening but the records were noit on either copy.

Gave each user their own FE (on a drop box directory) linking to a BE in a sub directory on the same dropbox.

The key issue is that not all users have access and I don't want them to get into code so want to aim towards a run version.

View 14 Replies View Related

General :: Linking Front End With Multiple Back Ends

Sep 30, 2014

My question encompasses a front end connected to multiple back ends. It is probably a mundane point, but reading a few articles didn't seem to touch on it.

By this, let me toss out that I am thinking of the personnel where I work when I say 95% have a hard time using email and MS Word, let alone mundane functions like find a file, etc. As such, I have to make my front-ends extremely user friendly.

With that in mind, when developers have multiple back ends, what are thoughts about the best way to relink when required? Even when there are 'more sophisticated' users? Security not an issue or is an issue (inasmuch as can be handled in access)?

Ex: Large corporation with a multitude of user ability. Large database with say 3 different back ends.

I was thinking about keeping a front-end table with each table name and UNC path, hard coding paths to corresponding table names, etc.

Personally I don't have a need for multiple back-ends, but the question came up while reading.

View 7 Replies View Related

General :: User Updates On Front End Database Not Updating Back End

Nov 12, 2012

I have a Database that has been split into two.

Back-end for all the data.

Front end for all the forms and queries.

The front end has been saved in a accde format and distributed to 20+ users. They have all saved this onto there computers and this is used as an application.The users complete a form on a weekly basis on the application and then save. This then saves into the back end.For some reason I have noticed that a few users submission randomly do not save. For the life of me I cannot understand why.All users have saved them into the back end in the past but every now and then submission for users do not save.

View 5 Replies View Related

General :: Split Database - Putting Password For Both Back And Front End

Jul 10, 2013

I have designed a split database( with back end and front end), I am just wondering what would be the best way to put a password for both of the back and front end.

View 10 Replies View Related

General :: Unable To Import To Excel From Front End And Back End Using Database Connections

Aug 5, 2012

I have split my database in Front End och Back End, and both are password protected. The Front End has been converted to ACCDE.

When I try to import to Excel from Front End and/or Back End using database connections I receive a message telling me that I am using an invalid password (even though I use the same password when I encrypt/decrypt FE and BE). I've tried using Access import, ODBC and Microsoft Query. (In some cases I 'm also prompted to set a username, which I do not know which it should be since I haven't set one in my database (except the automatic "admin"))

How do I go about to make this work?

View 2 Replies View Related

General :: Updating Front End After Adding New Table To Back End In Split Database

Sep 22, 2013

I have split the data base

Added a new table to the back end .But do not know how to update it to the front end

View 4 Replies View Related

General :: Open Save File Dialog - Select File From Text Box And Save To Selected Location

Aug 8, 2013

I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !

View 1 Replies View Related

General :: Cannot Open Front End Access File

Jun 28, 2012

I was successfully using a front end and back end setup for the past two years. Today I needed to push through some changes and "deactivate" the previous back end database and setup a new back end database. The new back end database has been sent; however the front end is not recognizing the back end database anymore. I need to re-link the existing front end to the back end database - I cannot import the front end into a "fresh" file because I put a password on the VBA Editor.

View 14 Replies View Related

General :: How To Hide Or Disable The File Tab From Front Ends

Apr 12, 2013

How do I hide or disable the File tab in Access 2010 on my front ends?

The file tab being present allows end user to get into Privacy Options and Printing. Printing is okay if I could disable the Privacy Options for end users, then it wouldn't matter if they have access to the File Tab.

Possible very serious security issue!

View 2 Replies View Related

General :: Can't Update Front End To ACCDB

Mar 3, 2013

I am in the process of updating a database to 2010 (.accdb) and cannot get past a problem. We are using Access 2010.

I updated the back end data to .accdb with no problem. I can't link the front end to that data without updating the front end to .accdb as well. There are no tables in the front end.

I try to update the front end to /accdb and I get the error message 'You are trying to convert an encoded database. Decode the database, then try again.'

How do I decode the database? I tried setting a password and then unsetting it, but that made no difference. I have not previously encoded the database.

can't finish the update to .accdb data. The alternative is to stay with 2003 MDB data. Is that a bad thing?

View 2 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 :: 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 :: 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

Moving Back End To A Different Location

Jan 3, 2005

There is probably an easy answer to this but I can't find an exact answer searching.

I have an Access 2000 database with the back end stored in a separate location. If I want to move the back end data file to a different location on the computer, how do I change the link (file path)?

The only way I can figure out is to delete all of the old links and relink them from their new location.

Isn't there somewhere that you can just change the path name to the entire back end in one easy step?


Thanks for any help.

View 8 Replies View Related

Back End And Front End

Oct 19, 2007

Hi friends,

I think I am having some problem with my back end and frond end files. I have a mde file that anytime I enter new data or change some things in the old clients file, it does not update on the mdb file. Anytime I need to change forms or report or any thing at all, I am suppose to copy the BE file and the MDB file to my workstatio, remove the table link, make the changes I want to make on the design mode and then import the files back to the live copy of the mdb file then make another mde file to work with. But When I copy the BE and the MDB files, I don't have the updated client list or new client just added. So as not to affect other users, I can not make changes in the MDE file and even the MDE file will not even let me make any changes in design mode. I don't know If I am making sense but any help will be appreciated

thanks

View 10 Replies View Related

Front End And Back End

Oct 27, 2007

I am having a trouble with a multiuser DB. I have split it using the Splitter Wizard and have put a copy of my FE to a second computer and relinking its tables. When I opening the bound form in computer 1, computer 2 can not open that form and sometimes computers lock and had to restart the machines. But if I open that form in computer 2 first and then the same form in computer 1 , it works fine. I have set full sharing to computer 1. I am using Access 2007 and Windows VISTA.

Both have FE, the BE is located in a shared folder with full permissions in C: in computer 1, the FE of computer 1 is in that same folder. Both computers are connected via a Cat5e Cable.

FE in computer1 table links to c:databaseBE and computer 2 links to computer1_IP_Addressc:/databaseBE


Can anyone help me please!!!

I'd appreciate it a lot

Thank you!!

View 2 Replies View Related

Front End & Back End

Mar 23, 2007

Hi there, :cool:

I've one FE & BE related question here. Ok first of all I've BE in server and each user have copy of FE in local PC. But I've one problem with linked tables between FE & BE.

Is there a way that FE can programmatically create connection to BE linked tables or user is able to link those tables manually, if FE can't find/connect to linked tables in BE? Or do I just have to manually configure each users FE linked tables?

All replies are welcome and well approciated at all costs! :D

View 1 Replies View Related

Decompile Both Front End AND Back End?

Nov 22, 2005

Hope this isn't too silly, but I've just discovered "decompile". Instructions don't mention back ends and front ends. Do you have to run decompile on the FE and again on the BE, or is it sufficient to do it only on the FE (which has links to tables in the BE).

Cheers,
Christine

View 3 Replies View Related

Front End/Back End Issue.

Jan 26, 2006

I have a db that I have split out into a front end and a back end. The back end is on a network drive, and I have a copy of the front end on each user's computer.

The issue that I'm having is that 2 people can open the front end and 2 cannot.

When the database opens I have a form that loads on startup with a username/password combo.

On the 2 machines it works on, everything loads flawlessly, on the others they get an error message stating "\networkpathaccess.mdb" is in use

we are all using the same version of Access...

they are all using windows xp...

anyone have any ideas I can check out?

View 2 Replies View Related

BLOBS - Front End Or Back End?

Apr 18, 2006

I am about to place my database on a network. I have two extra folders in the database. The first contains excel spreadsheets that are lined to a form. The second contains .pdfs that are linked to a second form.

Where is the best place to put the folders, front or back end.

Many thanks for any assistance.

View 1 Replies View Related

Front End Back End Question

Jan 14, 2007

access 2000 with 30 users. 10 of which enter info. rest just use for reference.

I have all tables on network server all users get a front end access version with all queries, forms, reps, ect. Now I think I need to enable record locking but do not know what to do.

Do I enable record level locking for just the back end or only the front end systems? what is the best way to set it up? thanks.

t~

View 6 Replies View Related

Yet Another Front End Back End Issue

Feb 26, 2007

Hi All
I've been going through lots of posts in this forums, but could not find the perfect solution for my problem. I've got a front end database with forms. And back end database with data tables. The FE database is stored in all the computers with the linked tables in BE database in shared drive. I now want to totally disable the BE database from even being opened. The Data has to be so secure that people should not be able to open it(when they find out where the files are stored in). But it should still retrieve results based on data in BE database. I tried applying password to the BE .mdb. But it did not help running the front end. Instead came up with an error. Is there a way to restrict access to BE .mdb totally (as it is only a copy of the database I have in my drive). Any help would be greatly regarded.
Thanks

View 4 Replies View Related







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