Importing data between databases

[Noreene Patrick]

I have searched and not found exactly what I am looking for..so here is my question.

I have a large database that works fine, IF people would stop trying to play in it!! What I want to do is to restrict access to everyone except managers.

So, I copied the db for warehouse users to input their data (picker id, no. of minutes) that holds only one table and the form that opens automatically (they do not have access to anything but the form) for their input...Then, at the end of shift I want the managers to be able to click a button on Switchboard that copies all entries for day into the original db to run their reports. (These dbs are on a network)

So, how do I manage this? I want to use a macro and transfer database table, then run an append query to put the current records in original table...I can do that, but I dont know how to delete the records in users db. It needs to clear out all records in that db when it has been transferred... I want all control to be in managers hands. All the users can do is input their data.

I know you can help, so I will say thank you now.

 

[Bat17]

Have a search on ULS, The built in security in Access is designed to cover just this sort of access control.
MS FAQ
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

HTH

Peter

 

[neileg]

An alternative is to split the database into front end and back end. Make a different front end for each class of user which only allows them access to the data they need. The back end will hold the data.

Access security is powerful and effective but a bit of a swine to set up. If you attempt to use it, make sure you have more than one back up of your database and read up about it in this forum.

 

[Noreene Patrick]

Thanks to both of you for your help...I was trying to stay away from security..I never have been able to implement security because I dont know enough about it and it is such a headache.

All I was hoping to do was:
to run a macro in the original db that opens up the warehouse db
imports the data from warehouse db
deletes the data in warehouse db so it will be a new shift's data.

That way, all my data will be in the original db. I will have a button on switchboard that runs the macro..Each manager at end of shift will run the macro, empty the warehouse db and have a fresh db for next shifts manager. Then they can run their reports. I just wanted something simple. (My abitlites are simple)

Thanks in advance.

 

[Bat17]

from your main database, link a table to the warehouse one.
You can then just run an append query to add the data from their table to your main one followed by a delete query to empty their table.

HTH

Peter

 

[Noreene Patrick]

A link is all I need? Even if the warehouse db is on a different drive than the original? And by linking, is there any way some user could access the original db?

 

[Bat17]

As long as you can see them on the network you can link to them.
Links are one way, you can watch them they cant see you

Peter

 

[Noreene Patrick]

I tried it and it WORKS GREAT!!!! Just what I needed...thank you so much Peter...

 

[Bat17]

Bet you still end up wanting security LOL
Its the managers you have to stop fiddeling with the numbers not the workers

Peter