Random Access

Some random things I noticed in Access 2003 as compared to 2000:

The new table wizard does a much better job of setting up the primary key. Now it gives you options to set the key as an autonumber and explains in more detail what that means.

The Tools/Security menu option has tools for user/group permissions and seems to let you assign them independently of the file servers permissions. (I assume the user still needs to have access to the shared volume on the server, obviously, but if you have 10 people with access to the volume and only want 3 of them to have access to the DB, you can do that within Access itself.

You can "open exclusively" when you open the DB, so you can make admin changes to it without screwing up data others are accessing at the same time. (That may be in 2000, I've never really looked at it.)

The beta let's you setup the DB as either a 97, 2000 or 2002 version. The 2002 version DB cannot be shared with 2000 or 97 users. I need to look at whether that is going to continue on between XP and 2003. I'm assuming 2000 users are not going to be able to open 2003 databases. On the other hand, you can use 2003 to create 2000 database's by default. If you're in a mixed environment, that's an important setting to make double sure you've set to default to 2000.
posted 10:50 PM | 0 comments | Links to this post

Links to this post:

  <$BlogBacklinkTitle$>  

<$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link