I am creating an Access 2002 database that I want to run from a single
PC until I get everything working ok.  I would like to get all the
tweaks worked out and add or delete any features that users notice
after they start using the database.  Then the database will need to

Is there a way that VBA can get the login name or ID the user entered to log
in to Windows 2000, without requiring the user to reenter it in Access 2002?
I need to restrict access to certain forms in an application depending on
the users' department, and since Windows 2000 already ...

Our company wants to share a ms access database.  We are
currently in the process of getting a network server and
place some softwares there.  We want to share a ms access
database by placing it on the network server so that the

To what extent is MsAccess truly object oriented?
I have a db with several forms that use an ObjectTree on the left side of
the space and to the right I have the associated data (in several subforms
that can be changed via the SourceObject property, depending on the

Let me re-phrase my message.  MS Access has a template
called " Asset Tracking ".  It has the fields and the
reports that we want.  We want to key in the items
(assets) on the template and share it with other users.  

I'm working on a database in A2K, FE/BE design...all pretty much standard.  
The main data table is related to several child tables, with 1 to many
relationships, RI enforced and cascade deletes enabled.
I was getting the message about deleting child records previous to today.  I

Is it possible to determine the users network ID from
access and then somehow link this to the information they
are able to view. I would like to prevent particular
groups of users from obtaining access to particular

I have created a database that has a txt file linked to
it. Only one user at
a time can access the linked file through a query or open
on the file.

I have a user trying to login to our database.  He gets
an error "Could not lock file".  I tried his login at two
other computers and it worked fine.  
I than deleted his icon connection and reconnected his

I have a site with about 10 users. The back end is on the server. Should I
make sure the latest Jet and DAO is on the server, or does it matter?
Regards
Diarmuid

When I compacted the database, suddendly came out an error: Record(s) can't
be read; no read permission on 'D:\xxx.mdb'.  Can someone advise me the
possible causes and fixes.  Access 97 running on Windows XP Pro is used.
Thanks,

have a user trying to open a DB that i can open no
problem and another user at the same time..
here is the error..
The table 'MSAccessObjects' is already open exclusivly by

I know that Access just shows the records available on
open.  Then if another user adds records they do not show
up on the first user's system until a requery, filter,
close and open again, etc.  What is the best way to have

I HAVE INSTALLED AN ACCESS 2000 APPLICATION ON A WINDOWS
2000 SBS SERVER.  I HAVE THE DATA TABLES IN ONE DATABASE
AND THE FORMS, ETC IN THE SECOND.  I HAVE DONE THIS BEFORE
WHEN THE SERVER WAS OPERATING UNDER WINDOWS 98 AND THE

Hi,
i just splitted my multi-user database (access 2003) into
a front end and back end.
It's a very complexe database, size about 50mb, and about