Access 2000 <--> 2007 compatibility
We have a DB for data collection/telemarketing with a form and some VB
code. This one is created in Access 2000.
Can Access 2007 users open and work with this DB without causing
problems if it later has to be operated on using Access 2000?
Anything special we should do to avoid problems in this mixed version
Access 2007 can open, use, and modify a database in A2000 format.
As always, if you have several users in the database at once, it's a good
idea to split it:
If you are switching back and forth between versions, a...Error compiling backlight driver
i'm adding the backlight support to my BSP but i receive an error I'm not
able to handle.
I added the BACKLIGHT tree under the PLAFTORM/bsp/src/drivers/BACKLIGHT.
I added the teims into the catalog file.
The build log is the following:
BUILD: [Thrd:Sequence:Type ] Message
000:PROGC ] Build started with parameters:
001:PROGC ] Build started in directory:
002:PROGC ] Checking for C:\WINCE600\sdk\bin\i386\srccheck.exe.
003:PROGC ] Running passes WCEFILES0, MIDL, MC, ASN, THUNK, PRECOMPHEADER,
COMPILE, LIB, LINK, MA...File Access History
Is there anything in Excel that will show a history of who accessed,
modified, and/or saved an Excel workbook other than what's in the file
properties dialog box?
Thanks in advance. :)
"lensolo" <firstname.lastname@example.org> wrote in message
| Is there anything in Excel that will show a history of who accessed,
| modified, and/or saved an Excel workbook other than what's in the file
| properties dialog box?
| Thanks in advance. :)
...File System Error 2 during IO on log file .. MS exchange 5.5
I am getting following message intermittently.
MSexchangeIS (277) File system error 2 during IO on log
file. Event id 163
MSexchangeIS (277) Unable to write log Error -510
Event id 120
MSexchangeIS (277) Unable to write log header 510
Event id 121
An error occured while writing to the database log file.
Attempting to sop the Microsoft exchange Information store
Event id 1111
Unable to create log . The drive may be read-only, out of
disk space, misconfigured or corrutpted. Error 510
---> Because of the Exchange is not operative, i have to
--> The same problem ...Approach to Access 05-02-07
I have a client that has a db in Lotus Approach 9.5 but wants to convert to
Access 2003. The existing db has a number of forms, etc that would be a pain
Is anyone aware of a conversion utility or method that would save a redesign
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may no...Fix the Excel Clipboard
The excel clipboard, one of the longest running bugs in microsoft history,
should be fixed to act just like any other clipboard. When something is
copied from excel and a user does any action other than paste (such as
manually enter a value) the clipboard gets cleared. This does not happen in
any other windows application that I know of.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
...Can you have fixed cell reference when dragging/copying formulae?
When you drag or copy a formula which refers to another cell, then that
cell's reference is updated when the formula is dragged or copied across a
spreadsheet. Is it possible to 'fix' the reference of the outside cell such
that the formula refers to a fixed cell irrespective of where the formula is
For example a formual in cell B2 containing a reference to cell A1 will
always refer to the cell immediately above and to the left when copied
elsewhere. Is it possible for the formula to be forced to refer to cell A1
irrespective of where it is copied?
You can use $a$...Sql Server / Access query source code
Is there any compatibility between the queries from Access and Sql Server?
Like I have a system that needs to migrate the database and the queries from
the source code, I can use DTS to migrate de database from Access to Sql
Server but what about the queries? Will Sql Server understand them or I'll
have to change it manually?
The answer is, it depends. Some query types are not supported, but
straightforward SELECT queries are essentially the same in Access-SQL
and Transact-SQL. However, if you use expressions, VBA functions, form
references or other Access features in your quer...FIX: Untracking emails incorrectly tracked for Outlook 2003 and 2007
As you know, it is tough to un-link or un-track emails (Outlook
records in general) if you track them by mistake or link them to the
wrong CRM record. The link below shows how to do it when using Outlook
2007. (I assume it is the same for CRM 3.0 and 4.0 but I cannot test
the former since we just upgraded to 4.0.)
The problem was doing it with Outlook 2003. I think I figured a way.
You have to follow the steps in the link above but the problem was
showing the CRM user fields in the email record to set them to 0.
If you ope...Run Time Error 3027
Running Access 2007 with an Pervasive SQL database and everytime I try to add
a record I get this error and tell me the record is read-only.
I use the same procedure in other updates and works fine.
if you are talking about liked table - then make sure that table has primary
Alex Dybenko (MVP)
"AskingQuestion" <AskingQuestion@discussions.microsoft.com> wrote in message
> Running Access 2007 wit...File in Use Error
I have a excel spreadsheet with two worksheets, each of which connects
to the same Access database via an ODBC connection to retrieve data.
The worksheets have different data and are pulling from different
tables in access. I was able to do this without any problem but since
I am the owner and creator for both files I did not forsee any
Now I need another individual to do this task but when they open the
excel file they get 'File in Use :|' error. The person has read,
write, modify and excute rights to the database.
Any help will be appreciated. Thank you.
...There has been an error reading or writing the file
I am using Money 2005 and when I try and create a report for Account
Transactions I get the error message mentioned above.
MS article 281865 confirms this problem and asks that the report be
My problem is that Money shuts down without giving me a chance to
customize the report.
...How quickly fixed?
This problem appears to be quite a bit more serious than the Pentium
divide bug. Will Microsoft be able to fix it (software) more rapidly
than Intel was able to fix it in the hardware? Hmm...
This isn't a chat room, perhaps you actually meant to reply to a message?
> This problem appears to be quite a bit more serious than the Pentium
> divide bug. Will Microsoft be able to fix it (software) more rapidly
> than Intel was able to fix it in the hardware? Hmm...
...Allowing access from ACT 6.0
Everytime I send an email from ACT, Outlook pops up the
"A program is trying to access e-mail addresses you have
stored in Outlook. Do you want to allow this?"
I need to know how to permanently allow ACT access to
I'm also interested in this, i have a voicemail software that tries to send
an email, used to work until I upgraded to 2003, I've looked in te KB but
cant find a solution
"Bob Bell" <email@example.com> wrote in message
> ...Outlook Web Access question
What Service Needs To Be Running For MS OUTLOOK Web Acess
TO function from remote locations?
Thank YOu .. Jim B
IIS and port 80 open - when you install exchange server, it configures all
of that for you. (and it only works with exchange server)
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
"JIMB" <firstname.lastname@example.org> wrote in message
news:11e1801c3f...help! what is Error Number: 0x800CCC18?
Account: 'wonderland207/mail', Server: 'pop3.live.com', Protocol: POP3,
Server Response: '-ERR command not implemented', Port: 995, Secure(SSL): Yes,
Server Error: 0x800CCC90, Error Number: 0x800CCC18
"kmh" <email@example.com> wrote in message
> Account: 'wonderland207/mail', Server: 'pop3.live.com', Protocol: POP3,
> Server Response: '-ERR command not implemented', Port: 995, Secure(SSL):
> Server Error: 0x800CCC90, Error Num...Cash Payment Voided in Error
I have a user who inadvertently voided a receivables cash payment . The
invoice the payment was applied to is also voided. The payment she intended
to void still shows as 'Open'. The wrong void shows in the GL.
The customer's account should show a credit balance. Is there a way to undo
the payment that was voided? what is the best way to fix?
There is no undoing a void. To 'fix' this you can re-enter the voided
payment, you'll have to put a '-A' or '.' at the end of the check number, as
GP will not let you receive the same check nu...Run time Error when running Z Report (-2147217900)(80040e14)
When I generate the report I get the initial filter screen, and when I click
ok to view the report, I get the following error message:
"The report could not be loaded due to the following error: (-2147217900)
Cannot truncate table 'Cashier' because it is being refrenced by a FOREIGN
The table keys only seem to reference themselves, so check your table for
If you don't know how to do that, try deleting the cashiers and reentering
JR Data Inc.
> When I generate the report I get the initi...Error running a link query in a query page in Business Portal
I am working on Business Portal 4.0 and created some custom entities and
created a query page. Transactions and CodtCodes were two of my custom
entities. When i run Transactions Query it will show CostCodes link in the
links section along with other links.When i click cost codes link in the
links section it was showing an error saying "Can't process query
when i click details it was showing
The key 'JobCost.CostCodes+key' has multiple segments. Some segments of the
key ha...Putting Database on Server so other Employees can access it
I just put a database I created on our server. The other 2 people who will be
using it arent able to open it up though. Can someone please point me in the
right direction of how to fix this so they can use it?
Thanks for your help!!!
1. All users of the database must have at least read, write, create, delete
(or modify) privileges to the folder holding the database file. Not just the
database .mdb file, but the entire folder.
2. Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(...Errors when running Msextmz.exe in Export mode
When I run Msextmz.exe in export mode, I get the following error:
MSExTmz Utility Version 8.1.61
HrReadConfiguration:Logging Level set to:0
HrReadConfiguration:Log File is not set.
HrReadConfiguration:Fatal Error:Command not set.
wmain:Failed to read configuration - error 0x80004005.
I created the MsTExTmz.ini as such:
ServerDN=/o=First Organization/ou=First Administrative
Group/cn=Configuration/cn=Servers/cn=OURSERVERNAME (replaced real server
name with a generic placeholder)
Out...ipconfig error: unable to query host name
I am working through a router with one main computer, a wireless laptop, and
a second desktop computer. When everything is plugged in, the second desktop
computer (which runs Windows XP Home Edition) shows it is connected to the
Internet, but when running a browser (in this case Internet Explorer) I get
the "The page cannot be displayed" error.
I've tried to run an "ipconfig" through the command prompt and I get this
Windows IP Configuration
An internal error occurred: the request is not supported.
Please contact Microsoft Product Support Services for fu...Shell.UI and vista Unable to determine XP theme error message
I'm opening a .net project that loads Microsoft.Dexterity.Shell.UI in
order to make the app inherit the dexterity colors. When I open this
project on an XP machine, it works fine. When I open the same project
on vista and open the designer, I get the following message :
System.InvalidOperationException: Unable to determine XP theme.
GetCurrentThemeName returned C:\Windows\resources\themes\Aero
\Aero.msstyles for the theme name.
Fair enough, it doesn't understand aero themes. :)
Is there an easy workaround or am I stuck having ...Not Enough System Resources... When Opening Excel
One of my users has just started getting this error when she opens Excel:
Not enought system resources to display completely.
She is opening Excel, not an Excel file, ie: new worksheet.
This is on XP with SP2 and all updates
Excel is version 2000 9.0.6923 SP 3
The only other apps running are Outlook 2000 and SnagIt, a screen capture
I'm thinking the easiest resolution will be to re-insatll Excel.
Any other thoughts or suggestions?
Nope. Close Excel and then go find a file called *.xlb and delete it - You
may have to search in hidden files and folders. It...Conversion to Access 2007
I have several MDB files created in 2003 (XP) that ran fine. After upgrade
to MS Office Enterprise 2007 these data bases no longer function. I did use
the ConTool.msi without any comments. I also did save the mdb to the new
2007 file. When I start the data base after conversion the screen opens as
usual on the first form I created (in some I used the switchboard) as a menu
but clicking on any of the
buttons does not produce any results as if the code behind the buttons is not
Any Advice? Thanks for any input.
The code will not run unless the database is signed or in...