Replies

Well all,
The network guys changed the permissions on the network folder where the back-end of this distributed database lives. Now everyone who needs to get to it can, including me. I am reviewing the rules on securing a database now but am curious about one thing regarding split databases. If I password protect the back-end, can I encode that password in the users’ front-ends so they can function normally without having to know the back-end password? (see where I’m going with this?)

Thanks again for all your help and suggestions.

Wendell, Hans, et.al.,
First, I am reading the document Hans suggested and it appears that one way to solve my problem is to create a new blank database and import the tables into it. Apparently, permissions are not imported with objects. I will try this tomorrow. (It is now late here too.) But, I have a couple of questions if you please.

1. The “Open Exclusive” means that the user may perform any action that requires the database, table, or other object to be opened exclusively. It does not mean that when the user uses the database, it is always exclusively. Is this correct?

2. How can I tell if I am Admin when I log in, and what permissions I have?

3. I noticed that the “Open/Run” is disabled. Has Admin been altered some way to disable this?

4. When I attempt to open the Back-end database on the server, I get the following message…

Could not lock file. (Error 3050)
The operating system will not allow Microsoft

Thanks.
In my quest to secure the back end databases, I think I locked myself out. I am trying to understand how to give myself the privliges needed to look at the back-end tables. (see error message below.)

…You do not have the necessary permissions to use the object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)

I was trying to reset the settings back the way they were before I made changes. I opened the back-end database, and did the following:
Tools | Security | User Groups and Permissions |
User/Group name: Admin Object Name:

and selected Object Type “Database” then unchecked “Open Exclusive”

What should the setting be so that I can view the contents of the back-end tables?

Thanks Wendell,

It turns out that one of the users was in the back-end in design mode, “…just checking it out…”. (despite my request to all users not to open the back-end) Is there a way, on our network to hide the back end database? I think it is easy enough for some users to know how to “show hidden objects”. Is there a way for me to assign some form of security that prohibits users from seeing the back end databases without hindering their ability to use the front end? I am currently reviewing “Manage user and group accounts” from help. Any other resources appreciated.

Many thanks,

Single table works much better. By turning on a “NewEmployee” yes/no field in each record, we differentiate between pending new employees and current employees. Active employees are identified as those whose termination date is null.

A question about efficiency: When DLookUp is run from a front end, does it return an entire table from the back end over the network and then do the filtering for the record? Or is filtering done on back end and only the selected record sent across the network line? Is it more efficient in a split db model to have DLookUp or maybe a combo box who’s rowsource is a query?

Thanks,

Thanks for the handholding. UNC links are in place. Network guys are happy. Life is good. I also found some code on this site that seems to establish and refresh links each time a db is opened.

Got it. This works better than after update. Thanks!

Thanks for the pointer.
I am using the After Update event of the textbox where the user enters the SysID because I want them to get the message at the time of data entry. The final step of appending the new employee stuff to the current employee table comes after HR reviews all the info and clicks a “Save Record” command button. It is my hope that by then, all the information will have been validated and corrected if necessary.
Thanks again,

Still getting the same error but I did move the msgbox to the Err_SysId_AfterUpdate: and now, at least, I get my message to display instead of the system message. However, it is apparent that the error occurs before the DLookup has completed. When I test with a SysId that is already in use, it jumps to the error handler and never turns the bln to TRUE.

Thanks Charlotte. As always, this board is a great help.
When I set the Group Header property to Keep Together Whole Group, I don’t get 2 records per page as required. This is why I am trying to force a page break after every 2 records.

Regarding using the group header to control page break, this is a carry over from Access 97 Help (search for “page break” and followed the instructions for VB Code) that I used in other Access97 reports.

My report is grouped by Client (Header-yes, Footer-no) and the detail section contains some fields and a subreport. The subreport contains a memo field in the detail section and no report or page headers or footers.

In the detail section of the main report, I have a text box (txtRecordCounter) whose control source =1 and Running Sum property set to “Over all”.

So, I am trying to force a page break after each 2 clients. I inserted the code you suggested and still am getting a blank page on the end if I select an even number of clients.

My next step is to evaluate the txtRecordCounter.value and if even, set [Pages] to [Pages]-1 or something like that. Not sure how this will work and always interested in other suggestions.

Many thanks,

An example of what mark said is attached. see Meetings.mdb

I had a similar situation that I solved in this way. I made a table of all names and addresses called tblContacts and a table of contact types called tblContactTypes.
The fields for tblContacts included the usual, FirstName, LastName, CompanyName, Addr1,…..then a series of fields to indicate which lists they belonged to. ListId1, ListId2, ListId3… to ListId25 (probably breaking table normalization rules but it worked)

The fields for tblContactTypes were ContactTypeID (key field, indexed, no duplicates) and ContactTypeDescription

A form had a combo box with row source tblContactTypes and a filter the returned the records based on the users selection.

Another form was used each time a new type of contact list needed to be added. It never got larger than 25 which was fairly manageable.

Hope this helps.

Thanks,
This works fine and I did changed the field name.
I still would like to know how to pass the results of an SQL statement back via a function. Do I need to create a recordset?

As always, this board is fantastic!

Thanks,
If the user makes no selections from the list box, what should the filter look like to get all items in the list instead of no data?

I just want to be sure of something. When I follow your suggestion, should the “Record Source” property for the report be blank or have the query name?