Access Database questions


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Access Database questions

  1. #1
    Join Date
    Dec 2012
    Posts
    2

    Access Database questions

    Hello everyone!

    I am in no way a programmer, though I can understand when told to do certains things and I know a few (very few) things about programming.

    I request help concerning a demand from my employer I have. Here's the situation:

    We are a car dealership which employs about 10-12 employees that use the same shared Excel spreadsheet. We log all of our notes on an Excel spreadsheet (aka, we receive a price quote from the internet, we will log in the spreadsheet when we received it, name of the customer, who sent the quote as well as the notes of the rep who ended up calling the customer.)

    The problem is that the spreadsheet constantly gets un-shared or just plain deletes itself, so we end up losing follow-up notes that are important, especially to the Director.

    I would like to know if there's a way to created a shared Access DB that will auto-update let's say every minute, whether there are changes or not. This way, the employees could keep the file open at all times, whether they need it or not. It would prevent the file from getting un-shared and being closed the wrong way and thus deleted from the server.

    I seek thy help, great web panel! hehe

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    What do you bring Excel into this?

    Why don't you create a screen/form that writes these notes/quotes directly back to your database?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Dec 2012
    Posts
    2
    I was mentionning Excel because it is our current way of doing it. I want to replace our current Excel Spreadsheet with a shared Access DB that update itself lets say every 1 or 2 minutes, this way, everyone has the updated notes at the same time.

    I know how to create a form/query with Access (in a very basic way that is), I mostly need help on how to make it sharable (I haven't seen this option anywhere, unlike MS Excel) and how, where and what code I'd need to add in the DB for it the be refreshed in a timed interval.

    Thanks again!

  4. #4
    Join Date
    Jan 2013
    Location
    Cincinnati
    Posts
    1
    To make a access database file shareable you need to copy it to the network and have access loaded on each machine then put a shortcut to the database file on each desk top.

Similar Threads

  1. PDA Database questions
    By m2m in forum .NET
    Replies: 10
    Last Post: 12-03-2008, 02:32 PM
  2. Access Database Questions
    By anonymous in forum VB Classic
    Replies: 1
    Last Post: 10-07-2001, 06:53 PM
  3. More Database Questions
    By Matt Wyant in forum VB Classic
    Replies: 3
    Last Post: 10-20-2000, 08:23 AM
  4. Database questions.
    By Kofi Brown in forum Database
    Replies: 4
    Last Post: 05-09-2000, 10:37 AM
  5. Database questions
    By Kofi Brown in forum VB Classic
    Replies: 10
    Last Post: 05-08-2000, 10:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center