473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Sharing MS Access data in the corporate environment?

jonnycakes
Hello everyone,

I've found myself in quite the predicament.. I've built a data entry access datbase using access 2000. I've split the database into a front end and backend, the backend is stored on a shared drive while the front end is utilized by approx 50 people to enter data.

I've built a very basic website that includes a link to a batch file that automates the installation process for the front end users.

Now, I need to find a way to distribute the data to an additional 70-80 people, but I want to keep these people out of the database to ensure the database doesnt take a hit on performance.

The additional 70-80 people that need the data must review the records that are assocaiated with their names(approx 30-35 records per month, 6-7 per week).

I've got access 2000 and excel 2007 at my disposal, but I do not have sharepoint, sql server, or many other tools.

I want these additional 70-80 people to be able to review the data to see how well their teams are performing month over month as well as comparing themselves to their peers. I could accomplish this by simply providing a shared workbook, but excel prevents users from running macros(which I need for my pivot tables); excel also prevents me from updating my data table via an access query.

Are there any BYTES.com gods out there that might be able to guide me in the right direction?? Thank you in advance for any insight you may be able to provide.
May 20 '12 #1

✓ answered by jonnycakes

I feel very stupid right now.. I don't know why i didn't think of this sooner, but I decided on splitting up my report into two seperatatle reports. One report will be a shared workbook that merely provides the raw data as well as provide the end user with the option to flag each record with a simple list box. .

The second report will not be shared, but rather a read only report. This report will contain all of the data analysis, and a direct odbc connection to my access query. This will allow me to control what records are available at what time. I will tie in some vba to copy my data from this report into my shared workbook.

I've included hyperlinks to link both files for easy access.

I'm sure there may be several alternatives that would better suit my needs, but I'm satisfied until I cross that path. I hope this helps somebody out there.

4 1621
zmbd
5,501 Expert Mod 4TB
So, basically all they need is a report, they don't need to actually log-in to the database, is that correct?
-z
May 20 '12 #2
They need a report with the option to flag each record as reviewed. Currently, they have a drop-box with "Y" or "N" (excel) as options to signify whether the record has been reviewed.

I have several problems with this. Problem 1: Shared workbooks do not allow me to easily update the raw data on a weekly basis or run macros. Problem 2: When distrubting individual files via email I have no way of knowing what was and was not reviewed in the previous week. Problem 3: This file is only going to continue to grow and with that being said distributing via email will more than likely waste bandwidth.

Please let me know if you have any further questions. Thank you for your time.
May 20 '12 #3
I feel very stupid right now.. I don't know why i didn't think of this sooner, but I decided on splitting up my report into two seperatatle reports. One report will be a shared workbook that merely provides the raw data as well as provide the end user with the option to flag each record with a simple list box. .

The second report will not be shared, but rather a read only report. This report will contain all of the data analysis, and a direct odbc connection to my access query. This will allow me to control what records are available at what time. I will tie in some vba to copy my data from this report into my shared workbook.

I've included hyperlinks to link both files for easy access.

I'm sure there may be several alternatives that would better suit my needs, but I'm satisfied until I cross that path. I hope this helps somebody out there.
May 21 '12 #4
zmbd
5,501 Expert Mod 4TB
Sorry it's taken me so long to get back to this a lot of other projects popped up, it happens, life is good!

Which version of Access are you using?

Now I haven't done this; however the following might be worth looking at - some guidance from the "Masters" about this suggestion is certainly worth waiting for:

- http://office.microsoft.com/en-us/ac...010015427.aspx

- http://www.dailymotion.com/video/x9p...al-data_school

This is something that appears to be new in MSA2007.

Something else to consider is a sub/mini database... what I do is take the subset of data requiring review, push that to a template database that has my logic in it and then compile it to an MDE if they have MSAccess or to a "runtime" if they don't (runtimes require a lot more care in their creation); however, I only do this for very small record sets, like a few dozen to a few hundred.
May 27 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: m3ckon | last post by:
Hi there, I'm trying to come up with a definitive list of ACcess data types that cause a problem when upsizing to SQL Server. On the last occasion that I upsizzed, SQL Server had an issue with...
2
by: Ebbie | last post by:
Hi, I wanted to know if Access Data Projects is a good option to choose for a SQL Server Database Frontend. The other option is C#. The database will be accessed by multiple users (around 100...
5
by: David | last post by:
Is the Access Data Engine part of the VS/.net install. Eg. I need to write a stand alone Form app for which a small DB would be helpful. IN VB 6, I would use ADO to call the Access engine. I...
1
by: Aravind | last post by:
Hi guys, In c#, How to dispaly the records from a AccessDB to a Windows Forms DBgrid.. Is there any need of creating datasources like in VB data access.
1
by: peteh | last post by:
Hi All; We recently upgraded to FP10 (from FP6) in our data warehouse environment. Have had a couple of issues with Oracle federation and minor configuration changes and all has been stable....
0
by: shapper | last post by:
Hello, I have a Connection String defined in my Web.Config: <connectionStrings> <add name = "dbAccess_JaquelineRoxoAtelier" connectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data...
1
by: swynne | last post by:
Hi friendly people...I am a newb to programming and need a little assistance. I have a small personal ad database created in Access, however all is well until I want the personal ad link to take me...
7
by: irfanali | last post by:
Hallo All, I m trying to create a Multi User Data Program on Access, where my team members would input data on a daily basis. Well the Problems start now : - How do i create a Multi-user...
3
by: Max58kl | last post by:
Trying to access data and print it to the screen using Perl Builders I/O Window -------------------------------------------------------------------------------- Hi I am using a program called...
7
ADezii
by: ADezii | last post by:
There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.