I am trying to upscale several databases from mdb to sql server. Unfortunately I am not sure of all the programs that use these database tables. Is there a way for the mdb to store what programs request data from it or alternatively the username. Im thinking not but worth a check.
View RepliesHi,
just starting out building a database product for mineral collectors and wanted to know what to do went it is complete.
If you want to issue the finished collectors data base as an application to other users do you need a program generator?
I have heard o the Access tollbox, does this do carry out the generation?
Thanks
I am hoping someone can give me guidance on a fairly major project I am working on.
I am responsible for producing lots of figures, charts etc. each month and the current process takes a very long time!
I have been charged with improving this process, which currently includes the following:-
Slightly changing some CSV files each month
Importing the CSV files to an Access database containing lots of other data and information
Running some queries off an SQL database and importing the results to the access database
Running a few queries in Access
Exporting the query results to Excel
Manual manipulation of the Excle files
Producing graphs and tables in excel
I am fairly experienced in Access and know a little Access VBA
I know a bit of SQL to run queries from SQL query analyzer
I have dabbled with VBA in excel
But I wouldn't really call myself a programmer
I need to automate the process as much as possible, but I am not sure which way to go. I would need a database to combine the data from CSV files and other information as current, but also need to build up a historical store of data.
I would then want some kind of front end to select the months and year to look at, plus different categories etc. then produce a table and chart to excel or easily exported to excel for distribution to other people.
Would a combination of Access and Excel using VBA be sufficient for this?
A colleague has mentioned using SQL, in particular MySQL, which is downloadable for free.
They have also said that you can develop a front end in visual basic and there are programs freely available where you can build a visual basic front end by drag and drop methods.
They also mentioned that you could build a front end using Java.
I have also read bits on this site about ASP and PHP and how they can be used as a front end with Access as a back end database.
In short, I am getting confused about which combination of tools would be best suited for this job!
Any assistant/opinions/thoughts would be greatly appreciated!
The output tables/charts etc. would have to be distrubuted to a large range of people in the company.
The database or front end would just be viewed by a couple of people.
Many thanks!
Sasha
I'm having an issue with two programs. One searches the DB and emails the results, the other searches the DBand prints labels from a report. When only one is in there the program will run fine. But when I try to implementboth at once then I get an error message that is something like: The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: SQLSafeThe way the form is setup I am using the same text box to enter my search criteria and the same option groupbox with my check boxes for what I'm searching for both programs. Is this possibly the conflict? Am I going to haveto have seperate option groups and search criteria boxes for each program? It would be nice if I don't because thiskeeps the look of my form clean. Thoughts?Code for Search Database and Send Email
Code:'Designed by M. Walts'Important information! this code requires a reference to the Microsoft DAO object libraryOption Compare DatabaseOption ExplicitPrivate Sub cmdEmail_Click()'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE City = '" & txtSearch & "'" End SelectstrSQL = "SELECT EMail FROM tblUser " & strWHERE'run the query and get the results into the recordsetSet rst = CurrentDb.OpenRecordset(strSQL)'Loop through the recordset and add all the EMailsDo While Not rst.EOFstrRecipients = strRecipients & ";" & rst!EMailrst.MoveNextLoop'remove the first ; from the strRecipientsstrRecipients = Right(strRecipients, Len(strRecipients) - 1)MsgBox strRecipientsDoCmd.SendObject , , , , , strRecipients, txtSubject, txtBody, Falserst.CloseSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End FunctionCode for Search Database and Print LabelsCode:Private Sub printLabels_Click()'Edited by Nicholas Brown, original code design by M. Walts'Important information! this code requires a reference to the Microsoft DAO object library'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE City = '" & txtSearch & "'"End Select DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "tmpClients" strSQL = "SELECT tblUser.* INTO tmpClients FROM tblUser " & strWHERE DoCmd.RunSQL strSQL DoCmd.OpenReport "Labels", acViewPreview 'just view for testing, switch to print mode later acViewNormal DoCmd.SetWarnings TrueSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End Function
Hi All,
I need some advice as to what is the best way for me to update a program in 3 different locations.
I have developed a program that I now have running in 3 separate locations. Each location uses the same program structure and tables, but they will have different data.
When I make a change to the one in our office, I would like to update the other 2 offices so that we all are using the latest version.
CURRENTLY: I make a database file with the “forms, Reports, Queries, and modules” necessary to accommodate the changes. Then I, email the file to the other offices. I then try to walk someone there at the office through; “Get Files: Import”, then delete the old files and rename the new ones. This is risky!!!!!:(
I know there is a better way of doing this, I just don’t know it.
Can some one help me on this issue?
Thanks for all your help….ENVIVA :)
I have a query called "Program Status Count" that keeps track of the current status of various programs. There are three statuses: Closed, Deficient, and WIP.On the Query, I used "Total:" row and have two fields: StatusID field set to "Group By" then in the next column I have the same StatusID Field set to "Count" (it auto-renamed itself to CountofStatusID)...which on the query does what it is supposed to do:
Closed, 2
Deficient, 1
WIP, 1
When I go to the Report Design and try to make a Pie Chart (or any graph) it asks me what query I want to use, so I point it to the Program Status Count Query and select the only two fields I have in the query.This is the Row Source Code:
SELECT [StatusID],Count([StatusID]) AS [CountOfStatusID] FROM [Program Status Count] GROUP BY [StatusID];
Sometimes, it will show the appropriate fields but then it will disappear in Report View, switching to Print Preview does not fix the issue. Actually, it often deletes the correct information in the chart and use the PK autonumber instead of the words.Othertimes, the default data shows up and nothing I do changes it. I have even done the copy/paste of the query table in the report (doesn't work when the graph needs to update.
Hi
Has anyone ever got this error message before? I’ve never came across it and I don’t know how to fix it. The error message displayed when I added three extra labels to a form then tried running it. At the beginning, it took more time than usual to think about it then the error message was displayed. Now I can’t open my form in design view nor can I run it! It’s totally inaccessible.
The error msg is attached.
Any help will be very much appreciated,
B
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.
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
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.
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.
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.
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
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.
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
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
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
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?
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
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
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
:confused: Can I make my Access database into an .exe file or something like that so anyone can use it w/o Access?
View 6 Replies View Relatedhi,
can anyone help me i am trying to find a very competitive person, company who can deisgn my companies database for me.
i will behonest i have tried myslef and got stuck,therefore resorting to asking for help for someone to do it for me. lol
it will be a basic database,
all i need is the following:
Customer information.
Accounts(to keep track of payments etc)
orders
deliveries
expenses.
service records
and if possible be able to print off all worksheets etc from the database instead of having them stored elsewhere.
em
I'm new to this site. I have Access 97 Pro. I have a problem as cited below. I have 2 Access 97 tables called: Name and Activity. The fields in the Name table are: NameID (set to autonumber and primary key) and Name (set as Text). The fields in the Activity table are: ActID(set to autonumber), Activity(set as Text) and NameID(set as number). There is a one-to-many relationship between the tables. Name is the ONE and Activity is the MANY
Have a form and subform; Name is on the form and Activity is on the subform. The idea of this database is to link a name to various types of activities. Each name could have a multitude of activities. There are only about 25 names. I want to make the Name field a combo box so the user can pull down the menu and select a particular name. I also want the Activity field in the subform grid to be a combo box so various activities can be selected easily, probably in alphabetical order. There are some other fields in the grid: date of activity, staff, participated, etc. I'd even like the staff field to be a combo box so a staff name is easily entered (I'm probably wishing for the impossible). The problem I’m having is knowing how to link the two combo boxes so that when the user selects a name, any related activities show in the Activity field in the grid. If there are no activities related to a Name, then the user could pull down the menu and select an activity. Currently I have both the name field on the form and the activity field in the subform as a text boxes. I can enter names and activities and the particular name is connected to that persons unique activities. Using textboxes works fine. My wanting to use combo boxes is my attempt to make the database that much easier for the staff to use. Is there a way to do this? If not, I'll have to tell the staff that it can't or I don't know how to use the combo boxes and they will have to live with the way it is now. Any help would be much appreciated.
Hello,
I want to do something quite simple to start with and expand on it as my knowledge of databases grows.
This is what I need:
Open Access
Window appears ''Type company name'' and a textbox
Company001 is typed and a new window appears with something like: Add, Edit, view, Switch company.
Next to ''add'' there should be a dropdown list were the user can type in the name or select it from the list (something like if you type the first 3 letters the whole word will come up). Now comes the part which I cant do: i need the user to either press enter or click on a ''go'' button which takes the user to a new form to enter details. Just like the name their typed where a button.
I need some suggestions on how to put my access database into the web. Here's what I have and here's what I need. I have a database with forms that need to be put on the web so that users can fill out the forms. The first thing that should appear is a switchboad and they can then select which ever form they want to fill out. There's a total of 4 forms right now. If anyone has any suggestions let me know.
View 3 Replies View Related