Split Database Setup

[Megan]

Hello,

I have a database that was created in Access 2000. I would like to
distribute this as a split database application, but am unsure of how to do
it. I haven't found much information, with the exception of this:

http://support.microsoft.com/kb/q162522/

I have the database split into a front end and a back end. The part I'm
stuck at is creating the setup files. The backend will be on a Windows NT
4.0 SP5 server (this can be changed if necessary), and the front end will be
on various Windows versions ranging from 98 to XP.

Does anyone have any information that would help me along in this little
project?

Thanks,
Megan

 

[Rick Brandt]

Hello,

I have a database that was created in Access 2000. I would like to
distribute this as a split database application, but am unsure of how
to do it. I haven't found much information, with the exception of
this:
http://support.microsoft.com/kb/q162522/

I have the database split into a front end and a back end. The part
I'm stuck at is creating the setup files. The backend will be on a
Windows NT 4.0 SP5 server (this can be changed if necessary), and the
front end
will be on various Windows versions ranging from 98 to XP.

Does anyone have any information that would help me along in this
little project?

Thanks,
Megan

What setup files? In a split arrangement like this all you are installing
on each client PC is the front end so the the back end file doesn't even
enter into the setup. You do the exact same setup as you would with a
monolithic single user app except that the front end file is actually linked
to the back end file on your server.

If you properly used UNC paths to link your tables (not a mapped drive
letter) then the only other thing to consider is that each user needs
network permissions to the back end folder.