Access 2000

[Pamela]

I have been using FileMaker for 6 years and have recently
switched to a job where they use Access 2000. I would like
to network this program as opposed to using Shared files
and am having trouble figuring it out. Does anyone know if
this is a feature available on this program? I'm concerned
that it's too old of a program for it.

Any suggestions? I really don't want to have it set up as
a shared file.

Thank you.
(e-mail address removed)

 

[Rick Brandt]

I have been using FileMaker for 6 years and have recently
switched to a job where they use Access 2000. I would like
to network this program as opposed to using Shared files
and am having trouble figuring it out. Does anyone know if
this is a feature available on this program? I'm concerned
that it's too old of a program for it.

Any suggestions? I really don't want to have it set up as
a shared file.

I'm not sure what you mean by "network the program". If you use Access as the
front end to a server database like SQL Server then the Access application
connects over the network to the server. If you use an MDB file to hold the
data (Jet) then you have to use a file share.

 

[Van T. Dinh]

JET (the default database engine used by Access) databases
are file-sharing databases so you will have to share the
data file unless you use another database engine, e.g. SQL
Server.

OTOH, to minimize the sharing, you can split your app into
Front-End and Back-End. See Tony Toews' article:

<http://www.granite.ab.ca/access/splitapp/index.htm>

HTH
Van T. Dinh
MVP (Access)