Database Split

[Franco]

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?

 

[Albert D. Kallal]

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.

 

[Franco]

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?

 

[Albert D. Kallal]

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]

Thanks you have been a great help to me, one last question.

Is it possible to just use the "Get External Data" option in Access? I ran

that a test db and it seemed to extract all tables, Queries and forms. Here
is the thing though, when I tried to run the (Forms) switchboard it errored
out on me. It gave me a VB format box. Is it possible to just use the "Get
External Data" option in Access?


It is not 100% clear what your question is?

Lets assume we have a split data base:

MyCoolSystemFE (front end)
tables --------linked tables to ---------------> MyCoolSystem_BE
(back end).
forms
reports
modules

MyCoolSystem_BE (back end)
tables

Now, lets create a blank new database called test1

Now, lets open up the database test1

If I go Get external Data..and import things from the front end called
MyCoolSystemFE, then can import all of the objects from that front end.
However, that front end does NOT have any tables for data..but only "links"
to that data. So, I can try to import the "tables" shown in the tables
tab..but that is only going to import those "LINKS" to the back end
database.

You see the same effect if you browse to a folder in windows. You can right
click on a word document, and then create a shortcut to that document. That
shortcut is really only a link to the document. You can copy the shortcut
many times over..but they all look back to the original document. If you
delete that document..then the shortcut is of no use (try this now with
windows..and a test word document). So, those linked tables are the same as
shortcuts..they don't have any data..but just are a "link" to the actual
tables in the back end part of the database. Just like that shortcut..it has
no data, and does not even have information about the fields or anything...