sharing access

[patatrac]

hy for all...
i would sharing my database by intranet...
what's the most good way for release it....
create groups and users with the access 2003 function

or create file mde with link table and a sharing folder with create folder's authorization users....

 

[HiTechCoach]

Split your database into a front end and back end.

Front end: (I like to use MDE) is on each user's workstation on the local hard drive.

Back end: this mdb in in a network share

 

[SOS]

And there's a couple of good Frontend Auto Update Tools -

Bob Larson's

Tony Toews'

 

[CEH]

Agreed, wanted to add one thing I have found helpful. Remember not to use an absolute path to the backend....ie drive letter on server.... One stations server drive might be "F" anothers might be "Z"..... Use a path thru "Network places" this assures the frontend will work on any station.

 

[SOS]

Agreed, wanted to add one thing I have found helpful. Remember not to use an absolute path to the backend....ie drive letter on server.... One stations server drive might be "F" anothers might be "Z"..... Use a path thru "Network places" this assures the frontend will work on any station.

Great point!

 

[HiTechCoach]

Agreed, wanted to add one thing I have found helpful. Remember not to use an absolute path to the backend....ie drive letter on server.... One stations server drive might be "F" anothers might be "Z"..... Use a path thru "Network places" this assures the frontend will work on any station.

I ALWAYS have used mapped drive letters when linking. I have since Access 2.0 first can out. It has not been an issue.

 

[SOS]

I ALWAYS have used mapped drive letters when linking. I have since Access 2.0 first can out. It has not been an issue.

It really depends on your situation. If the people using the database might have different locations for a particular drive letter (and I've worked in many places like that) then UNC is probably the way to go.

If there are standard letters assigned to particular folders and everyone who will be using the database have this drive letter mapped the same then using a drive letter is not a problem.

But the big key is what the situation of your users is. It is not set in stone either way.

 

[CEH]

Well, I learned the hard way to do it like this......Our server drive was "F"... Someone added a PC with a mutli media reader..... occupied a lot of drive letters...."F" being one of them.... Take the pick of which you want to change...
I also remember when this came up searching through Microsoft... This was the method they suggested for various reasons.

 

[patatrac]

re

ok i think split db, and create 2 authorize groups for the folder of database
visitors
data entries ,more or less 10 person...

but i have another question..
data entries group have permission insert new data in TBL_CARS
in this method all person of this group possible delete and insert data
how is possible limit the delete/modify data only recordset that user had inser before ,and no all records