I am using the Ccur function to convert a number to a
currency type. It works fine except in the cases where the
number is negative. Is there a way to get a negative
currency value?

I'm in the process of migrating a legacy database into Access and need to map the data fields. Are there any tools/templates that I could use to help document the table mapping. Some tables are straight copies, but some have new fields etc.
Thanks

Trying to convert a mysql database into access for a
client, and some problems arise by selecting get external
data -> import from ODBC connection
IE: The database structure and data is imported fine, but

We have a FoxPro application (tables and code). Can this be
cleanly imported into Access, or will the code need to be
re-written in Access? If it can be imported, is there
anything special we need to do, in order to make it happen

When two users change the same record there wil be a
message fired of by MS Access "Write conflict". This
message has no err.number and I can't trigger this
message. Can somebody help me to trigger this message so I

We converted Access 97 to 2002. One of the form has
details section and form footer with totals using
=SUM(Column1) function. Some times the total works fine
and some times display error. The message display on the

I have 2 date fields.....Start Time and End Time.  I have another field that I want to show the difference in time .......basically EndTime - StartTime.  I want the third field to display 1.5 or 2, or whatever the difference in time is.  
Does this need to be standard time or ...

A while back Microsoft said that SP1 for Office 2003 would include a
Conversion Toolkit for Microsoft Office Access 2003
http://accessadvisor.net/Articles.nsf/dp/9AB8838743E1644888256EA200489CE6
but http://support.microsoft.com/?kbid=842532  does not mention it.

I have 3 tables
tblSales
invoice_no    Customer_id      date      
001                222                    12/3/04

Hi guys, I did a DTS conversion of my Access 2K database into SQL Server. All the data went through fine as far as I can tell. I then created an ODBC connection to it and am trying to use my old Access functions. I took my old Access database, replaced all the old tables with ...

Do you know an easy way to get Interbase 7 tables in an Access 2000 mdb ?
Thanks,
Eddy

I would like to lock out folks from a shared 2000 db who
are running 20902 or 2003 on their machines...is there a
way to test for their version?

Can I safely have users with version 2002 and 2003 use a
shared 2000 database?

Can anyone tell me if there are any inherant problems running a multiuser (max 15 at one time) Access Database over terminal services? I'm worried this may give file lock issues, but by using terminal services it would revolutionise the access to the system.
Currently the database ...

Would someone be able to provide some instrustions on how to do the
following?
Currently our client has a 97 database. Some of the machines have 97 and
some have 2002. I was under the impression you could create two seperate