Splitting Database for Deployment

[lzook88]

...... I am looking at deploying a recently made database over my company's network. Here is where the issues began.... and I am not sure that I can accomplish this easily enough.



We have multiple networks drives. Each network drive is for our locations.

i.e.
BLD1
BLD2
BLD3
BLD4
BLD5
BLD6
BLD7

each folder allows only certain users to access them. I have access to them all as the programmer for the company. But I want to store the BACKEND of the database in a separate folder called BLDMain. And then a copy of the front-end in each of the BLD1 - BLD7 folders.

Issue in hand.. a member of BLD1 opens the database with out having permissions to BLDMain. Is there a way to write code that would login to the BLDMain folder using a set username and password?

Thanks,
Louis

[ItsMe]

I believe there is a way. However, your IT department may not want this. Perhaps it would be best to use SQL server as the backend and allow IT to maintain control through SQL server. In other words, you may go against company policy using your User and Pass to create backdoors.

[JamesDeckert]

Your front end should reside on the local computer, not a network drive. Each computer should have its own copy.