In our shop we have done a lot of Access front ends with ODBC connections to the data. Exclusive access in all versions has always worked without messing with NTFS...

Amen! My personal experience agrees with your points 100%. Nice job, I intend to share this with all the Developer types in our shop.

We are a small shop and the numbers are just to keep the Stored procedures organized. They vary depending on how the developer(s) on the project wants to implement them....

When I saw this question I had to add some information on how we do this in our shop. We do not generayy use prefixes for tables or views or...