Accesss 2007 db

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
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)
 
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
 
Douglas J. Steele said:
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)
Click to expand...


Thanks. That'll work for me.
 
Tom van Stiphout said:
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
Click to expand...


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.
 
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?
 
ace said:
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.
Click to expand...

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.
 
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.
Click to expand...

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
 
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
 
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.
Click to expand...

"One for all! All for one!"

-Dumas, _The Three Musketeers_
 
Back
Top