Sharing Access

  • Thread starter Thread starter Amy Hill
  • Start date Start date
A

Amy Hill

We put an auction on every year, and we have inventoried over 500 items.
When checking out, we have an Excel spreadsheet set up so it keeps inventory
accurate and it runs a macro that totals the amount due. Upon clicking the
button, the line item dissappears and a total running in the background. But
here is the problem. If I check someone out, and my neighbor checks someone
out, the item I am checking out is still appearing on her screen because we
aren't networked. Right now we have individual spreadsheets running and we
have combine all of the sheets at the end to get the numbers. Is there a way
we can a) make this 'networkable' so that if I check someone out, it updates
all the sheets at one time b) keep our formulas and macros?
 
Because you are using Excel spreadsheets, you should post your query in an
Excel newsgroup. Access is a relational database product, part of Office
Professional.
In general, what you describe is possible. You need to purchase an Ethernet
switch (ab. $30) and two network cables to connect the two machines. Someone
in an Excel group can give you details on how to set up a single spreadsheet
sharable by the two machines.
-TedMi
 
If you are using Excel, you should ask your question in an Excel group;
however, Access would be a better tool for what you are doing.
 
On Tue, 27 Oct 2009 07:35:02 -0700, Amy Hill <Amy
We put an auction on every year, and we have inventoried over 500 items.
When checking out, we have an Excel spreadsheet set up so it keeps inventory
accurate and it runs a macro that totals the amount due. Upon clicking the
button, the line item dissappears and a total running in the background. But
here is the problem. If I check someone out, and my neighbor checks someone
out, the item I am checking out is still appearing on her screen because we
aren't networked. Right now we have individual spreadsheets running and we
have combine all of the sheets at the end to get the numbers. Is there a way
we can a) make this 'networkable' so that if I check someone out, it updates
all the sheets at one time b) keep our formulas and macros?
Click to expand...

The "Access" in this newsgroup's name refers to the database software
"Microsoft Access", not to "sharing access to Excel spreadsheets" - so in a
sense it's the wrong forum for your Excel question.

But... it appears to me that a Microsoft Access database may be a better
solution to your business need than an Excel spreadsheet. Access is designed
for just this kind of operation. It's got a much steeper learning curve than
Excel though! Here are some resources if you decide to get started migrating
this project into Access:

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


If you wish to stay in Excel, you should repost your question on an Excel
newsgroup.
 
Zac Thompson said:
I DONT CARE IF U DO
Click to expand...

I would be greatly surprised if it mattered at all to the original poster
whether some juvenile piddling around in newsgroups cared what she did. She
certainly wasn't asking your, or anyone else's, permission.

Larry Linson
Microsoft Office Access MVP
 
John W. Vinson said:
On Tue, 27 Oct 2009 07:35:02 -0700, Amy Hill <Amy


The "Access" in this newsgroup's name refers to the database software
"Microsoft Access", not to "sharing access to Excel spreadsheets" - so in
a
sense it's the wrong forum for your Excel question.

But... it appears to me that a Microsoft Access database may be a better
solution to your business need than an Excel spreadsheet. Access is
designed
for just this kind of operation. It's got a much steeper learning curve
than
Excel though! Here are some resources if you decide to get started
migrating
this project into Access:

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


If you wish to stay in Excel, you should repost your question on an Excel
newsgroup.
Click to expand...
 
John W. Vinson said:
On Tue, 27 Oct 2009 07:35:02 -0700, Amy Hill <Amy


The "Access" in this newsgroup's name refers to the database software
"Microsoft Access", not to "sharing access to Excel spreadsheets" - so in
a
sense it's the wrong forum for your Excel question.

But... it appears to me that a Microsoft Access database may be a better
solution to your business need than an Excel spreadsheet. Access is
designed
for just this kind of operation. It's got a much steeper learning curve
than
Excel though! Here are some resources if you decide to get started
migrating
this project into Access:

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


If you wish to stay in Excel, you should repost your question on an Excel
newsgroup.
Click to expand...
 
Back
Top