Question Access Database

[awake2424]

Is it possible in Access 2003 to create a database in on location, say on an H: drive, and have a copy of that database appear on another drive, say G? When the database on H: (which has full control) gets updated those changes appear on database on G: which is read-only. How can this be done? Thanks in advance.

 

[Rabbie]

Tp clarify what you are asking. How often should the Gdrive Db be updated?

1) Every day
2) Every hour
3) Immediately after every change.

1 or 2 would not be impossible to implement. 3 might be a little more difficult.

Why do you want this?

 

[MSAccessRookie]

Is it possible in Access 2003 to create a database in on location, say on an H: drive, and have a copy of that database appear on another drive, say G? When the database on H: (which has full control) gets updated those changes appear on database on G: which is read-only. How can this be done? Thanks in advance.

Maybe what you want is a Database with two Front Ends, one of which is able to update the data, while the other has Read Only Access to the data. If you hide the location of the Back End, and prevent the users from getting to the Database Objects Window, the effect might be the same.

 

[WayPay]

No. What you can do is create the h: drive mapping with full permissions (for the data entry people) and create the g: drive mapping with read-only permissions (for the people that only need read-only access). Not sure how Access will handle the .ldb-file in the read-only scenario, though.

 

[awake2424]

I plan to update this database evryday to every other day. I need to do this so that the database is controled by one user and can niot be modified or changed by the other users, rather they can view what has been inputted. Thanks.

 

[Rabbie]

I plan to update this database evryday to every other day. I need to do this so that the database is controled by one user and can niot be modified or changed by the other users, rather they can view what has been inputted. Thanks.

In that case you just need to copy the DB from one drive to another at a fixed time each day. preferably at a time when no-one is using it.

 

[MSAccessRookie]

In that case you just need to copy the DB from one drive to another at a fixed time each day. preferably at a time when no-one is using it.

I agree with Rabbie. My original answer was based on an assumed need for immediate and interactive updates.