Accesss 2007 db

[Sam]

Is it possible to store an Access 2007 db on a network drive and use it as
one wouild an Access 2003 db? Someone told me that Access uses "trusted
locations" tat may require using Share Point is this true?

Thanks

 

[Douglas J. Steele]

Sharepoint is not required to set trusted locations.

To set a folder as trusted, click:
- Office Button (top left)
- Access Options (bottom of dialog)
- Trust Center (left)
- Trust Center Settings (button)
- Trusted Locations (left)
- Add new location (button)

 

[Tom van Stiphout]

In addition to what Doug said: it has never been recommended to put
the front-end on a server, au contraire. You should put the FE on each
machine in a trusted location, and the BE on a server.

-Tom.
Microsoft Access MVP

 

[ace]

Sharepoint is not required to set trusted locations.

To set a folder as trusted, click:
- Office Button (top left)
- Access Options (bottom of dialog)
- Trust Center (left)
- Trust Center Settings (button)
- Trusted Locations (left)
- Add new location (button)

Thanks. That'll work for me.

 

[ace]

In addition to what Doug said: it has never been recommended to put
the front-end on a server, au contraire. You should put the FE on each
machine in a trusted location, and the BE on a server.

-Tom.
Microsoft Access MVP

I'm not sure what you are saying, but all users have Access
(Office Suite Enterprise) installed on their PCs and the db will be stored
on a network drive in a trusted location.

 

[ace]

More 240 users need to access the db we'll have to do this with each PC?

I don't know, but will a SharePoint location cause less configuration for
the users?

 

[Douglas J. Steele]

I'm not sure what you are saying, but all users have Access
(Office Suite Enterprise) installed on their PCs and the db will be
stored
on a network drive in a trusted location.

Tom's point (which is absolutely correct) is that the application should be
split into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the tables and relations). Only
the back-end should be on the server: each user should have his/her own copy
of the front-end, preferably on his/her front-end.

 

[John W. Vinson]

I'm not sure what you are saying, but all users have Access
(Office Suite Enterprise) installed on their PCs and the db will be stored
on a network drive in a trusted location.

Tom and Douglas are absolutely right (as usual) on splitting the database; if
you have multiple users sharing the same unitary database you're going to get
bad performance, user conflicts and a major risk of corruption. For a detailed
discussion see Tony's site: http://www.granite.ab.ca/access/splitapp.htm

 

[Douglas J. Steele]

I believe you can set Trusted Locations through Global Policies.

 

[Tom van Stiphout]

On Tue, 21 Jul 2009 10:05:09 -0600, John W. Vinson

John, Douglas, and Tom are absolutely correct as well - LOL - could
not resist.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

On Tue, 21 Jul 2009 10:05:09 -0600, John W. Vinson

John, Douglas, and Tom are absolutely correct as well - LOL - could
not resist.

"One for all! All for one!"

-Dumas, _The Three Musketeers_