Re: Database Split

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Albert D. Kallal (kallal_at_msn.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 11:09:02 -0600

"Franco" <anonymous@discussions.microsoft.com> wrote in message
news:02D27AEA-432A-47A7-B650-FEE7D051DA47@microsoft.com...

>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

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)