Search results

I'm trying to add some controls to a frame and have them tied to the frame itself. Similar to how the radial buttons labels are in the Options frame. I then want to be able to control the frame and the attached controls in VB. Thus if I set the frame property: visible=NO, the frame and the...

:eek: I'm running a Make table query that links two tables in a one to many relationship. What I need to do is add a column that is a running or sequencial counter. The counter is used to preserve the order of the child records thus I don't want it sorted. It would be nice if the counter would...

Finally got it to work!! The first part of the problem was in the ODBC setup. I used the System DSN option but made a few typo's that left ODBC names not matching from machine to machine. Once I got that straight each user had access to the linked tables. Then the Security in MS Access got a...

Shared User ID's Thanks everyone for your imput. Each user will have their own User Id and password via Access Or SQL, so that is not an issue. I'm working with some of the other suggestions. I'll let you know what happens. Thanks, GBD

Goal I'm trying to trying to setup a MS Access database on a shared server drive where all of the main tables are linked via ODBC into an SQL database. The SQL database is updated and maintained via purchased application. It appeared that MS Access security could be used to control the type of...