Splitting a database

[umair434]

Hi,

I am done with my access application thanks to this amazing forum! I already feel that I have learn so much in just a month.

Anyways, this application will be used by multiple users on a network. Application is about data entry for each of their users -

Now, where should I put the backend of this database? the only trusted location I see is under
C:\Documents and Settings\umair.khan\MyDocuments\Trusted\EUCApplications

should I put the backend here? if so, how should I put the front end on everyones desktop so they can access it without getting the warning.

thanks guys!

 

[stopher]

Now, where should I put the backend of this database? the only trusted location I see is under
C:\Documents and Settings\umair.khan\MyDocuments\Trusted\EUCApplications

The backend should go in a shared network location. All users will link to the same backend i.e. there is only one backend (although you should have a backup of it)

if so, how should I put the front end on everyones desktop so they can access it without getting the warning.

It's up to you where you put the front end but each user should only be able to open there own copy of the front end. I normally create a new folder of the C: drive and then make it a trusted location. The reason I do this is because I don't want it backed up with all the user's stuff in My Documents - there's no need because if they lose it I'll just re-install it.

You can provide shortcuts to the front end for the user if you like e.g. on their desktop.

hth
Chris

 

[umair434]

Thanks chris! the form takes quite long to open when I put the backend on the network shared drive. This doesn't happen when I put the backend on my local drive.

why is that happening? and any solutions, if possible?


thanks again!!!

 

[AccessBlaster]

Hi,
I am done with my access application thanks to this amazing forum!

Thanks chris! the form takes quite long to open when I put the backend on the network shared drive. This doesn't happen when I put the backend on my local drive.
why is that happening? and any solutions, if possible?
thanks again!!!

As you can see your never really done MUHHHAAA!!!

 

[JANR]

Thanks chris! the form takes quite long to open when I put the backend on the network shared drive. This doesn't happen when I put the backend on my local drive

Have a look here: http://www.granite.ab.ca/access/performancefaq.htm

First fix is to keep a persistent connection to the backend you fint out how by clicking on "LDB locking which a persistent recordset connection fixes" in the link

JR

 

[GinaWhipp]

I see the from your original question no one really discussed Trusted Locations. It is not an existing folder on your harddrive. It is a folder you set up. Hvae a look here...

http://www.access-diva.com/d4.html

...this would have to be set up on whoevers machine has a front end, see...

http://accessjunkie.com/faq_33.aspx