I have an Access 2003 "Sales Record" database.  We will soon be changing our
computers to a network.  What I would like to find out is how to convert the
database application to multi user.  I assume that the database should be
split into data (tables) to be stored on the server ...

Is it possible to "compress and repair" an Access database using VBA from
Excel?  Would appreciate a code sample if available.  Thanks!!  Larry.

Hi. Would appreciate some feedback telling me why the code doesn't hit its
Recipient?
(The Email ends up in draft (and sometimes even in the Inbox) and I guess it
has something to do with the lack of recipient). In advance thanks, JohS

I like to know the table attribute of each table as it is hidden or not for
each table of my database.
How?

I help enhance an Access program for the local food bank that tracks
volunteers.  We are having trouble getting the spelling of agency names and
addresses correct.  I want to invoke Spellcheck from within Access for just
the contents of specific text boxes, probably with a ...

How can I make a function that fill automatically a table with  days of year
and three Periods, like:
table App
ID |         Date |           Period

When I using Access VBA, the options that usually follow docmd. me. etc only
are visible for a short time and now have disappeared all together.  What is
that function called and how do I get it back?  
Confused.

Can someone please help me?  I'm trying to include a field (OpCo) from a
table that corresponds to an individuals email address; this is what I have
so far.  
Function ForecastnotificationFC(strOpCo As String, strEmail As String) As

I have a field governed by a Select Query (based on a 'Names" Table) which
provides a list of names from which to select.
I sometimes want to enter a name not in the list i.e., overide the Select
Query, and enter a name not in the Table.

Hello,
I am looking for some VBA code to get the Outlook Mailbox size on the
exchange server from Access.
I found this url http://support.microsoft.com/kb/320071 but not support by

I am currently using Access 2007 – when I am creating a form control button
within a form I have a tendency to use the wizard, select the category “form
operations” and the action “close form” – I tend to name the button cmd_close
for each form.

I have been trying to migrate my Access Application built in Access 2003
onto SQL Server, but for many of the forms I use Domain Aggregate Functions
(DAFs). I am still keeping my front end as Access but the back end process is
SQL 2000. I decided to use ODBC linked tables instead ...

I have an mdb database that updates itself once a day.  When users are still
logged in, the update fails.  Is there anyway to disconnect all users?
Thanks a lot !
JF

I am not sure if this can be done with ms access, but I am hoping to get some
ideas. here is a crude approximation of the table, two columns, id and
text_field:
id    text_field

Hey,  Im trying to execute a simple SQL statement in VB and its not liking
it.  It is saying its expectign 7 parameters when there 7 there and the table
names match the table and the data type.
Here is the code