Splitting A Database

[Bruce]

Hello, I'm practicing splitting my Access database into a
backend and frontend. I'm using the Wizard to do this
which allows me to select where I want to file the backend
but doesn't say anything about how to file the frontend.
I've been reading up on splitting and a lot of people say
to put a copy of the front end on each users computer.
How would I do this? Once these copies are on each
workstation are they "live" and linked to the backend?
Would the front end go on their C drive or the Network
Drive where the backend is? Also my "Make MDE File" tool
option is grayed out, do I necessarily have to make the
front end an MDE? Help, please, I'm confused. Thx.

 

[Kevin3NF]

Bruce,

I generally put a copy on each user's C drive. Depending on the size, you
can email it to them or have them copy it from a share on the network (or
any other traditional means of moving files). They should be live when they
get it, as the links will be there. An MDE is not necessary unless you want
to strip out the VBA code so they cannot mess with it.

A tip on the links...when creating the BE via the wizard, do not use a drive
mapping to create it. Browse to the location where you want the BE via
Network Neighborhood. This will avoid all users having to have the same
drive letter mapped.

Post back if you need more info.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Bruce]

Thanks a lot Kevin, another question if you don't mind.
Can I make the BE read only except for myself and still
have the table updated by the FE if the FE is Read/Write?
Also I noticed on the FE I created that the tables and
queries still show, doesn't this defeat the purpose of
having the forms and tables separated? BTW, I'm no expert
on User Level Security so I'd prefer to stick with File
Level. Thanks again.

 

[Kevin3NF]

In the FE, do the table names have black arrows next to them? That would
indicate a linked table...

The BE needs to be read/write, or nothing will be written to it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm