Split Database problem...

[kaschlegel]

I'm very new to Access, and i'm working with Access 2007 to set up a database for my company.
I got the database functioning and I was happy with it. I set up the database on a common drive, so the employees could enter data into the forms. Then, I stumbled across the option about splitting the database, so they wouldnt have access to the back end tables. I did that, and stored the BE files in my documents on my computer. I can't find the front end files anywhere. I'm assuming it shows as FE if the back end are showing up as BE. The original database (that I did back up), is showing on the common drive, but the employees don't seem to be able to open it. It brings up the blank access screen with option to enable the data, and it stops there. Nothing opens.
I'm sure I messed up something simple, but please let me know if I can fix this easily. Otherwise, i'll just delete the messed up ones I have and work with one of the back up copies.
Thank you!

[rzw0wr]

Only the Back End file changed names. be.
The Front end file name remained the same and the tables should show links to the back end file.
The back end holds only the tables. The front end hold the working part of your app.
If you move the FE or the BE you have to relink the BE to the FE.

I think you need to relink the be tables to you fe.

Use the Linked Table Manager in the External Data tab at the top of your screen.

Let us know if you need more help.

Dale

[kaschlegel]

Thank you, that solved that problem.
I have a related problem, also. One of my forms was split, and included a few lines of data from a table on my BE database. It's data that the employees need access to for updating. Is there a way I can provide them access to their last few entries on my table, without giving them access to all of it?
If not, I need to not have a split database, so is there a way to UNsplit it and protect it from accidentally deleting or typing over existing data?
Thanks so much!

[rzw0wr]

You can go to External data, Access and copy the tables back into your database.
Delete the liked one first.

I am not real good at queries and SQL.
You could make a table that held just the names they could access and use this as the data source for the form.

The only way I know of protecting data from over write or deletion is to lock it. Then you can not add to or edit it.
It would be read only.

Maybe another member has some idea.

Dale

[Dal Jeanis]

KA - Your front end is linked to your back end, and you can allow the front end to link to any table in the backend database to update the table. Otherwise, backends wouldn't be useful for most applications. All you have to do is create a query in the front end, accessing the linked table in the backend, defining "their last few entries on my table" in some specific way (for example, all records with the front end's currently logged on user id and a date less than five days old) and use that query in the desired form in the front end. You're done.