I have a split database. My backend Relationships aren't updating to my front end. How do I get my front end relationships to update to what my back end looks like? All tables are LINKED not imported.
View RepliesI 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.
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
I am splitting a database and have created the Back end already. When I create the front end and link to the tables on the back end... The front end does not link to all the tables in the back end. The list that comes up when creating the linkings does not show all the tables in the back end. What would cause this?
View 1 Replies View RelatedI have split database (B/E is in the SharePoint library, F/E has users on a local PCs). Sometimes, when I update/add data (does not matter if it is via form or directly in the table) it looks OK, but when I re-open the database, the data are gone.
Problem is that I cannot catch the moment when data were not saved (sometimes data are saved, sometimes not). I can point out this: if I re-enter the missing data, primary key continues subsequently, it looks like the data have never been entered. I tried to use script
Code:
If Me.Dirty Then Me.Dirty = False
on "On Close" form event, does not work.
B/E is linked by VBA code and it looks OK (no error, Link Manager shows correct path). I suspect interrupted connetion to the SharePoint but I don't know how to check it. I implemented VBA script co keep open connection to the SP but the issue persists.
I have split my A2013 db into FE and BE, and while it seems to be working OK, I notice that if I look at Relationships in the FE, some of the relationships are missing, though they are still there if I open the BE directly and look there.
Which view of the relationships is correct, how do they get to be different, and how do I force them to be the same ?
I currently have a front-end/back-end database, but at some point in time one of the tables has been modified and whenever the front end connects it comes up with a parameter request for a field that no longer exists. I have narrowed it down to MSysQueries, where there is a reference to this field. Is there anyway I can avoid this or change/repair the system table?
Compact and repair doesn't work unfortunatly.
Thanks
Hi Guys,
Thanks for all your help on my last post, again have a problem to update the application, Everything works well but then I need toadd an extra table on my app. At first I thought I can add a table on my Back-End but when I open the Front-End it wont update.
Can someone out there help me how to add a table on apps. from the ground up?
Thanks in advence.
Jepoy
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
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!!
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
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
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?
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.
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~
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
Hi guys,
I need help with security settings and that. I have a database which i want available on a shared server. Basically i only want people to beable to see one form but not beable to see anything else or make any changes to this form.
Do i need to split and make a front and back end? I will want to make occasional changes to tables etc.. and so would want this to automatically update on the database seen by everyone else.
Sorry, not making much sense but am bit confused about it all!
Any help from some clever peeps?
Ta
Could someone please explain, how you would do a front end back end?
do you have forms in DB 1 (Front end.)
And tables in DB 2 (Back end.)
Where would the reports and that go? front or back? or am i completely wrong? and what are the benifits of a front/back split? networking?
Thanks in advance
Den
I have a live split db running which has recently run into a problem. When one user1 has a report open, user2 cant enter data into the table that the report is using. User2 gets a blank grey data input screen , apart from the form header. Similarly if User1 is entering data , and User2 tries to pull a report using the same table the message reads , could not lock table , currently in use by User1. Both Fes are on separate local machines.
I've had a check through my settings. On the advanced tab of Tools , Options default open mode is set to shared and default record locking is set to no locks.Plus open databases using record level locking is not on., both on FE and BE..
But, users 1 and 2 can pull the same reports simultaneously or enter data into the same table simultaneously but not one a report and the other enter data.
Gentlemen,
I have a single database that I would like many people to use concurrently. The db will be stored on a security clamped network with my users logging on with there own individually user accounts.
Does anybody know the simplest way of creating a distributable user front end that would allow simultaneous use by many people?
Any and all advise is greatly appreciated.
Hello,
I have a backend database and front end mdb file with forms. I established the necessary relationships in the back end, however when I open Relationships screen in the front end - it opens empty. Do I have to establish same relationships in the front end or can I leave it as it is and still have my relationships work as defined in the front end?
Maybe someone could help.
thanks
giedrius
I had posted this in another area but didn't receive a response and my whole project has ground to a halt until I sort this out :(
I have made a database with front and back ends. Now I wish to be able to use the front end over the Internet but the IP address of the back end keeps changing weekly because of my ISP.
Now I have made a splash screen at the start of the program which asks for the IP address and when this is entered the front end links to the back end - but I can't get the code right for this
The code I have at the moment is embarrasingly wrong so I'm not putting it up here
The code I have at the moment has a box that asks for user to enter the IP address - I need it to use the IP address to enter the database at ip//data.mdb
Regards, James
I need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...
View 3 Replies View RelatedI have a database that I built as one large database, then used a method I found on here to creat 2 brand new databases and copy the tables from the original to one and use it for a back end and then copy everything else to another file to use as the front end. I did this and it worked great, except that now the information being input into the forms on the front end is not being recorded into the back end. I tried relinking the tables and it still was not working. Is there a secret step I missed or something I need to fix in order to make this work properly? The way I made the front end dependent on the back end was by linking the table from the back end to the front end. I checked the object dependencies and it shows those as being correct. Any suggestions or comments would be greatly appreciated!!! I am truly only a novice when it comes to Access and just in the past 6 months or so have been using it regularly.
Thanks in advance.
I work for a real estate company that uses Access to keep up with showing requests. I designed the database and I'm an amature. The database is fully functional but I would like to create some sort of log-on screen switchboard to restrict access to tables and such to me alone. I've got the idea behind the switchboard wizard but I want 2 or 3 passwords depending on who is accessing the database.
Also, I was trying to split the database but when I try to copy the forms etc.. database to another computer I can't edit the tables. I had the tables in a shared folder and allowed editing of it, but it wouldn't edit. Does the form database have to be stored on the same computer as the table database?
I have an MS Access front-end with a SQL back-end database. It works great, I connect the MS Access front-end to the SQL back-end using a File DSN.
I have a few users (who are in the database the most) who get ODBC disconnection errors time to time. The cause of the error is not consistent, they seem to just appear out of no where. The table that reports the disconnection is not consistent either.
The only way for the users to resolve the errors is to exit the MS Access database, and then re-enter it.
I have had the DBA team analyze the SQL server, and it does not appear to be having any difficulties. We moved the database to another server (so it would be on a server with less traffic) and I rebuilt the File DSN. But the errors continue.
I will have the network team look into any errors, but I am not certain if they will find anything or not.
Has anyone run into this, and what resolutions did you come up with/work arounds did you perform? I am starting to consider upgrading to a Visual Basic .Net front-end, but wanted to see what options were left.
Thank you for your time.
T.J.