Access Database questions
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
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
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.
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.
Last Post: 12-03-2008, 02:32 PM
By anonymous in forum VB Classic
Last Post: 10-07-2001, 06:53 PM
By Matt Wyant in forum VB Classic
Last Post: 10-20-2000, 08:23 AM
By Kofi Brown in forum Database
Last Post: 05-09-2000, 10:37 AM
By Kofi Brown in forum VB Classic
Last Post: 05-08-2000, 10:13 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL