 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2004Database Split
I had recently split a database but my co-worker not knowing that I did so deleted the database with the _be. extension. The one that gives me access to the tables and etc. All we have now is the front end which does not allow me to go into anything. I had set the front end so no customizing options would show. Is there any way of recreating or retrieving the _be. part? >Is there any way of recreating or retrieving the _be. part? You simply mean a file was deleted. The approach to recovering a delete file is the same as when you delete a important word doc, or important excel doc. You go to your back up? Did you look in the recycle bin? (of course..if this was on the server...and you delete it from a pc..then the file does not go to the re-cycle bin). Regardless...you can't possibly try and run a information management system, be it word, excel or ms-access. In all cases you need daily backups of any documents. In fact, I am seen more an more companies not even allow employees to save files on their local computer..but everything is saved on the server...where proper daily backups are made. So, you install applications like Word, or Excel (or even the appcltions you just made) on each pc. And, the data files can be put on the server. Perhaps you have a un-split database copy hanging around.....and can grab the tables from that? It is not clear if the back end was on a pc, or on a server? If it was on a server..then why do users EVER need to browse to that backend folder? One of the MAIN reasons you split is so that each users pc gets a COPY of the mde on THEIR OWN pc (you NEVER EVER should allow multiple users into that front end...so put a copy on each pc).. Your users can just click on this..and it just works! And, if they delete the front end...again no problems. (but the back end is on the server). So, really, users don't need to know where the back end is..and should never need to browse to that folder anyway. Of course, as mentioned...if this is single user pc..then that back end would be in the recycle bin if not yet empoted. -- Albert D. Kallal (MVP) Edmonton, Alberta Canada pleasenonoSpamKallal@msn.com http://www.attcanada.net/~kallal.msn Thank you for your response, it is on a server. Unfortunetly, it was deleted completed. I tried exporting the tables but when I run the switchboard I get the VB prompt telling me that a line is not valid or needs to be fixed. The only reason I noticed that there was a problem was because another user tried to access the db, input information. When she tried it gave her an error message of the database is currently being used by another user in a specific PC. I then went to my server to look at the permission on the access db and could not find _be copy. Any suggestions? >When she tried it gave her an error message of the database is currently being used by another user in a specific PC. I then went to my server to look at the permission on the access db and could not find _be copy >Any suggestions? Well, at this point, I assume now you have a new back end..right? I mean, you deleted a file. Obviously nothing is going to work until you re-create the back end tables (or restore the back end from your last backup) I can't imagine a company running a server without it being backed up every day). So, to get your back end back, you have to either go to a backup, or if you don't have that..you need to re-create the tables by hand. There is no other solution here. However, to prevent that message of the database being in use in the future, you need to supply each pc with a copy of the front end. Those copies as mentioned should be a mde. That will fix the problem of the database currently being in use by another user. You can read up on splitting here: http://www.granite.ab.ca/access/splitapp.htm http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm -- Albert D. Kallal (MVP) Edmonton, Alberta Canada pleasenonoSpamKallal@msn.com http://www.attcanada.net/~kallal.msn |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.