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]]

franc sutherland <fr**************@googlemail.comwrote:

>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]

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]" <tt****@telusplanet.netwrote in
news:en********************************@4ax.com:

franc sutherland <fr**************@googlemail.comwrote:

>>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]

On Sep 11, 2:19*am, "Carlos Nunes-Ueno" <[e-mail]>
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]" <[e-mail] innews:en********************************@4ax.com:

franc sutherland <[e-mail]:

>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]

franc sutherland <fr**************@googlemail.comwrote in news:1a5aabc6-
5f*************************@x41g2000...legrou ps.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]

"lyle fairfield" <ly******@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.public.access again and reading the responses
of Mr. Aaron Kempf, again, Lyle?

Larry

[lyle fairfield]

"Larry Linson" <bo*****@localhost.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].[LinkToOPEExcelFile]
@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_dropserver @server=N'OPE_XLS',
@droplogins='droplogins'

EXEC master.dbo.sp_addlinkedserver
@server = N'OPE_XLS',
@srvproduct=N'Excel',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=@FileLocation,
@provstr=N'Excel 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.public.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]

"lyle fairfield" <ly******@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>