PC Review


Reply
Thread Tools Rate Thread

Access DB sharing/permissions?

 
 
Larry Bowers
Guest
Posts: n/a
 
      10th Aug 2003
I have two different supevisors that have different PCs.
They both share, on the server, an Access DB. They are
both required to make changes to it. One supervisor is
running Access 97 on Windows NT 4 and the other Access
2002on Windows 2k. When the supervisor who is running
Access 2002 trys to open the DB from her PC she gets an
error. The error says something like: "You are attempting
to access a database, you need to copy the database to
your local PC and make the changes there." I trying to
avoid copied over files. Example: If one supervisor
spends 3 hours making changes to the db and saves it, it
might over-write the other supervisor's changes and both
changes are needed. Is this making sense? I guess I am
trying to find a way to have them share without changes
each others work but each others work is added to the DB.
Thanks in advance for any help that can be provided!

Larry
 
Reply With Quote
 
 
 
 
Judy Rudek
Guest
Posts: n/a
 
      12th Aug 2003
You might be better off splitting the database into front/back end.
Each supervisor would have the forms in a local database (on their
machine). Each would link to tables in the database on the network.
I'm assuming here that your database is in Access 97. Access 2002
should be able to link to an Access 97 database transparently without
needing to convert it.

Hope that helps.

-- Judy
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vista network sharing problem (access and permissions) Jannoth Windows Vista Networking 3 6th Oct 2008 10:03 AM
Access permissions on folder. Owner cannot grant permissions =?Utf-8?B?bG1leWVy?= Microsoft Outlook Installation 0 14th Jun 2006 11:06 AM
access permissions and sharing files John Windows XP Networking 0 26th Mar 2004 10:43 PM
Sharing permissions =?Utf-8?B?R3JlZw==?= Microsoft Windows 2000 Group Policy 0 29th Sep 2003 05:46 PM
Help Needed Re Setting Folder "Access Permissions" For File Sharing on Home Wireless Network xdocx Windows XP General 1 28th Sep 2003 02:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:20 PM.