I have not created a secure database as of yet and am the creator.   Today, I
am unable to open reports, any ideas why?  Tables and queries are fine.

I have a simple query, which retrieves a couple of fields from linked Excel
table and calculates some values - something like this:
SELECT [MyTable].[Name],
DateSerial(Year(Date()),Month([MyTable].[BirthDate]),Day([MyTable].[BirthDate]))

I am trying to figure out a way to select one record at random out of almost
400,000 records.
I decided the easiest way would be to select a random number using the
record ID(which is consecutive), inserting it into a text box and using a

I'm using an unbound form to input data into a record via VB code that runs
once the last field on the form us updated. This code opens the table, writes
the data to the appropriate fields, closes the table, then clears the form
and moves the focus back to the top control of the ...

Hello. I have a table with a huge amout of data. The data comes from an ODBC
table and is copy to a local table.
When I have to delete the data of the local table it returns me a message
sauing that I have no enough disk free space to cancel the operation. For me

My apologies if this is an inappropriate post for this group. I tried the DAO group,
but no response.
I've just started getting this error message on a seemingly random basis.
'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or

Hi
I have the email addresses on my form set up to open a new email to that
person when clicked upon.  What it doesn't do is import the email signature
from outlook.  Is there any way I can do this?

Good day!
When pasting a large amount of data into an Access table, I get the error
message "File sharing lock count exceeded. Increase Max Locks Per File
registry entry".

I'm creating a new MDB on-the-fly via VBA code. Works great. Now I want to
add info that's found in the Database Properties window. Not so great.
Various properties in that window are found in:
CurrentDb.Containers![Databases].Documents![SummaryInfo]

Currently we use Filemaker Pro 6.  This does not serve our needs to the
fullest, however we are unsure how to set up a ledger templet for the 200
people to track these individual accounts.  If at all possible, we would like
to link it to their personal information accounts we ...

I am trying to stop a user adding data into a subform before it's
parent record has been created, so I am testing the key field of the
parent to see if there is one:
If Forms![Order Form]![Order Details].Form!PK_Order = "" Then

Typically you use a variable for criteria in a query, but can you use a
variable for a field?
Lets say there are multiple fields in my table, i.e. field1, field2, field3
and so on.  At design time I do not know which field to query because the

I have 4 columns, 2 start date and 2 end dates.  In most cases, both are the
same.  In some, the start date is the same and the end date is different and
vice versa, how can I accurately get the number of days overlap?

I think I've finally got my guys talked into buying a dedicated
PC so we can fool around with SQL Server and see if it offers any
improvements over the various .MDB back ends we have now.
We're talking 20 concurrent users max.   More like 4-6 most of

hi i miss you alot dude