I try to migrate my Access 2003 MDB BackEnd (with data) to SQL server (MSDE
8.0) with the Access Wizard, but when i finish, all my table with a random
autonumber primarykey have no record, and i was not able to add record ??
I try to change random field to a simple autonumber (in ...

I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within ...

Is there any reason why my db would almost double in size after I
copied everything to a new db after my old one became corrupted? Is it
anything to worry about?
Thanks - David

I need to print out labels (which are set up as a a report) from form.
I can tell access how many labels to print, but I also want to add to
each label "Box 1 of 5", "Box 2 of 5", "Box 3 of 5" etc etc. My labels
are 2 up to sheet.

I use the following code to retrieve to recordsets into two local tables,
from an mdb file over a WAN.  Works fine, but I'm trying to tweak the speed,
and I have some questions:
1.  I tried both an ADOX-created stored procedure and a regular Access

Have customized the menu options in Access 2000 in a computer. However,
it seems that the customizations apply only when I'm logged in and not
to other users. Is there any way to use the customizations as a default
for all users of Access on that computer.

I am trying to collect errors and record them in a table instead of a
popup message stopping my code. It seems to work ok, but when I try to
add ERR.Description to my code it fails on Syntax Error (missing
operator).

(RE: Access 2002 SP3)
There are many default toolbars that have the database window icon in
them.  Different users will have various ones visible when my app
starts.  When my app opens, I only want to display my custom toolbar in

I am creating a form and I want all the records to show in the details
section that are in the table.
How do I get them to appear. Currently, I have to press next to view each
record.

I would like to query a database for 3 children whose fathers are the
oldest. The answer isn't necessarily unique: if the oldest father has 6
kids, then any three of his children will do. My first shot was:
  SELECT TOP 3 NAME

In the desktop shortcut I added the /ro switch to the command line
\\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro
and the db opens but I can still change data that is displayed on a
form.

What's the best technique to remove a value entered
into a form's textbox control after halting the update of
the textbox with a docmd.cancelevent line in a before
update event procedure?

Hopefully a stupid question, but it doesn't appear that way.  Found an
example of a recursive file search, which is exactly what I want, at
Randy Birch's site (mvps.vbnet), but VBA is just different enough not
to compile.

Our company is migrating from Windows NT to XP and in the process from
Access 97 to Access 2003.
Due to the phased rollout we are faced with a situation where some users are
still on NT while others have been fully upgraded, but all users need to use

I have a Database with a Simple Switch board and multiple reports and forms.
All of a sudden When i go and open up the database it says it can't find my
forms or reports, but the tables and quiries are still there. This just
happend the other day. So i copied the forms and reports ...