Using dates in reports. Is there a sample database?
I am trying to get my head around using dates in reports (and queries). For
example pulling off all the, say, IT problems logged in the period Apr-June
07 in an issues IT issues database. Or any sort of database really.
I am not really sure how to use dates in reports and queries in this way and
none of the sample databases I've looked at really do this (Northwind or
some of the sample databases on the officeupdate site). I feel it would be
useful to see how it is done and would be grateful if anybody could point me
in the direction of a useful template/sample database.
You have...Protocol violation w/custm scurity on XP w/ a 2nd instance of SSRS
I am having an issue developing against a secondary instance of SSRS on XP.
I install the secondary instance and everything is fine. I can browse to
both instances, the secondary using the URL 'localhosts/reportdev'.
I then implement a known custom security extension by deploying DLL's and
making various changes to config files. The custom security enables the use
of LDAP instead of Active Directory for item role assignment authentication.
This bit is fairly complicated, but is known to work.
When I then browse to the secondary instance of SSRS I receive the follow...Moved priv databases and can't access Calendar Items from outlook??
I was running out of HD space so I went in to the Exchange console and moved
the private databases to another drive per instructions in a KB article.
Everything seems to have worked out okay, but now I cannot open my calendar
items or accept any invitations sent to me.
Anyone have any ideas on this?
"Sterling" <Sterling_Jacobson@RemoveMeHotmail.com> wrote:
>I was running out of HD space so I went in to the Exchange console and moved
>the private databases to another drive per instructions in a KB article.
>Everything seems to have worked out okay, but no...Move database from C to D
Can anyone give me direction on how to move the rms database from drive C
I'm using RMS 2.0.
Thanks in advance.
Here are some instructions I made for a friend. Please note that these
instructions were made on a computer where I didn't have access to an
SQL Database, so some of the directories could be wrong. If you need
more detailed instructions, e-mail my gmail.com account: natesawyer3.
1. Download the appropriate SQL Management Studio Express for your
operating system, and install it on the Computer with the database on
2. Open ...Auto-Refresh Sharepoint
I would like to know how this is normally accomplished out there in the real
We're looking at putting some of our Excel Reports out on our Sharepoint
Naturally, we need to set up a DSN on the server. But up until now, we've
had developers refreshing the data locally, on their own machines, and then
sending the Excel file to the manager who needed it. Doing it this way, we
only had to use Windows Authentication.
First - is this commonly done?
Second - how do you setup the authentication?
Any input would be appreciated.
...How can you import data from another database using query ?
I am using SQL Server 2005.
I would like to import data from dbA to dbB for tblMin, but only for some of
the data in tblMin.
Both dbA and dbB have tblMin.
So, in the import wizard, i selected "Write a query to specify the data to
transfer", then I write a query like this:
SELECT * FROM [dbA].[dbo].[tblMin] where symbol = 'ABC'
If I do this, the import wizard creates a new table called Query, and import
the data to Query, instead of importing it to tblMin on dbB.
How can I import the data to tblMin on dbB ?
fniles (email@example.com) writes:...Problem with MSDE
Has anyone had an issue where when a user logs on, the MSDE does not have
selected a database, and when you set it manually and log back off and then
on it is once again not selected?
I've seen this where MSDE already existed but didn't list its own computer
name on the drop down for SQL Server names. I found that if typed in the
local computer name followed by /crm then that would work but only until the
end of the session. I found that the answer was to remove SFO, then uninstall
MSDE and do a complete reinstallation of SFO.
"Chris S Patterson" wro...read-only on attempted update
I'm using Access 2003 SP3. Run Permissions are set to Owner's, User and
Group Permissions are set to Updata Data etc. When I try to update, I get
Error 80040e09, "Cannot update. Database or object is read-only" even though
the database is NOT read-only as shown under Explorer/Permissions. The .ldb
file is present when I open the database, but seems to disappear when I close
it. Noone else is accessing the database.
Where does the read-only setting come from?
...Access 2003 database opens as read-only on Vista with Office 2007
I'm moving my files from my old computer (XP, Office 2003) to my new computer
(Vista, Office 2007). When I open a 2003 Access database I created on the old
computer, it runs as read-only, even though that attribute is not set in the
file properties. How can I get the database to run normally?
"Cassandra Berg" <CassandraBerg@discussions.microsoft.com> wrote in message
> I'm moving my files from my old computer (XP, Office 2003) to my new
> (Vista, Office 2007). When I open a 2...Application project in the database is corupt!
I get this message, every time I run the debugger into what ever module in my
Access 2003 program:
"The changes you have requested to the table where not successful because
they would create duplicate values in the index, primary key, or relationship.
Change the data in the field that contain duplicate data, remove the index to
permit duplicate entries and try again."
and after that I'm not able to launch my program any more.
If I try to open a Module I get this message:
"The Visual Basic for Application project in the database is corrupt"
No way t...To add a new entry into Database
can you assist me in adding a new entry into the database. I'm using MS
Access and ODBC driver and i'm getting error for the function
error: 'CRecordset::AddNew' : illegal call of non-static member
Thank you in advance
> can you assist me in adding a new entry into the database. I'm using MS
> Access and ODBC driver and i'm getting error for the function
> error: 'CRecordset::AddNew' : illegal call of non-static member
> Thank you in adva...database for wine club labels
I am asking for help to create a database so that MS-Word can print
labels and thus avoid the confusion that seems to occur whenever our
group bottles our brews.
tom dick harry
barolo 20 5 5
malbec 5 20 5
Pinot noir 5 5 20
In this example 3 members (Tom, Dick and Harry) share their brews but
after tasting and much consideration sometimes forget what is in the
bottles and this leads to much confusion. The obvious solution is to
label the bottles and the suggested format would be "Barolo Tom bottle
1 of 20" etc through to 20 of 20.
In this example it is not to arduous to copy or f...Enhancing database how to
So, I am giving a db I developed to someone else. I still have enhancements
to make i.e., I will be adding forms and reports. How do I port my
enhancements to the version they are using? They will be updating tables and
mine will be old data. If I copy my whole db over their updates will be lost.
As a general rule it's a good idea to split a database into front and back
ends. The back end has all the tables, and the front end includes everything
else. Each user gets their own copy of the front end on their workstation,
and the backend goes on some shared spac...RMS Offline database setup
How do i setup up the offline database? The part that i am getting hang-up
on is when i go to create offline database it ask for backup database, where
do i get this from?
And do i setup up an offline database for each register that is connected to
a main server?
Thank you in advance.
This is how I would do it.
First, it would be best to do this up when the store is closed and you have
closed out all registers so you can setup and test.
I would use the empty database template that comes with RMS to setup the
offline db. Create a new db and give it a recognizabl...2nd Mailbox
How can I create a seperate mailbox that I can send and recieve emails? And
also, would I be able to password protect it?
Wehn you say second mailbox what do you mean
a. a second mailbox in your existing profile or
b. a second profile with a different mailbopx account setup in it
in either case you can indeed password protect an email account
if you are using exchange then i suggest using a different profile for
you second account this is because you cannot use seperte inbox when in
exchange mode, your pop or ima...Maximum Database Size Reached
I am running MS Exchange 5.5 sp4.
My Information Store has just shut down due to the
Database size reaching its maximum.
I am about to follow the Knowledge Base article 185457
which explains that i need to defragment the database to
try and reclaim some free space.
I will run eseutil /d /ispriv
Is there anything else that I should look out for?
At the moment I am running an offline Backup in case my
defrag goes wrong.
Any help/sugestions greatly appreciated.
After you start IS make sure that IS Maintenance is set to always,
Deleted Items Retention is set to 0 days, conv...Database Independent aplication using XML
I have to develop a database independent application in c# 2003. It means
the underlying database should be anything like ACCESS, Oracle or SQL and my
application should not get affected if i change between databases. i also
have a requirement of storing 10,000 user records in my database. This
database can also be created by our customers and weshould be able to use
After reading ADO.NET i felt convinced that it is the solution for my
requirement. But later i was thinking when i want to create a database
independent application why i should use a database first of all, ins...boot after XP Pro format on 2nd hard drive
hey there, i formated my secondary hard drive that had windows XP Pro
installed on it. i formated it with XP Pro X64. after i formated it i tried
to boot from it as primary, no luck, and it would boot before the format. how
do i format it to its 80 gig a byte size with system on it to so that i can
boot from it???
any help would be appreciated.
On Dec 17, 1:42=A0pm, arealmes <areal...@discussions.microsoft.com>
> hey there, i formated my secondary hard drive that had windows XP Pro
> installed on it. i formated it with XP Pro X64. =A0after i formated it i =
t...Unrecognized database format 12-12-07
Not having much luck today, it seems...
In my quest to find an efficient way to import data from various sources to
our sql server, I'm currently trying to experiment with an mdb full of the
links and then opening them in code in my main adp program. However, I keep
Run-time error '3343'" Unrecognized database format...
And this happens no matter what mdb I try to open...
Dim db As DAO.Database
'Set db = OpenDatabase("L:\Reconciliation.mdb", False, True)
'Set db = OpenDatabase("L:\Sandbox")
etc. All of these db's o...Username/Domain/Password prompt appearing when attempting to download Offline Address Book (Outlook 2000)
Evening all! Hope someone can help me with this, before I lose ALL my
We've got multiple Outlook 2000 users who connect an exchange server,
but they an "Enter Password" box appears, prompting for a Username,
Domain & Password.
The box is blank & no matter what u enter it just re-appears, until
they press the ESC key once. The box'll then disappear & Outlook
closes OK...but I don't think the Offline address book is updating.
20% of the time, the box doesn't appear when closing Outlook, it's
just the other 80%! :(
They get this whether they...OLE
I want to embed about 10 different small images into my table, which will
them be display on a report. I have read through access's help screens, and
I believed followed the steps carefully, but I continue to get the work
PACKAGE in the OLE control instead of the image.
According to the help screens the work PACKAGE appears when you try to embed
a Jpeg or GIF file, however, I am working with a BMP file. It is b/w scanned
image which I cropped in photoshop and then saved as a BMP.
If any one knows whats wrong I would appreciate it. Thanks
Try using the clipboard: copy and then...Template path
I have a bunch of documents with a template-path to a server
"\\Server1\Office\Section_2\Templates\Template.dot" <-- one of them.
How can I replace the path to "blank" or another path?
I want something that doesn´t have to open the documents, just replace the
I search google, and found a bunch of VB-scripts that doesen´t work at all!
How can I fix this? I have 1000+ documents and its making me nuts.
It takes 5 min to open a document.
If your documents were in Word 2007 (docx, docm) format, you could edit the
xml out...Opening another Access Database file with VBA
I am in one of my Access database files, and wish to use a command button to
open another database file. How is this done?
On Sat, 9 Jan 2010 21:00:01 -0800, VWP1
There are several ways. Perhaps the simplest is using the Shell
function. Check the help file.
Microsoft Access MVP
>I am in one of my Access database files, and wish to use a command button to
>open another database file. How is this done?
On Sat, 9 Jan 2010 21:00:01 -0800, VWP1 wrote:
> I am in one of my Access database files, and wish to use ...Database source control
I am using SQL Server 2008. Just want to know what is the best method to
maintain the DB objects in source control and reverting back to any previous
version with ease.
Any pointers on this wud be of great help.
It depends on which kind of objects you're referring to. You cannot
maintain objects in source control, but you can maintain scripts of
objects in source control. Things like views, stored procedures,
functions, triggers, indexes, and synonyms can be maintained in source
control with scripts of those objects. Creation scripts of tables...Appearance and ergos
I'm working on modifying an Access 2003 database that was bequeathed
to me by my predecessor. The database part of things is proceeding
apace, but the UI is absolutely horrid! The colors are garish, and the
text is to small, among other things. Leads to eyestrain in very short
I could edit the various forms to improve things, but we're talking
about 60+ forms here! Is there a feature in Access that would allow
me to change things en masse? [Like a style sheet in a website?]
"Uncle Wulf" <firstname.lastname@example.org> wrote in message