Re: Please Help! I want to turn my old PC into a File Server

Thanks so much for your help. Have a great day! :)
--
Nikki


"Douglas J. Steele" wrote:

Copying it to your machine, making the change, then replacing the old copy
would be the safest approach, although you could just open the back-end from
your client machine. The point is that Access always runs on the client, not
the server.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nikki" <Nikki@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A2906D9-AC70-49A0-A40C-1EFBE621795A@xxxxxxxxxxxxxxxx
Thanks a million, Douglas. But still confuse something--If I don't have to
install Access in my old PC (file server) and I want to change any design
on
my tables (BE File), do I have to copy it back to my PC which has Access
program to change it, correct? I'm new with Access and network so sorry if
I
ask any silly questions. Thanks again! You have a good day! :)
--
Nikki


"Douglas J. Steele" wrote:

Access does not need to be installed on the file server.

Yes, all files need occasional compacting.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Nikki" <Nikki@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA09BCB9-9299-4E8D-9115-3BE0CF3B0736@xxxxxxxxxxxxxxxx
Thanks for your info, AnandaSim. I just want to make sure that I
understand
it right. If I want to turn my old PC into a File Server and save my BE
database there, I do need to install Access program in the old PC,
don't
I?

And one more question, now I save BE database on my PC, not old PC and
it's
slow when we use FE database at the same time. From what I read, I do
need
to
compact BE and FE database files, is that correct? Thanks again for
your
kind
support.
--
Nikki


"AnandaSim" wrote:

On Sep 25, 8:06 am, Nikki <Ni...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi my company is very small--we have only 3-4 employees and I have
one
old PC
which is Windows 2000 and 3 new Windows Vista 2007 computers. If I
want to
turn the old PC into a "File Server", is it possible that when I
link
all of
3 computers to the File Server then they can share files together?
Do I
have

Yes. they can share files and printers.

Are they already connected with network cable?

any problem with that because of old version and new version of
Microsoft? (I

No, there should be no problem with different versions of Windows (in
general).
BTW, Microsoft is the brand, Windows is the product.

know that I have to add memory and network card to the old PC but
"Do I
have
to buy Vista and install it in the old PC as well?") I want to save
my
Access
(2007)database backend in the File Server so other 3 new computers
can
share
the database but I'm not sure that I can do it. I'm new with Access
and
computer network so I do appreciate for any suggestion. Thanks

I remember in another thread, SteveM and myself were discussing
sharing files using Vista and Access? Did you manage to complete the
task? If that worked with Vista, that should also work with your old
machine.

There are newsgroups which discuss Windows networking and there are
websites and articles on the web that teach you some stuff.

hth

Ananda








.

Relevant Pages

  • Re: Please Help! I want to turn my old PC into a File Server
    ... If I want to turn my old PC into a File Server and save my BE ... database there, I do need to install Access program in the old PC, ... which is Windows 2000 and 3 new Windows Vista 2007 computers. ... computers to the File Server then they can share files together? ...
    (microsoft.public.access.gettingstarted)
  • Re: linking tables from code and locations
    ... ACE database, my advice is to use DAO. ... Doug Steele, Microsoft Access MVP ... The connection string for ... linked Access tables will have;DATABASE= at the front of it. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Datepart function
    ... I have not tried compiling the database. ... TheVisual Basic module contains a syntax error. ... I take back what I said about References. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Working with a Split Database
    ... Doug Steele, Microsoft Access MVP ... I update this database regularly. ... Should everyone work on a shortcut instead? ...
    (microsoft.public.access.setupconfig)
  • Re: suppress SHIFT key
    ... "Douglas J. Steele" wrote: ... You might find it easier to download Albert Kallal's By Pass Shift Key Code, ... Doug Steele, Microsoft Access MVP ... To suppress the shift key bypass, you need to create a database property ...
    (microsoft.public.access.formscoding)