Distribution Of Database (without Access)

Aug 2, 2006

What's the best way to go about this?

Right now I have about 40 personnel using 40 different Excel files. Each day, each file needs to be copied and pasted into one large file. I've recently had luck replacing several of my personal Excel files with MS Access and now completely hooked on using databases. I would love to replace all of those Excel files with a Database on the network, at the end of the date, compiling everything together would be as easy as a query, and possibly an export (if we needed to send the Excel file out as we sometimes need to).

I've got the use of a Network, but here's the rub. I'm the only one with MS Access installed. I can not talk my boss into buying the additional licenses needed for Access on their computers.

My edition is also not a "Developer Edition" as I've seen where you can create a runtime version, so I guess that's out.

What would be a suitable "frontend" to do something like this. I'm pretty decent at Access, but certainly no expert. What is the best/easiest options that I should be looking at?

I'm willing to learn something new if I have to (which I probably will). I'm also willing to spend some of my own money to put something on my machine at home if it will help me develop something. I just need options because I don't know enough to make a decision about this.

Thanks in advance.

View Replies


ADVERTISEMENT

Database CD Distribution

Jun 7, 2006

Afternoon

Apologies if this is in the wrong place, but I've looked around and can't find anywhere else that's relevant.

Essentially, I have a large reference database that I'd like to send to a fairly large number of people, preferrably on CD. Copying and pasting information into another format, such as Excel isn't an option.

My question is, how could I setup the content of my CD so that everyone could access it, even if they don't have Access? Could I include a copy of Access Runtime on the CD? Would that enable people who don't have Access to view the data on the CD? If so, would there be licensing implications if I did this?

Sorry if that's convoluted, but I'm not technical.

Thanks

View 2 Replies View Related

Way To Have Multiple Distribution On One Field Without Creating Multiple Distribution Fields?

Mar 1, 2012

I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.Is there a way to have multiple distribtion on one field without creating multiple distribution fields?

What I have is a database which contains Drawing Numbers - I need to create a report that shows where the drawing has been distributed to, with it's current revision status and the date is was sent.I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.

View 4 Replies View Related

MS Access Distribution With MySQL Backend.

Feb 2, 2007

On my development machine everything works great, but I know that I'm going to run into problems with distribution.

I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.

Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.

Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.

View 1 Replies View Related

Front End Distribution

May 16, 2006

I have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my users.

I have a split db and need to distribute it to about 20+ people. The back end will reside on a shared drive that is mapped the same on everyone's machine.
I also have the FE on the same drive and am currently using a batch file run from a link on our website to open it, therefore we are all using the same front end which is what I am trying to eliminate.

Can I just zip up my FE and email it to my users? Will that maintain the links to the back end when they unzip it to their desktop?

Also, I would like to get some feedback on some software I am thinking of buying for pushing out my updated databases in the future. It is called Access Frontend Loader
http://www.frontend-loader.com/

Has anyone used this before? Would appreciate any thoughts on it or any other program you may have used in the past.

Thanks

View 3 Replies View Related

Create Distribution Package

Mar 25, 2006

I have developed access application (front/backend) for my client. As client wanted they would be running on 3 comps on LAN. 1 comp would have the DB and the other 2 the frontends. How will I create installation (CD/package) so that it can be distributed in the clients site. Any suggestion would be appreciated.
Thanks in advance.

View 1 Replies View Related

Front End Updates And Distribution To Users

Dec 27, 2006

Howdy!

I split my db last week and put both front end and back end files in a shared network folder. I backup the db every day to a different folder on the network server and also to my laptop. I usually backup right after a form update so that the latest version of the form is available to users who want to update their local copy of the front end. I've been sending email alerts to the users.

My question is this: What is the best way to (1) make sure my backup updates the front end on the network server and (2) how can I automatically alert users to update to the latest version of the front end?

Thanks gurus!

bugleboy:o

View 13 Replies View Related

Automated Per Record Report Distribution

Jun 11, 2015

automated per-record report distribution. In my system there is a report generated with a record for every person that must be sent out to them on a periodic basis. Ideally I would like to send them out in batch(5000+ records) so that each person receives theirs via E-mail. I am not too worried about the format. Each persons record contains their E-mail address so that should make things easier.

View 2 Replies View Related

Printing/printer Properties Distribution Issue.....

Nov 7, 2005

I hope I can explain this right(and its in the right forum)....newbie....How do you distribute microsoft access 97 front-end program to several users on a network, along with printer properties for multiple printers? Any help would be greatly appreciated. Thanks :o

View 1 Replies View Related

Create Relationships Within Document Distribution List

Sep 9, 2011

I am brand new to using access databases but I am in the midst of trying to set one up for controlled distributions of controlled documents.Essentially, I have three tables:

1) Listing of all our controlled documents and their properties (doc number, doc title, doc revision, doc type, doc status, effective date),
2) Listing of all our copyholders (name, location, phone number),
3) Document Distribution List which lists copy numbers, quantities, and medium to deliverable (paper, electronic, size, etc)

What I want to do is create relationships within the Document Distribution List (using 'add from existing fields') from the other two tables so when a request for a new controlled copy comes along, I don't have so much data redundancy.

For example, in Table 1, I have listed Document XYZ and copyholder Jane Doe from Table 2 wants to receive 1 copy of Document XYZ. I would like to have Table 3 have an added field from Table 1 where I can pull down the applicable document number, which when selected auto fills out it's corresponding details of title, revision, doct type, status and effective date in this Table 3. In addition, after I select the document Jane wants, I want to have another field added to Table 3 from Table 2 which lets me pull down Jane's name to assign her a copy number.

View 1 Replies View Related

Modules & VBA :: Send Email To Outlook Distribution List - To / CC Or BCC Parameters

Jan 4, 2014

Is there a way of doing the above? I have several distribution lists (some >100 recipients) defined in Outlook, and would like to use the Docmd. Send Object command to send messages to one or several of them. I cannot find a way of defining a distribution list as any of the To, Cc or Bcc parameters.

View 2 Replies View Related

General :: Divide Groups By Equal Distribution Of Merit / Talent?

Aug 9, 2013

I am with an educational organisation. Now we need to allocate various fields to students depending upon their merit, where the difference between the average percentages between any two groups cannot be more than 2% and that also implies equal distribution of talent. However, First few have to be given choice of field and also students recommended have to be given choice. The number of fields varies from 2 to 8. . Further the vacancies are also not equal in all fields. E.g. for 100 students to be divided in four fields the vacancies can be 35 for ZZSS, 24 for UYTE, 29 for OIUI and 12 for HGFT.

I need a solution preferably in MS Excel or MS access for the same with nil/ least usage of VBA.

Table examples

Name REg. No. Percentage

Aaa 986544a 89.3%

Bbb 547521j 87.2%

Ddae v44887y 95%

View 8 Replies View Related

Best Way To Import SQL Database To Local Access Database?

Dec 25, 2005

I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.

Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.

View 3 Replies View Related

How To Access Ms-Access WorkGroup Tables To Change Database Login Password

Apr 13, 2007

Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.

Regards,
Kishore

View 4 Replies View Related

Using Access's User And Group Accounts Or Using A Login Form To Access Database?

Sep 9, 2005

Using Access's User and Group Accounts or Using a Login Form to access database?

I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.

I also saw some sites where they give an example of a Login Form and how to create one.

My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?

But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?

Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.

How would I go about creating that. Hope I made my explanation clear.

Thanks in advance.

View 3 Replies View Related

Locking User Access To Database Objects (MS Access 2000 And 2003)

Apr 15, 2007

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

View 1 Replies View Related

Access 2000 Database Not Working Under Access 2003

Dec 7, 2005

i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:

You dont have permissions to modify.

If i run it on access 2000 it runs fine.

Someone please help.

View 5 Replies View Related

Convert Access 2000 Database To Access 2003

Sep 27, 2006

Hi,

A few years ago I’ve made an access database on access 2000. The problem is that now I’ve installed the office 2003, and I can’t make the database work properly.

At first says that are missing those files: “tshoot.ocx”, “msioff9.ocx” and “msowc.dll”; so, I’ve copy them from another computer using office 2000 and now only complains about “msioff9.ocx” saying that my database contains a reference incomplete to it.

Is there no other way to convert my database do work properly with access 2003? What can I do?

Regards

View 2 Replies View Related

Access 2003 To Access 2007 Split Database

Mar 8, 2007

Hi All,

Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb).

Problem: In the split database, I've saved the Application .mdb as 2003, relinked and made a new .mde. But the Users still cannot open the database. (I did this in a copy until I figure out the nuances with 2007.) The 2 other unsplit databases can be saved as 2003 version and Users can open OK.

I'm grateful for any suggestions on working with Access 2007. I've been trying to tackle the ribbon which is a whole other question.

View 4 Replies View Related

Access 2003 Database Not Functioning In Access 2007

Mar 30, 2007

Hi

I have an Access 2000/2003 database which opens up and displays correctly in Access 2007, but when I go to use the File>Print command, or for that matter any of the other pull down menu's nothing happens?

Has anyone else experienced thisproblem, or does anyone know what I am doing wrong?

Any help greatly appreciated.

Thanks

Steve

View 1 Replies View Related

How To Gain Access To The Database From An Access Application?

Jan 10, 2007

Hi

I have this Access application. Now I want to see the databases and fields defined.but when I open the access file, it straight opens the access application.
Then when i press Alt+F11, it opens VB Editor. Then when I click on Design mode it comes back to access in the design mode, but still does not shows the design mode for databases and reports and all.

I can remember there is one more step I need to do after getting into the design of the form.But I cannot remember that

Could anyone please help me out

thanks
namit

View 1 Replies View Related

Remote Access To Access 2000 Database

Feb 20, 2008

Hi,

I am doing some computer work for a company that has an Access 2000 application. This app is split up between a program database that contains the forms, reports, etc. and a data database. Both the program database and the data database are located on a Windows 2003 teminal server. There are usually two or three remote users logged into the terminal server, but this number is about to increase to 6 or 7. I am concerned that these user's will all be running the same copy of the program database. I have read that this can lead to performance problems.

I was wondering if anyone hear thought either of the following would be an improvement:

1. Put a separate copy of the program database in each user's profile on the terminal server.

2. Rather than keeping the program database on the terminal server, put a copy of it on each of the remote client pc's. Then set up a VPN connection to the server and use this to link to the data database.

If anyone could tell me if either of these options would lead to improved performance, I would really appreciate it.

Thanks in advance,
Paul

View 2 Replies View Related

Access Database Without Opening Access First

Jul 20, 2007

I'm wondering if there is a way to open an access database (ive started with a microsoft template for an inventory management database) outside of the access environment. I'd like the program to run more like a .exe file rather than a database, but still having the links to and the functionality of the microsoft database

is this possible?

View 2 Replies View Related

How To Run Database FE Without MS Access

May 9, 2005

I have written (what I think) is a great database, but when I came to install it I found out that the users I wrote it for did not even have MS access on their computers.
Is there a way that I can save the FE in a different format, or is there a tool, that they can use the FE without having to install Access?

This is the only database / Access they will use

View 2 Replies View Related

Access Database For PDA's

Aug 2, 2005

Has anyone here used Access on a PDA yet?

I'm looking into the possibilities of creating a db to be used on a PDA for people to instantly update records, and then possibly download the data onto a pc to update the main db.

Any suggestions?


thanks

View 3 Replies View Related

Access Database

Aug 14, 2006

We have this database which is used by a member of staff for some reason even though the system clock is at the correct time and all other office programs like word and excel save the file and show the correct time. when evre this user saves there database and goes to view the time its showing as being saved an 1 hr behind insted of at the correct time.

Has anyone ever heard of this before.

Phill

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved