Database Design Software

[franc sutherland]

Hello all,

I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.

Thanks,

Franc.

[Tony Toews [MVP]]

Re: Database Design Software

franc sutherland <franc.sutherla nd@googlemail.c omwrote:

>I would like to find a piece of software which would allow me to draw
>out the design of a database, rather than trying to keep it in my head
>and bits of paper. There are lots of options for open source
>databases, e.g. MySQL Workbench. Are there any which are appropriate
>for Access database designing? I use Access 2003.

If you are just concerned about tables use the relationships window in Access. Once
you've created a few fields in a table and added it to the relationships you can then
right click on it and update it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Carlos Nunes-Ueno]

Re: Database Design Software

The site below lists some of the various kinds of data modeling tools
that are available. Some of these will allow you to draw a design and
then automatically generate a database from that, among other features.

I think most of them support Access, but I'm not 100% on that.

http://www.databaseanswers.com/modelling_tools.htm

-Carlos

"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote in
news:enrgc4l9eu 0ooo6bqenjggqei dvrgrn22n@4ax.c om:

franc sutherland <franc.sutherla nd@googlemail.c omwrote:
>

>>I would like to find a piece of software which would allow me to draw
>>out the design of a database, rather than trying to keep it in my head
>>and bits of paper. There are lots of options for open source
>>databases, e.g. MySQL Workbench. Are there any which are appropriate
>>for Access database designing? I use Access 2003.

>
If you are just concerned about tables use the relationships window in
Access. Once you've created a few fields in a table and added it to
the relationships you can then right click on it and update it.
>
Tony

[franc sutherland]

Re: Database Design Software

On Sep 11, 2:19 am, "Carlos Nunes-Ueno" <sulla...@athot maildot.com>
wrote:

The site below lists some of the various kinds of data modeling tools
that are available.  Some of these will allow you to draw a design and
then automatically generate a database from that, among other features.
>
I think most of them support Access, but I'm not 100% on that.
>

http://www.databaseanswers.com/modelling_tools.htm

>
-Carlos
>
"Tony Toews [MVP]" <tto...@teluspl anet.netwrote innews:enrgc4l9 eu0ooo6bqenjggq eidvrgrn22n@4ax .com:
>

franc sutherland <franc.sutherl. ..@googlemail.c omwrote:

>

>I would like to find a piece of software which would allow me to draw
>out the design of a database, rather than trying to keep it in my head
>and bits of paper.  There are lots of options for open source
>databases, e.g. MySQL Workbench.  Are there any which are appropriate
>for Access database designing?  I use Access 2003.

>

If you are just concerned about tables use the relationships window in
Access.  Once you've created a few fields in a table and added it to
the relationships you can then right click on it and update it.

>

Tony

Thanks Tony, Thanks Carlos.
Both good suggestions.
There was a useful add-on for Eclipse at the modelling tools site
which I've downloaded.
All the best,
Franc.

[lyle fairfield]

Re: Database Design Software

franc sutherland <franc.sutherla nd@googlemail.c omwrote in news:1a5aabc6-
5f72-451d-9167-1d7dff92ea0d@x4 1g20...l egroups.com:

Hello all,
>
I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.

If you were to move to SQLExpress (free) you could use the SQL Server
Management Studio (free) which provides a powerful Diagram Dialog/Utility.
I create tables, relationships, and indexes there.

Of course, there are 7968345 other benfits to moving to SQLExpress; it's
not just another pretty face.

--
-
lyle fairfield

[Larry Linson]

Re: Database Design Software

"lyle fairfield" <lylefa1r@yah00 .cawrote

Of course, there are 7968345 other benfits to
moving to SQLExpress; it's not just another pretty face.

Just as a matter of personal interest, what is benefit number 6498743? :-)

You been lurking in microsoft.publi c.access again and reading the responses
of Mr. Aaron Kempf, again, Lyle?

Larry

[lyle fairfield]

Re: Database Design Software

"Larry Linson" <bouncer@localh ost.notwrote in
news:q2%yk.119$ 8v5.27@trnddc01 :

Just as a matter of personal interest, what is benefit number 6498743?

That a linked server can be created with a procedure.

CREATE Procedure [dbo].[LinkToOPEExcelF ile]
@FileLocation nvarchar(255)
AS
IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0
AND srv.name = N'OPE_XLS')
EXEC master.dbo.sp_d ropserver @server=N'OPE_X LS',
@droplogins='dr oplogins'

EXEC master.dbo.sp_a ddlinkedserver
@server = N'OPE_XLS',
@srvproduct=N'E xcel',
@provider=N'Mic rosoft.Jet.OLED B.4.0',
@datasrc=@FileL ocation,
@provstr=N'Exce l 8.0'

This can be useful when modifying a client db; it does not require the
laying on of hands.

You been lurking in microsoft.publi c.access again

I haven't been in a Microsoft group since I was banished several years
ago (after all my knitted polyester suits wore out) for not dressing
appropriately. Apparently attire must match the ideas tossed about in MS
groups.

and reading the
responses of Mr. Aaron Kempf, again, Lyle?

Aaron sometimes (often?) has useful knowledge and experience. Delivery in
his M1 Abrams tank may not be so effective.

--
-
lyle fairfield

[Larry Linson]

Re: Database Design Software

"lyle fairfield" <lylefa1r@yah00 .cawrote

I haven't been in a Microsoft group since I was
banished several years ago (after all my knitted
polyester suits wore out) for not dressing
appropriately. Apparently attire must match the
ideas tossed about in MS groups.

If only you hadn't "fessed up" that you were "sittin' here at th' keyboard,
nekkid as th' day I'z born". <SIGH>