Lets say I develop a database on my PC, consisting of lots of relational
tables and forms, reports queries etc.  My boss sees this database and
declares he wants it set up on a SQL server for everyone to have access to.
Can I still use all the same queries, forms and reports ...

i have about 10 excel spread sheets some with 1000 contacts others up to 200.
If i want to create a generic database for them in acess would i put them
all into one table or should each spreadsheet have it's own table. Also they
all have the same fields in them except for which ...

I have a client who has an Access 2000 database that they have lost the
security database for.  They have now updated to SQL Server but they need to
open up this database.  Is there any way possible to do this?
Bill

I am using Access 2002
When I try to use link table manager I get this message:  
The SendKeys action requires the Menu Utility Add-in to be loaded.
Rerun Microsoft Access or Microsoft Office Setup to reinstall Menu and the

I have the following code (which opens a NEW Word document and prints the
data from my ACCESS form) -- I need code that will open a specified WORD
template and insert the ACCESS data into a specific bookmark.  I'm sure this
is a simple process, but I'm somewhat frazzled (at this ...

I need to know how to assign values from Access field to a MS Word
field?
Thanks

this is the code that's giving me a syntax error:
strSql = "insert into tblnewoptions (Option, OptionCode, AllocGroup) values
('" & Me.txtboxOption & "'" & ", '" & Me.txtboxOptionCode & "'" & ", '" & Me.
txtboxAllocGroup & "');"

I have a table with 7 different columns of team members on different teams.  
I need a count of all team members.  How do I query seven different columns
and eliminate dups?

I have a table that list values with names i.e.
Fred      Cheese
Fred      Ham
Dave     Cheese

In order to better secure my database I’m trying to make separate tables
joined through one-to-one relationships.  I created the relationship, and
authorized cascade updates and deletes.  The only problem I’m running into is
inputting new information.  Since the same field is ...

Hi there! Thanks for all the useful info one can gain from this forum.
I have a real need to merge two files to obtain on mailing list that I can
print in zipcode order in assending order.
I think one problem is that there are two lists of assigned unique numbers

Imagine this situation...there are:
Owners (tblOwners)
Pets (tblPets, child records of tblOwners)
Medicines (tblMeds, child records of tblPets)

Hello experts,
We are normally used to coding to SQL Server, but have a requirement to
write a Win32 app that will store upwards of several hundred thousand rows
in an Access database per run. (Initial run could be hundreds of thousands

I have three separate db that all display the same fields, but different data
based on the product for the db.  Since the Forms tables and Reports are
exactly the same regardless of user, i would like to combine the three db
into one for ease of maintenance. The only difference ...

I used to use some vba code i found on the internet to calculate check
digits for upc codes,  i want to do this from an access query now, not
in an excel sheet.  I just copied the vba from excel into an access
module and tried calling the function in a query.  But i get something