I have created a user.mdb where data is entered into a variety of forms
(stored in tables). I have several people using the user.mdb independently on
there own laptops. In this db I have created a VB command that uses DoCmd.
TransferDatabase which exports data the User selects into ...

I need some help understanding what I am doing wrong....
I have a query that works correctly but when I attach it to the form it does
not draw the data.  I have four other forms that are associated with queries
that all work correctly.  I have not been able to identify any ...

Hi,
My Access knowledge is reasonable, but I am struggling to create the
following solution.
I want to create a database to do the following:

I had a database in access 2002 which had user-level security set up. I was
the administrator.
Over the weekend, my company upgraded us from 2002 to 2003 and now none of
the database shortcuts on the users desktops work and i can't get into the

I have a Customer Service database with over 70,000 customers in it.  I
have Normalized the whole thing.  When a Customer Calls in, a Customer
Service Representative looks up their record, and it contains all the
customer's information.  In the last few weeks, it has been taking

I have a database which is split between front end and back end with the
front end being local on each computer (3 of them). However, when each user
creates a new query it is stored on the front end user.  Is there a way to
store these on the back end so everyone can see them.

MS Access: 2003
SQL Server: 2000 (Supports Web-site)
ODBC:       Windows Auth.
On a Desktop

I recently upsized my MS Access BE to an SQL server. Everything seems
to works great with the exception of a few queries (other queries are
still working great). When I try to execute the queries, I get
"expression is typed incorrectly or is too complex to be evaluated"

OK - I'm beside myself -
An access application resides on a users 'main machine' -
Everyone within the workgroup has a shortcut icon on the desktop and can
click it and the application comes up..

I have access to an SQL server on our network.  I have the MDB
front-end and MDB back-end.  How can I upsize my back-end, maintain all
data and relationships, the link that to my front-end?  
Thanks!

We have a database that is used by up to five users at a time which is
on a networked folder.
All except one computer run Access 2003. The other one has Access 2002.
The database is in Access 2000 file format.

Really stuck here.
I have put code into my F/E B/E DB so that whenever a user opens the FE it
will relink all of the tables - Both ODBC and access.  Something wierd has
happened.  After I put this code in only one user can open there front end at

I'm running a multiuser database, split into front and back end.
I do a Compact/Repair every week, and the size reduces to about 65MB.
However, within an hour of people using it, it always mushrooms back up
to about 148MB. Does anyone know why this problem may be occuring?