Printing Database Properties
In MS Visio 2003 I have created a database diagram and would like to b
able to print the database properties (column names, data types an
notes) along with the diagram, or, export the database properties t
word or excel. Is this possible? I read elesewhere that they can b
imported into Visual Studio, does anybody know how to do this
NPC's Profile: http://www.officehelp.in/member.php?userid=512
View this thread: http://www.officehelp.in/showthread.php?t=126171
Posted from - http://www.officehelp.i
...Offline Terminal DataBase & Custom Table
I use the terminal database offline withe my POS (rms 1.3R).
I create my database with Pos administrator, specifie the server for offline
When I generate Z report , the database synchronize items and customers. But
my problem is : I have a custom Table with Price connected to the Item's
table, and this table doesn't synchronize with the offline database.
Is it a solution to my problem ? or a tips ?
Sorry for my english.
I had a sbs 2003 and exchange 2003 service pack 2. The email application is
installed on C drive. Now the c drive space had 2.5 gb left. I needed to move
the email database over to the d partition which had 40gb of free space. Can
I just go to the system manager -> frist storage group -> mailbox store right
click properties and click on database tab. Under exchange database do a
browse and point it to d drive. Do I have to give it a name priv1.edb on d
drive. What other gotchas if any after moving the database. I welcome any
Thanks a bunch for your response
...Moving databases #2
I know already know that my question is not a recommended solution but due
to current circumstances it might be my only option.
Is there anything that would stop me from moving the exchange databases to
an external hard drive? I know I will most likely suffer a major decrease in
performance among the other issue. But i need to know if there is anything
that would prevent me from moving the database to the external hard drive.
Why don't you first try telling us what issues you are having and maybe
someone here can give you a better solution.
P.S...Using VBA to switch to a particular Access database
Need a bit of help, please, with some VBA code that I've written in Microsoft
Outlook 2007. It is intended to call up a specific Microsoft Access database
and open a particular form and subform, so that it can then go on to take
various actions based on the values from Outlook. Here's the basic code:
Dim appAccess As Access.Application
Dim ThisDatabaseFileName As String
ThisDatabaseFileName = "C:\myFile.mdb"
Set appAccess = GetObject(ThisDatabaseFileName, "Access.Application")
I have different collation on my database than on the server. If I
change database collation to be the same as the collation on the
server, it works, but all varchar, char,... fields on tables now has
instead of database default collation the previous database collation.
How can I change the collation on my database that fields on tables
would still have database default collation, which is now different
You would have to do an ALTER TABLE ... ALTER COLUMN for each column where
you want to do the change. There's no one command that doe...Patients forms
I started to look read your postings recently and it has been amazing
what I have learned. For that I thank you all. I have this situation.
I am a physician trying to put my patients clinical histories into
excel. The reason being I want to use its capabilities for reporting,
statistical analisis and data consolidation without having to import or
export from and to other programs. I want it to be something that, by
having dsigned it, I can understand to perfection. I though of doing
it in Forms, in sequens, where in one I put the bios of the patient,
next current illnes, ne...Problem with database window
I'm not sure how this happened, but I can't find my Database window! The
database opens and runs as expected, but if I hit F11 or click the Database
window icon on the menu bar, it does not appear. I do notice that when I hit
F11, a vertical scroll bar appears with the 'slider' at the bottom and very
small in size. By trying to scroll up or down, I still can't get the
Database Window to appear??? Any ideas?
(I did change the screen resolution, then returned it to its original
setting. Could this be a factor?)
On Mon, ...Database
I donot know how to acess fields that contain dates in it.If it is a str or
number i use the following code.
m_set -> Open ( dbOpenDynaset, "select * from mmse" ) ;
m_set -> MoveFirst( ) ;
If you know the answer please help.Can you give me some sample code for
me,Thanks in advance
...Designing a patient management
Being a newbie to access, I have been given a task of creating a db for the
patient management and tracking. This DB will have around 50 patients per
year. It will contain the history of patient's contact info, pediatrician,
case manager,Genetic center info, Insurance info and so on. I have created
the tables. pls review them and suggest me your ideas to improve the DB, as
mine maynot be best.
RegID - PK
PatientID,FirstName,LastName,DOB,Gender,Hospital,MA,CaseStatus,Diagnosis,Address,City,Zip,county,MFirstName(mom),MLastName,MAddress,MCity,MState,MZip,MHomePhone,...Split Database, Can't Append to Table
I have a table to which I daily upload financial reports into one table, and
run an append query to add those records not already listed in the master
table. I recently split the database because of some other random conflicts
we began to have once two users began to access the database. I read that
splitting might help. Now I am unable to append to the master table using
the append query. I get a message that there is a violoation regarding an
index, primary key, or relationship. I've also tried to manually cut & paste
the records from the results of the append query with n...Database size bigger than it should be
Our exchange mailbox store database has just maxed out to 16Gb and is
offline, however it should not be this size as mailbox usage reports
total mail storage of 2.6Gb! Anyone know why the database size is so
much larger than it should be? Days set to retain deleted items is
set to 0
and has been for some time now.
Offline defrag using ESEUTIL has been run but very little space was
Posted via http://www.webservertalk.com
I am using Access 2003 for the first time and learning how to develop a
patient database for a non-profit program.
I've created a table that contains the names and personal information of
each patient participating in our program. My problem is this: I would like
to create a subform for each patient that lists their appointment history but
I don't know how to create a relationship between the patient and their
appointment history (which at the same time will allow me to enter more than
If "relational" and "norma...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...RMS Database Connection & Administrator Module Location
The only place I see to configure what RMS database to connect to is in the
RSM Store Operations Administrator. This raises a couple of questions for me,
that I have not been able to find answers to in the help files:
1) How does The Store Manager and POS software know where to look for the
database if the store administrator is not installed on the same PC?
2) In a store LAN environment, if we have the store Administrator, Manager,
and POS all on different machines, will the Manager and POS pick up it's DB
connection info from the PC with the Administrator on it?
3) If the answe...Database Suspected
Due to accidental shutdown of server machine the data base is gone in
suspected mode in SQL Server 2000. Is there any way except restoring database
from a backup to have the database in live mode again.
On Fri, 2 Apr 2010 12:54:01 -0700, Muhammad Bilal
>Due to accidental shutdown of server machine the data base is gone in
>suspected mode in SQL Server 2000. Is there any way except restoring database
>from a backup to have the database in live mode again.
&g...Can't Compact my Database
Every time I go to compact my database, Access shows, "Unrecognized Data
Format 'P:\...\...\...\file name.accdb'". I can't compact this. Previously,
I had set it to automatically compact, but that actually corrupted the file
beyond repair so I couldn't even open it.
Please tell me how I can compact this file.
It sounds like it's corrupt again.
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.
Try importing all the objects into a new empty database.
Download a copy of JetComp.exe:...sample database template
hi may i know if we are allowed to modify te sample northwind database and
use it in our small usinesses
Go ahead if it suits your needs. You may want to look on the Microsoft web
site for other templates, or maybe search online, if Northwinds does not meet
your needs. NOrthwinds is more of a sample database than a template, so you
may find it is worthwhile to search for other options.
>hi may i know if we are allowed to modify te sample northwind database and
>use it in our small usinesses
Message posted via AccessMonster.com
http://www.accessmonster....Shrink Journal Database Question
We have SQLExpress and are nearing my size limit. We installed SQL Express
because the we needed the extra space. When I was shrinking the database
before SQLExpress, I would use the following instructions:
"You will need to do two things to shrink the database. I assume you are
comfortable getting into Store Operations Administrator. If so, use the
1. Make a backup of the database.
2. Enter Administrator | File | Connect.
3. Connect to your database by selecting it and clicking OK.
4. Go to Query | New
5. Type: select * from journal
6. Query | Run
6. Writ...FRX access to Databases other than Dynamics GP
I was wandering there is a way for FRX to access databases (which is running
on SQl2005) other than Dynamics GP? Please advice.
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
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I have an excel page I use as an invoice that I owuld like to keep wha
is the best way to link certain cells to a database that does no
currently exist should i use excel or access?Can someone point me i
the right direction on the best way to accomplish this would like to b
able to scroll through invoices with just the data changing.
enahs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3394
View this thread: http://www.excelforum.com/showthread.php?threadid=53717
enahs wrot...COunting patients visits
I have a database detailing patients visits. In each visit I take patient's
photos, so each patient has many records for the same visit.
I created a query using the "unique values" property that outputs only one
record per patient's visit:
SELECT DISTINCT dbo_M2000.LASTNAME, dbo_M2000.FIRSTNAME, dbo_M2000.PIN,
FROM dbo_M2000 INNER JOIN dbo_IMAGE ON dbo_M2000.RECNUM = dbo_IMAGE.LINKNUM
ORDER BY dbo_M2000.LASTNAME;
Now, I need to count how many patients visited only once, how many patients
visited 2 times etc. I don't need the patient's names-...Database backup whilst the POS is in use
I currently do my daily database backup during the night using a scheduled
Windows task. The backup is copied to multiple hard disks on different PCs.
I would like to do additional backups during the day whilst the POS is being
used. Does RMS SO actually allow this or would I have to briefly shutdown
the POS for the backup? I am on V2, SP2.
Thanks for your reply.
Yes, you can run backups while POS is running. You can even run
backups when multiple manager programs are running. SQL server is
built to handle many different concurrent connections.
As another option, you can also use the c...Max 5 Simultaneous Users of a Database?
In his book "Access VBA Programming for Dummies", page 299, author Alan
Simpson discusses splitting a database into a front end and a back end to
enable simultaneous use. The front end is then distributed to each user "up
to a maximum of five simultaneous users". This seems a very low maximum -
probably not one that I can live with. Is it accurate? Any advice or
suggestions in this regard?
David Portwood wrote:
> In his book "Access VBA Programming for Dummies", page 299, author
> Alan Simpson discusses splitting a database into a front end and a
>...mdb database opened with CDatabase is ALWAYS read only ...
I'm trying to open a mdb database opened with CDatabase and it is ALWAYS
opened as read only.
Leandro Gustavo Biss Becker
I've found this
"Leandro Becker" <firstname.lastname@example.org> wrote in message
> I'm trying to open a mdb database opened with CDatabase and it is ALWAYS
> opened as read only.
> Leandro Gustavo Biss Becker