I have an Access Database whick I converted to 2003, using
the Database Convert. I want to distribute the database
and be able to upgrade the front end without changing the
underlying tables. I now want to split. When I split,
using the Database Splitter, the tables revert back to
Acess 2000. Any help?
ACCESS 2000 format is the format for ACCESS 2003 (and ACCESS 2002) tables.
Nothing is wrong.
<MS ACCESS MVP>
"Sylvia D" <email@example.com> wrote in message
> I have an Acc...database maintenance SQL 2005
At one time there was a knowledge base article on how to use the maintenance
wizard on SQL server 2005, for scheduled maintenance on the Dynamics
Databases, Does anyone know where that is? or have suggestions on what
options to select when using the maintenance wizard?
...Copying over a database
I am about to open a new store, and I am looking for an easy way to
copy over the item data without any of the sales or quantity info that
exists already (since that is store specific).
Does anyone know a good way to do this, or am I missing something
Shuffle & Cut Games
Anyone with an idea on this one? (Read: *bump*)
Figured this one out on my own - will save anyone reply time.
...Excel as DataBase in Front Page
Has anyone successfully used Excel as a database in FRont
Page, allowing users to make changes and update the
I am almost there I think but now am getting a "Data Type
mismatch in criteria expression" error message from the
ODBC Excel Driver.
Any ideas???? Thank You
...How to move CRM databases to different drive
I'm setting up CRM on Small Business Server 2000. The
small business server had been originally installed
without SQL, so I added SQL 2000 using the small business
server installation wizard. I installed SQL in the
default location on C:\. I wanted to put the SQL program
files on C:\ and the data on D:\, but unfortunately the
installation wizard didn't give the option of specifying a
different location for the database files. I then ran the
CRM installation, which didn't give a choice of database
locations either. So I ended up with all the databases on
How do I mo...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...How do i recover a database lost during compacting?
How do i recover a database lost during compacting?
You could try looking for a file named db1 or some such thing in the same
folder. However, the best way (the only reliable way, really) is to back up
>How do i recover a database lost during compacting?
Message posted via AccessMonster.com
Felix <Felix@discussions.microsoft.com> wrote:
>How do i recover a database lost during compacting?
Also *IMMIEDIATELY* download, preferably on another computer...Exchange database size limit.
Hello all, other than running the eseutil is there
any other way in which I can decrease the size of my
exchange database? It is currntly to large to start the
service. Any help is appreciated. Thank you.
No, an offline defrag of the database is the only thing that will
physcially reduce the size of the database.
Microsoft Exchange Specialist Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You can use Exmerge utility to backup your database to a
pst, after which you w...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,...how to copy acces database field into word document
I' l be very glad if someone could help me to learn, how could i insert the
copy of access field into word document. I look for information regarding
posibility of diferent way of clasical insert merge fields into document. For
example I saw the word document with access fields inserted, but each field
was delimited with sqare brackets.
Thank you in advance.
I would urge you to take a look at
Specifically the 'Super Easy Word Merge.' about half way down the page. It
is relatively simple to implement and works...Show One Record For Each Patient ID.
I have a table that store data when a Patient visits a Medical Centre.
I have setup a form to take information (Parameters) for a query to run and
all works well except I don’t know how to show only 1 record per Patients ID
(conpid), I don’t want all records to show for each Patient only 1 (last
would be ideal)
Any help would be appreciated.
Existing SQL (so far):-
SELECT tbl_consultations.conid, tbl_consultations.conpid,
tbl_consultations.ConpDOB, tbl_consultations.conpfn, tbl_consultations.conts, ...Can we have Advanced Find on database other than MSCRM Database
When the Advanced Find button is clicked in Microsoft CRM,is there any
possibility that it can contact another database that is integrated with
Microsoft CRM and retrieve the information?
Kindly let me know if there are any inputs to this.
Unfortunately not - the data has to come from CRM entities
David Jennaway - Microsoft Dynamics CRM MVP
> When the Advanced Find button is clicked in Microsoft CRM,is there any
> possibility that it can contact another database that is integrated with
&...Access database created when opening Excel
Users are having a problem opening Excel within Access in
that it creates a 'psuedo-database' (they are not
importing). Access is creating a database with the same
name as the Excel spreadsheet. The users then have to
delete the 'psuedo database' (the one created with the
Excel name) when they close the Access database. Is there
a fix for this? Is there a setting that we are missing?
How are they opening Excel within Access? Are you using the Shell function?
MS Access MVP
Access Security: www.ltcomputerdesigns.com/...Overwrote Database
I hope some one can help with this. I accidently tried to name a new Access
database the same as a database that I already had created. I was allowed to
create the new database with the same name, but now the original database is
gone. When I go the new database, none of my original objects are there and
instead it looks like a new database. I have tried lookign in the recycling
bin, but to no avail. Can any one help or am I stuck. Any assistance would
be greatly appreciated.
If you don't have a backup, I do believe you are out of luck. You didn't
actively delete it but ...Joins Across Servers/Databases
Is there an easy way to use excel to create a single query that joins
two different databases, such as an oracle db and a MS SQL db, and
bring the data back into one excel worksheet.
This is a complicated task that I'm trying to accomplish, but have not
had any luck so far.
Thanks in advance
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Did you try Data>Get External Data>New Database Query?
In the wizard, select a table and proceed to the las...R&D database
I would like to create an R&D database with the following:
I want to create a Tests table, PartNumbers table, PartNumberTests table and
a Results table.
We will enter tests in the tests table, and part numbers in the PartNumbers
table. then we would like to assign tests to a partnumber in the
partnumberTests table. Up to here I have no problem doing this via forms and
creating whatever is necessary (relationships, queries, etc). Then We would
like to call up a form that would display a part number and its related
tests and empty fields so that results can be properly recorded (into t...Determing the version/service pack of a database
Is it is possible to determine the version/service pack of a database
without the corresponding DYNAMICS database?
This is not possible. The current service pack (build numbers) level for
each GP database are stored in the DB_UPGRADE table in the DYNAMICS database.
select * from dynamics..db_upgrade
On a second thought, if you know the version of GP where the database came
from and if you take a pesimistic approach and restore the database to a
shell company created with RTM version of GP, you can then proceed to apply
service packs to bring it up to the level you...Does Access 2007 corrupt 2000 database queries?
I have a database that I made a small edit to last night on my Vista machine
running access 2007.
The database is on a network shared drive (not ntfs).
The query still opens fine on access 2007, but on my XP machine running
office 2000, when I open or try to edit the query, Access 2000 just closes
with no error message at all. There is also no entry made in the
application event log.
When I attach my debugger, Visual Studio reports an unhandled exception at
0x1b018900 in MSACCESS.EXE
Access violation writing 0x00040ffc
So, clearly the file's not working somehow.
So, two questions...Year end close with 1 database and 5 entities
I have one data base with 5 entities. Each entity has its own Retained
Earnings account. MGP only allows one Retained Earnings account to be used
when closing the year. I currently now must do a journal entry to reclass
each entities Current Year activity out of that one Retained Earnings account
and to its own Retained Earnings account. I have been using 12/31/yy as the
date of the reclass entry. It however creates an out of balance for each
entity's Balance Sheet. The out of balance amount is the Current Year's
1. Does anyone else have this issue? If you...Converting 97 database to 2000 database
We have been trying to convert a database over with
resulting runtime errors and even one error during
conversion that warned of a corrupted Visual Basic for
I noticed that the database would work in Office XP.
(Although, we could not, and should not, make changes that
db because we would lose Office 97 functionality). So I
just made an experiment. I used Access 2002(XP) to
convert the Database to Access 2000 file format. The
conversion on this test copy of the database seemed to
operate normally and I could now open the database in
We have ...Can't open Access database
Our Access database now resided on our Server. If one person opens the
database from te folder it is in on the server, then no one else can go to
the Access database from that shared folder on our server. Is that normal?
...Database list vs pivot
I am following a tutorial to do a simple database list in excel.
The tutorial suggest me to do Data>List but in Data menu in excel
2000 I don't have list!!!!
Someone could tall me how to create a list with Excel 2000. If I
select Pivot start a wizard that cover with a mask my data
Data|List was added in xl2003 (IIRC).
It doesn't exist in xl2k.
Maybe you could use data|filter to see some of the features of data|list.
> Hallo everyone,
> I am following a tutorial to do a simple database list in ex...Patient database
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...wss3 database size limit
When our wss3 was setup, they used SQLExpress, which was free. Now about 1
year later I am noticinhg the database size is approaching the 4GB limit.
What would be the best way to address this? I do have a licensed SQL
standard 2008 server I could move to, but have read it is not a simple
process to move the wss3 dataabases and still have a functioning sharepoint
Im open to all options- what would be the least5 amount of work/risk to
...Patient Demand on X Day of the Month
I need to summarize and compare patient demand for appointments going back
over three years. I can pull the data and display the days of the week. In
Ms Excel, is there a way to line up the same days of each month - but not the
For instance, I need to line up and average all of the first Mondays in May,
all of the first Tuesdays in May and so on.
DOUG in Wichita
You are going to run into problems with that. This year April has 5 Fridays.
Last year it only had 4 Fridays. How would you like to deal with that type of
situation? You may be better off matching 52 weeks ...