Trying to open a 3rd party Access Db and get the above message and Db won't
open. Holding down the shift key while opening doesn't work.

Tables can be hidden individually using this below.  Is there a global
setting that would allow for all tables to be hidden?
   Application.SetHiddenAttribute acTable, "tableName" , True

How can I strip all spaces in between digits from a phone number, strip the
first zero and then append +44 at the start?
Thanks
Regards

I have a form where people enter data on a certain subject and then select a
rating from a combo box (either green, white, yellow  or red).   The combo
box obtains its values from table with two fields (1) rating and (2) numeric
value.  The rating values are the text values shown ...

Resuling in a Save failed...I use this code w/ other Excel
"template" files.
It fails in the "...SaveAs filename:=IPFile..." below.
B = Month(BegThree): KK = Day(BegThree): C = Year(BegThree)

As a new user to Access, I have spent days learning how it all works. One of
the things that I have not been able to find is a source that defines and
explains what different controls do, etc. Everything I have read shows you
how to do something, but I can't find anything that ...

Hi , is it possible to write code behind a button for something to happen in
another form, i have a form (Issue Count1)  with a graph, the graph is linked
to a select query, i am running the open form from a command button in
another screen(view graph) , the graph simply displays ...

I have a combo box that has data for a field pulled from the table. If I
leave the combo box blank then it pulls all the records. But the user isn't
going to know this. I try to put a * in the combo box and it doesn't like it
because it says the text I entered isn't an item in the ...

I need help! I just upgrade to MS Access 2007 (had 2003 before with operating
system XP). I copied the database to my portable harddrive. Bought a new PC
(operating system Vista) and Access 2007. I copied the database back to the
public folder of new PC. Problem is that now only ...

I have a query that is extracting from a table by date using a date as a
beginning point and then working backwards. It is supposed to pull a weeks
worth of data which would be 84 data points, And it usually does. However now
it is pulling 96 data points if I make the equation ...

I am creating a checkIN/Out system.  using this system, users will
check in and out items, as well as make purchases or receive credits
for future purchases.  I am fine up the the point of calculating the
amount on hand.  I have a query that calculates the total sum of a

I've been pulling my hair out trying to figure out how to make this query...
I need to make a list of repeat customers...there's 10 customers total and
only 2 are repeat...
how do I get the query to show only the repeat customers?

I want to be able to pull data from different fields on the same table based
on a user input.  
My database is for tooling we use in our machines.  I want the user to be
able to enter the tool number and see a list of the programs the tool is used

Within Access 2003, I need to append data from a local Access table to
a linked SQL Server 2005 Express table.  I have a VBA routine that
imports an Excel file into an Access table (about 5000 records), then
runs an append query to upload the data into my linked SQL table ...

Hi, I just loaded this product and need training on how to use it for an
upcoming project. I was hoping you could provided me with a list of training
sites were I may get some detailed training on this product.