Main Access Database

[David Springelmeyer]

We have a Databsae that we use for each job that is constantly needing
updates but there are 1000’s of these Db’s in different job #’s. Is there a
way to have one central Db so that when I make a change to a form or report
or whatever and it’ll update all the Db’s in the future?

 

[Jeff Boyce]

David

?!1000's of dbs?! That sounds a bit more like spreadsheets than relational
databases...

Perhaps it's a matter of terminology, or of data definition.

In Access, a well-normalized table structure can accommodate 1000's of
projects ... in a single table!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

Why do you have a separate database for each job?
As you see, it presents a host of problems.
You would be better advised to merge all of them into one with a field in
your Job table to identify the job. This will mean you have to set up a
relational model so any child tables to your job table will need to be
indentified and linked to the correct job.

Any other approach would be futile.

 

[John W. Vinson]

On Mon, 21 Sep 2009 08:01:09 -0700, David Springelmeyer <David

We have a Databsae that we use for each job that is constantly needing
updates but there are 1000’s of these Db’s in different job #’s. Is there a
way to have one central Db so that when I make a change to a form or report
or whatever and it’ll update all the Db’s in the future?

As Jeff and Dave say, you're very far off the right track with this design.

You should have ONE database for your tables; a second "frontend" database
with links to the tables database, and all the forms, reports, etc. with each
user getting their own copy; and the backend database should have *one* Jobs
table for all the jobs. Unless you have tens of millions of rows of data
you'll be fine with Access for the tables (and if you do, you're in a good
state to store the data in SQL/Server with an Access frontend).

Here are some resources for how Access can be best used for your needs:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[John... Visio MVP]

Hello David,

You got appropriate criticism of your existing system but not one of the
MVPs showed you how to correctly create the database you need. If you need
help with that, I can help you. I provide help with Access, Excel and Word
applications for a small fee. Give me a chance to get you up and running
quickly. My fee will be very modest. Contact me if you are interested.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the past year to
show Stevie's "expertise".


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Yes, you are right but a database is the correct tool to use not a
spreadsheet.

Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...


Sept 10, 2009
(In respose to a perfectly adequate GENERIC solution stevie wrote)

This function is specific to the example but not generic for any amount paid
out.

Steve



Sept 9, 2009

you can then return all the characters in front of it with the Left()
fumction. Would look like:
Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1)

Steve

No, it would not look like

Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1)

First of all, the constants are vbCr and vbLf: no quotes around them. With
the quotes, you're looking for the literal strings.

Second, you can't Or together character constants like that. Even if you
could, Or'ing them together in the InStr function like that makes no sense
at all.



John... Visio MVP

 

[George Hepworth]

Hm, Several other posters replied before you, and not of them asked if they
could charge him "a reasonable fee" to fix the problem. On the other hand,
they all did offer free suggestions about where to go to get the information
he needs to proceed. Moreover, they ALL suggested a continuing dialog in
anticipation of being able to assist here, in the free forums. That's more
or less, as I understand it, how free support is supposed to work--it's
free.

So you see, it's all in the eye of the beholder. If you see a chance to grab
a few bucks, you leap on it. If the rest of the posters here see a chance to
offer free support, that's what they do.

It's a good thing the regulars here know how to spot the opportunities as
well as the problems, isn't it?

George

 

[George Hepworth]

Steve, I am sure you are willing to ignore threads where I've offered free
suggestions, free ideas, free downloads, free links to other sites with
relevant functions, etc. but, that's your choice; this is a free, public
newsgroup, isn't it? (Actually, I donate most of my time and efforts
elsewhere, though, so there is not a whole lot here at the moment.) Rest
assured, though, it is ALL given freely with no expectation of a "modest
fee" in return.

Nonetheless, you are free, just like everyone else is free, to read or not
to read whatever posts you like, whereever you like. That's the point, it is
free. On the other hand, anytime I spot an attempt to violate the spirit of
the free, public newsgroups, I consider that an opportunity to help, albeit
in a different way.

Beyond that standard tactic of yours, though, perhaps it was your
solicitation sent to another poster, asking them to participate in a
violation of privacy by PUBLICLY posting private correspondance which really
annoyed me most today.

Being a libertarian, for the most part, I don't give a rat's patootie what
others do privately. I do care a great deal when someone like you attempts
to violate that privacy in such a blatant way.

While I believe in FREE speech, in all senses of the word, I also think that
an individual with integrity will attempt to stay within the bounds of
decency, if not just legality and that includes everyone who posts here. I
do have the right to state that opinion, do I not?

George

 

[John... Visio MVP]

He does not have to be appointed to comment on someones transgressions.

I see nothing libelous in what George wrote, you on the hand did make a
libelous statement by accusing him.

John... Visio MVP

 

[John W. Vinson]

You got appropriate criticism of your existing system but not one of the
MVPs showed you how to correctly create the database you need.

Perhaps you missed:

You should have ONE database for your tables; a second "frontend" database
with links to the tables database, and all the forms, reports, etc. with each
user getting their own copy; and the backend database should have *one* Jobs
table for all the jobs. Unless you have tens of millions of rows of data
you'll be fine with Access for the tables (and if you do, you're in a good
state to store the data in SQL/Server with an Access frontend).


Concise and not a fully worked out functional database, I agree, but it does
present a suggested table design which should solve the problem.

Please, Steve... you're becoming an embarassment to the newsgroup.

 

[Arno R]

Please, Steve... you're becoming an embarassment to the newsgroup.

Becoming ????

IMO he IS!
For several years now...Sad but true...

Arno R

 

[Larry Linson]

When I see a post of a problem that can be resolved
with a short answer, I freely post my answer. When I
deem that the poster needs extensive help, I offer to
help him or her for a small fee.

It's not difficult, Steve, to check the rules Microsoft set for posting in
these sponsored newsgroups. You very well know that repeated, continued
solicitation of paid work is not the purpose of the newsgroups, nor does it
even fall within the spirit of the newsgroups.