Can someone explain the fundamental difference between creating a "multi
user" version of an Access DB and creating a client-server Access DB?
ie why can't all the users on my network just click on database.mdb and
share the same database? why would I want to create a separate ...

I'll try and keep this short and sweet.
MS-Access is my front end (FE) and SQL Server is my back end (BE).
I created an Access application and then migrated the tables to a SQL
Server.

The answer to this is probably very simple, but it has been a while
since I have had to use access.
I have two different queries, one counts records:
SELECT Closure.Closed_As, Count(Closure.Closed_As) AS Closed_As_Count

What's the trick to running a batch file from VBA? I'm trying to call
it using the Shell function but it's not working for me. If I
double-click the batch file or run it from the command line it works.
I've tried:

We have a table of data formatted as follows:
SITEID,SPECIES1COVER,SPECIES2COVER,SPECIES3COVER
Where SITEID is some unique location, and the next 3 fields are the percent
cover of the site by a given species.  It occurred to me this is a poor way

Hi, Can someone help with a simple query?
I have a table with the following.
[maintable]
Firstname

I have used the advice on this site to clear a specific error when a
report is generated without any data.
Err_cmdLaunchItemsReport_Click:
   Select Case Err.Number

I have a continuous form which displays all the records on a table.
The detail row has a command button which, if pressed, takes the user
to another form where that record can be edited.
The problem I'm having is what happens and what to do when the edit

i've got a film rental database., with a film table and form.
i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent
or not, when i go though the records, depending on whether the check box is

i need a little help. i have two tables and 2 forms, one with a subform.
i have a 'fildID' in one of the subforms, and i have another table, which
has the film information, including a checkbox, if the film is available.
if i enter an id in the subform in filmid, how can i get the ...

Hi NG,
we are using MS-Access 2002 as a frontend for Oracle Databases versions 8i
and 10g. Now I have a problem with the connected tables of the 10g database.
In Access all text fields are shown with a wrong fieldsize. (e.g.

1        Dim db As Database
2        Set db = OpenDatabase("c:\videoStore\settings.mdb")
3        Dim rs As Recordset
4        Set rs = db.OpenRecordset("defaults", dbOpenTable)

Hi i'm a student doing my project and i have a doubt. I have a access
database in my home comp which is connected to the net. Whenever i make
new readings in my lab i wish to enter them in my database. Is there
any way through which i can enter these readings directly into my

When the DMV tells you they cannot determine ownership, you have three
options. First, you can try to determine the last state of vehicle
registration yourself. If you're successful, provide the NC DMV with
the registration state and let them have another stab at it. Second,

I have search the Groups for help on this, and found some examples of
people trying to do something similar to what I am trying to do, but
wasn't able to get any of the examples to work.
What I am trying to do is call a popup containing a Calendar Control