We are developing an application in which we are planning to use
MSAccess as a database. I have MSAccess 2000 installed on my development
machines. Its product ID is 50083-053-4473424-02634.
I have several queries that I would like to ask you regarding licensing of

What I currently do is have a computer that is setup as
the server computer(meaning it has the main copy of the
Database).  All the users have shortcuts on their computer
that link to the server computer.  Is this a good way of

ive set up a secured database and with many other staup options it hides the main menu bar is there a code wich if a user clicks on a command button it will then give them the option to change theier password

i really need to know if there is a way to compact and repair a linked
database.
what i need is vba code to do this in a 2 mdb enviroment: the front-end
(forms, queries, reports), in which i need to put the code i'm asking for,

I have an asset database that I want to keep track of what user is entering
new assets.  I need a way to ask who is about to use the database (possibly
with a password) then add that person as a field to the main data table.  I
think using user-level security is the easiest way to ...

I split my db. Now I want to know how to put FE file on to
the other systems and connect FE file with BE file
residing on my system. Kindly advise.
Krish

Recently we have experienced multiple crashes at each of our 3 worksites.
Each site uses a variety of VB5 and Access97 frontends to work with data in
multiple Access97 backends. We generally run at about 80 connections
concurrently (maybe 30 max on a single MDB), and perhaps 40 ...

I have a link between Access 2002 and Excel. The Excel spreadsheet is updated at regular intervals. I would like to split the database so multiple users can edit data and query tables. I am not able to split the Access/Excel link. I there a way to do this so multiple users can ...

Simple question for the experts.
I am using Access 2000.
I have an app that is written in VB6.
I use Access as my backend database.

on drive s:\ is a Access Db with only tables
on drive n:\ is a Access Db with forms, modules reports etc.
from drive n:\  I edit de tables on drive s:\
when I open the Db on drive n:\ , for nobody it is possible to do edit

Fields in my forms show as "Error#" and back end file will no longer
open.  Access asks if I would like to repair the database to which I
click "OK" but it then tells me that my file is not a database or
cannot be repaired.  What happened? What can I do? Thanks for your

after years i have a big Problem here.
Some Clients in Network can not connect to the Fileserver Access97 Database.
The Clients  ("only" 5) get the Error "Table XXX can not open, exclusiv open
from User XXX on Computer XXX"

I have a visual basic 6.0 program on our network that
checks for updates to the Access FE.  If a new FE exists,
it is copied to the users local drive.  This program has
been in use for about 6 months with no problems.  However,

I also have the need to have a single copy of an ADE file
on a network share to eliminate the need to distribute the
ADE to each desktop. I.S. will NOT deploy frontends to
user machines. The application is unlikely to be used by

The only other post here about record locking, along wiht mine have not been
answered.  If there is another way to handle this issue please tell me.
Here are my problems:
When I lock a table and then try to access data from the same instance of