convert .csv file to .cub using access
I am using Microsoft Access to work with a .CSV file that
contains 250,000 rows of information. I'd like to
convert that file to a .CUB file so that I can use
Microsoft Data Analyzer to "drill" down the information.
Does anyone have any ideas?
As I understand it, the normal way would be to use the Cube Wizard in
the OLAP Manager, after importing and normalising the file into SQL
Server tables. It may be possible to use the Cube Wizard against an ODBC
connection to an MDB file.
But as I understand it the point of using OLAP cubes is to denormalise a
set of views...In Outlook Web Access 2000
I have two users that are not able to open emails in their inbox when they
connect to the Exchange mailbox using Outlook Web Access.
Can they open any emails in their inbox, or do all fail? What error do they
For Exchange news, links, and tips, check:
"Michael" <Michael@discussions.microsoft.com> wrote in message
>I have two users that are not able to open emails in their inbox when they
> connect to the Exchange mailbox using Outlook Web Acce...restricting access to global address list
I need to restrict a specific group of people from seeing the global address
list and being able to send to anyone in it -besides their group. test group
has test1 & test2 in it. I want test1 & test2 to be able to send to each
other and TestSupport (another address list) only. i followed atricle 319213
and the steps in 'Using Permissions to Limit Access to Address Lists' but
the users Test1 & Test2 can still see, search and send to everyone in the
global address list. I am using Exchange 2003 Native Mode on Windows 2003,
in 2003 Native Mode AD Domain. Can anyon...Problem with Access 2003
I recently re-installed Access 2003 after installing a new hard drive.
I re-installed Access & the data files.
Now, on certain forms the cursor will flash & the status bar says
I know that I must be missing some references or something. But nothing
shows up in the module window when I check for references.
Anyone have any idea on what is happening?
Any direction would be great.
Thank you in advance for any help you could offer.
On Thu, 8 Nov 2007 12:57:54 -0800, "Joe" <firstname.lastname@example.org>
Not sure w...Make script accessable to an ISV button in the grid
added to the grid of one of my entities. So I have an entity in the
home page's left nav and when I select it the default view displays the
entity items in the grid with my ISV button. Now I need my ISV button
to be able to access a function in a js file. I can add my functions
to global.js and they are visible there but I don't want to do an
ps. (The custom js file is going to contain an ajax call)
...No internet access on SBS2008 second server
I am setting up a new SBS2008 domain. So far I have a clean installation of
SBS2008 on one box and clean 2008 Server on the second box, both connected
to a router and nothing else on the network. The router is configured with
DHCP disabled. The SBS box has full internet access and the second server
has DNS resolution (e.g. can resolve the IP of any website) but is unable to
open any websites in IE or ping them from a DOS prompt
Both systems have the router's IP as their gateway. Router is on 192.168.1.1
and I have only one network card in the SBS box so can't see ...Aggregate function - Access asks for Value
I'm trying to get a count of all the Contributors who have given to
more than one candidate. Here's my code:
SELECT Contributor.Contributor_ID, Contributor.Contributor,
Count(Contribution.Candidate_ID) AS NumberContributions
FROM Contributor INNER JOIN Contribution ON
GROUP BY Contributor.Contributor_ID, Contributor.Contributor
HAVING Count(Contribution.Candidate_ID) > 1;
When I try to run the query, it asks for Contribution.Contributor_ID,
as though it's looking for a form input. If I enter nothing and just
accept, it ret...Integrating Outlook Calendar & Access
I've searched thru this forum and thru the Access forum and can't find
exactly the issue I need to resolve. I have developed a calendar in AC2003. I
have developed a process to export the calendar entry from access to the
outlook calendar which works great. My user is now requesting the ability to
view (or thru VBA) the entries in the Outlook calendar from within access?
Unfortunately my database has no way to know if an entry in the access
database already exists in the Outlook calendar. Is there a way to determine
I tried creating a linked table with Outlook s...Outlook 2003 and Cached mode GAL Access
I have an Exchange 2003 server running as hosted email solution with
many different companies being hosted on the same server.
I have followed the numerous support articles, and have applied
appropiate security to the GAL and the msExchQueryBaseDN in the user
I have setup the address lists correctly to limit each user to only
see their own company. But when outlook 2003 is configured in Cached
mode, it bypasses the security and the users can see EVERY user on the
server. Does anyone know why outlook 2003 works fine (applies correct
security to the Global Address List (GAL)) in...Sales Edit List Batch Totals
I printed a Sales Edit List containing invoices in SOP. Both the Batch Total
and TRX Total in this batch are incorrect. Three times I have printed this
report and every time I get a different total and the total is not correct.
No one has added or take out transactions from the batch.
I run the utility to reconcile batch information, and the total is still
incorrect. What should I do?
Instead of printing an edit list, can you try selecting Batch List
Thank you for your suggestion. That is exactly what it was. Some Order...Outlook Mail
I have a notebook and a desktop PC. My mail account and .pst file is located
on the notebook. Both PCs are on a wireless network.
What I would like to do is be able to access my outlook mail from both PCs.
How do I do this? Presumably there would need to be some sort of
synchronizing to take place such that email sent or received on one PC is
viewable on the other PC.
Do I have to put my email in a public folder? In any event, my public
folders do not operate across the network - only within the one PC and
provides access to other users of that PC only.
Is there a way that I can make my pub...Exchange 5.5
We need to know if there is a way to generate a report of webmail users and
when they last logged into OWA.
On Thu, 9 Nov 2006 08:26:02 -0800, Jim Hale
>We need to know if there is a way to generate a report of webmail users and
>when they last logged into OWA.
Use something like http://www.logparser.com/
or www.sawmill.net to parse through them.
I had done this mod to the OWA 5.5 login script a long time ago but couldn't
remember what it was...
Fortunately google had it:
Why does my application come up talking about Unsafe Expressions, and
asking whether I want to disable them? And how do I stop it from doing so?
On Tue, 19 Jun 2007 08:04:34 -0400, grep <email@example.com> wrote:
>Why does my application come up talking about Unsafe Expressions, and
>asking whether I want to disable them? And how do I stop it from doing so?
There are several ways to do this. You can set the Macro Security to Low (which isn't recommended by MS, but many people
do it) or you can sign your code, enable Sandbox mode, and instruct your users how to remov...Access 2007 Switchboard Manager
I am new to Access 2007 and am having problems with the switchboard launching
when I open the database. The detail portion of the switchboard is also not
showing up. I checked the properties and yes is the selection in the Visible
field. Any suggestions?
Pick the Data Base Tools tab at the top and Switchboard Manager to the
right. Pick edit and it shoud make sense. I just add a couple commands at
first, one being an exit. Once you save you should see the Switchboard form
under forms to the left. If not, pick All Access Objects arrow down then pick
object typed. Pick t...ENTOURAGE cannot access database
I hope you can help.
I tried accessing my entourage only to find message saying 'entourage could
not access my database'...
I read pages on www.entourage.mvps.org and reduced the free disk space among
Hours later (and not really knowing the damage/help that I had done) I
clicked on entourage to find that it would open but by setting up a new
account....therefore without all the hundreds of work emails/contacts that I
I have what I think is the old database but remember reading message saying
that re build is unlik...Some Access 2007 questions
I know that in earlier versions of Access, there was a limit of 255 fields
per table. Has this restriction been lifted in Access 2007? If so, what
is the new maximum limit.
Also, can you use an array on fieldnames in Access 2007? In other words,
right now, we are using field names such as:
"clYear_0", "clYear_1" and so on to store an array called clYear().
Could an array be stored in a less clumsy fashion?
"Michael Feldman" <Youknowwho@EatThisSpammer.com> wrote:
>I know that in earlier versions of Access, there was a limit of 255 fi...How to grand Access right to some mailboxs
How to grand Access right to a "User", and it has right to lanch specify
* such "User" is already belong to Domain Admin
"BigBIg" <firstname.lastname@example.org> wrote:
>How to grand Access right to a "User", and it has right to lanch specify
>* such "User" is already belong to Domain Admin
The Domain Admin group (along with other priviledged accounts) have an
inherited "Deny" ACE in the ACL of each mailbox for "Send As" and
Create a "normal" user ac...Access 2007-Report (Text Wrapping)
Is it possible to have text wrapping of a field on a report like the text
wrapping function in a cell in a worksheet in Excel?
Set the Can Grow property to Yes.
Build a little, test a little.
> Is it possible to have text wrapping of a field on a report like the text
> wrapping function in a cell in a worksheet in Excel?
"KARL DEWEY" wrote:
> Set the Can Grow property to Yes.
> Build a little, test a little.
> "SueW" wrote:
> > Is it possible to hav...adding pages to wizard prop sheet causes Access Violation.
When I add pages to the already created wizard property sheet I get an access violation
It happens during the following MFC call which I cannot trace int
void CPropertySheetEx::AddPage(CPropertyPageEx* pPage
HPROPSHEETPAGE hPSP = CreatePropertySheetPage(ppsp)
If I do not specify Title and SubTitle string IDs in the constructor the error does not occur
m_pageFilter.Construct(IDD_AXIS_FILTER, 0, IDS_TITLE_FILTER, IDS_SUBTITLE_FILTER); // causes erro
m_pageFilter.Construct(IDD_AXIS_FILTER); // o
There doesn't seem to be anything i...converting access 97 to access in XP
I converted an existing data base that was setup in 97
and backed up on disk and installed it into my new
computer which runs XP Pro. When I print a querie I
loose the cell outlines. Any suggestions please.
...Accessing sheet name w/o using mouse
Could someone please tell me how I can access the sheet name without using
the mouse? ... I like to use key strokes as much as possible and I don't
know of a way to do this...
CTRL + PageUp and PageDown will cycle through the sheets.
Up to go left, Down to go right.
Gord Dibben Excel MVP
On Sat, 19 Feb 2005 02:34:06 -0000, LavaDude <mikioi@TAKEOUTgte.net> wrote:
>Could someone please tell me how I can access the sheet name without using
>the mouse? ... I like to use key strokes as much as possible and I don't
>know of a way to do ...SQL to change closing totals
What tables do I need to fix if I entered a wrong closing amount for a
particular tender type?
What is the SQL to do this?
I erroneously entered $0 for checks for the day, then ran a Z-report. Thus,
I was short for the day by the amount of the checks. I know I will never be
able to fix the Journal, but I want to fix the database for reporting
This is a relatively simple task. The first thing you should do is make a
backup of your database before proceeding...
Once you ha...Routing and Remote Access service Server 2003
I am using a server 2003 as a router. (Not ISA) Is it possible to assign a
second ip address to the internet facing adapter and map that ip to an
internal ip ?
No, I don't believe it is possible.
I used second and other IP addresses exclusively for web sites hosted on the
IIS and nothing else.
"Dave Mc" <DaveMc@discussions.microsoft.com> wrote in message
> I am using a server 2003 as a router. (Not ISA) Is it possible to assign
> second ip address to the internet facing adapter and...Consolidation of totals from various sheet on to one sheet
With 10 worksheets in one workbook each with totals, how can I automatically
transfer these totals to a new worksheet to give an overall summary of the
I am not into gobbledygook so I need simple idiots understanding assistance.
All help gratefully received
Please reply to Group
Couldn't you simply use
Where A10 on each sheet has the totals
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"Dave Hawley" <dav...Newbie needs help to know how to access data from a PDA to a DataBase.
Could you pls help me get an idea on the basics of getting a data to
and fro to a Database from a PDA,i am using PPC2003 Emulator and
developing on EVC++ 4.0. And pls Pls include example codes if
possible....Thanks a lot in advance. I have to populate for e.g
,customer details form in the PDA with data from the oracle server.How
exactly do i do tat and wats the code for odbc connectivity.I am really
Just have a look at the following link.