Hi,

Thanks for your answer. I will look into Roles and implement.

Is ODBC the way to connect to import the data, or is there another more secure way?

Thanks

Hi,

Thanks for all the responses. I have decided to go with the unbound controls but have another question.

Apart from the benefit of pre-compiling with stored procedures, could I load the...

Thanks for your reply Chris, but I think the solution you gave may be for Bound controls (unless I misunderstood).

I am looking to implement unbound controls where they are populated/updated...

Hi,

Thanks for the reply. There are currently between 20-50 users (and growing) and number of records is growing and will be above 40,000 is some of the tables eventually. Network...

Hi,

Thanks for the reply. It worked. Much appreciated.

Regards

Thanks Chirag.

Will look into it further and see which method will work best.

Hi,

This looks like a good solution. The only downside is ensuring that users update the cells in excel in the correct format. But I assume that the UNPIVOT would not...

Thankyou very much. I appreciate your comments.

Hi,

Thanks for your reply. If I was to have more than one user per front end, would using Access Project have more capacity (and if so, how much more)?

Thanks

Hi,

This would be a basic outline.

-----------

Master Table

EmployeeID, Employee Name, EmployeeNumber, CompanyID, (Other Employee fields)

------------

Company Table (Linked to Master table by CompanyID)

CompanyID, Company Name, (Other Company fields)

-----------

Group 1 Table (Linked to...

Hi,

The mapping table will work to link the employees to a table listing the groups, thanks for the suggestion.

But I also have different tables (with different structure/fields) for each...

Thanks Jack. The link was helpful.

Hi,

Please ignore this post. I have used 'Inserted' and it seems to work.

Thanks

Hi Seth,

Thanks for your response and the time that you spent reviewing my code and trying to make it work.

I didn't expect to go into this much detail but understand...

Hi,

OK I will do my best. Lets see how it goes. I have reduced the number of fields in each table to keep everything simple, so the tables are not...