Re: Problem opening an Access file from my computer

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

Thank you Joan for your reply.

I don't know that we can do the front-end/back-end with Access. Ok, i was
wondering if you would be kind to give me a direction as to where i can get
information about this.

Thank you in advance

"Joan Wild" wrote:

It is always recommended that you split a database. Having everyone use the
same copy of the mdb is asking for trouble.

Try splitting it. Put the backend on Fileserver - the backend contains just
the tables/relationships. The frontend would contain all other objects, and
linked tables - linked to the backend on the server.

Give each user a copy of the frontend on their workstation.

See if you still have the problem.


--
Joan Wild
Microsoft Access MVP

associates wrote:
Hi,

I was wondering if anyone here might be able to help me here. This
problem has been around for a while and i have posted it to many
forums but i still can't solve it.

I have been having troubled opening an Access file (mdb) from my
laptop. It has Microsoft Office Pro 2003 installed in it. The file
actually lives in the another computer called Fileserver. When the
file is open or being used by other users, i start to have trouble
opening it. I'm happy if it gives you a warning like you open in a
read-only mode. But it doesn't. Nothing happens when i double-click
on it.

Surprisingly, in the same scenario, i can open it using other
computers with no drama at all. I don't know if this is to do with
security or not.

Then, i did a bit of experiments there. First, i open up the access
application then go to Open file, select the same file that's on the
server, there it's open. So in my conclusion, if i can't open an
access file by using double-click, i have to run first the access
application and then open it from there onward.

But i believe there must be some logical explanation as to why i
can't open a file that's already being used by another user from my
laptop when i can do that with another computers. They both have the
same office pro version installed. I prefer to be able to just
double-click on the file to open it.

Could anyone be kind to help me get this to work?

Thank you in advance



.

Relevant Pages

  • Re: Problem opening an Access file from my computer
    ... same copy of the mdb is asking for trouble. ... Put the backend on Fileserver - the backend contains just ... I have been having troubled opening an Access file (mdb) from my ... laptop when i can do that with another computers. ...
    (microsoft.public.access.security)
  • Re: Apple Virus/Trojan Hits, Apple In Denial
    ... The threat is very low? ... How many computers did it infect? ... still very very very common and causes a lot of real trouble! ... It can create hassles on top of hassles. ...
    (comp.sys.mac.advocacy)
  • Re: "Portable" C compilers?
    ... trouble for running programs which are not approved. ... long as command prompt doesn't appear on the monitor. ... who does not consider it reasonable should give up the idea of any job involving computers because for GOOD reasons it is standard practice. ... Stop being insulting and start considering that there are serious reasons for not wanting random software run on shared computers. ...
    (comp.lang.c)
  • Re: Why dont you buy from HP?
    ... I have also owned 5 HP computers, no trouble with any of them either. ... One of their competitors went so far as taking a standard motherboard and swapping two pins on the power connector so owners couldn't do upgrades of the motherboard themselves. ... On the competing models, you basically throw the printer away if the print head has a problem, because replacing the print head is prohibitively expensive. ...
    (rec.photo.digital)
  • Re: Humax 9200t crashing / locking up
    ... Computers were never designed as consumer boxes. ... The trouble with set top boxes is that the broadcasters and their ... Switch off, count to 20, then switch on is always a good way of clearing any ...
    (uk.tech.digital-tv)