password glitches in 20003 and 2000



I created an Access 2003 database and added user-level passwords. One level
is for me (administrator), another for design/data changes and a 3rd for
read-only.
Access created a shortcut on my desktop that I copied to a folder on the
server where the database resides.

The good thing is that those in the office on 2003 can get into it correctly
by using passwords when they dbl-clk on the shortcut icon.
However. those using Access 2000 can't! BUT, they CAN click directly on the
application icon and open it without password dialog popping up. Unacceptable!

What I did, albeit less that ideal, is create a separate folder on the
server where each week a copy from the previous week will be posted for those
read-only folks using 2000 AND the icon for 2003 users who can go in and look
at the LIVE version but forced to use passwords. (Access 97 won't open it at
all but it doesn't matter since the few people who use 97 won't be using the
database anyway.

We'd like to use this database in both 2000 AND 2003. Any thoughts on what I
can do to do this short of forcing everyone to use 2003? That solution would
take longer than is acceptable...

pls advise...thanx! Don
.



Relevant Pages

  • Re: Is this possible??
    ... All our timekeeping data is stored on one server, ... This is the FoxPro database and that has all ... there is on a shared drive, each client has their own folder, we have around ... biggest concern though is how I'd be able to look up these Excel budget ...
    (microsoft.public.access.tablesdbdesign)
  • RE: DHCP Errors every hour? Looks serious!
    ... allow Indexing Service to index this folder" ... Antivirus software real-time scan the DHCP folder. ... Reinstall DHCP Services on the SBS server. ... | the DHCP database resides. ...
    (microsoft.public.windows.server.sbs)
  • RE: Windows server 2003 SP1
    ... I agree with Marina that you must keep the same server name to restore Exchange database. ... please also refer to the following KB articles for restore Exchange database. ... >Do the same for the public folder store ...
    (microsoft.public.windows.server.sbs)
  • Database Location in a Multitier Soulution
    ... By default if you add an Access database to a web project VS2005 likes to ... If you introduce the concept of a DataAccess layer ... DataAccess layer is compiled the DLL gets added to the Bin folder of the web ... workstation which happen to be redirected onto a different server (which is ...
    (microsoft.public.dotnet.framework.aspnet)
  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)

Quantcast