URGENT: Protecting Access Databases Online
Sep 20, 2006
Hi All,
What's the best way to go about protecting an MS Access database online? Hoping to launch tomorrow, but no can do without protecting the DB first
Basically, I have a database containing some personal information and I need to block people from downloading it, while still allowing my ASP pages to read/write/modify its data.
Can anyone point me in the right direction here? Any relative links, methods, tutorials, etc, would be a fantastic.
I've looked into User-Level Security Passwords, but am not sure if there's a better way to achieve what i'm trying to do (i.e. setting up specific access rights to the folder in which the MDB file is contained).
Thanks in advance...
View Replies
ADVERTISEMENT
Sep 24, 2004
Greetings,
I have created a database to track applicants’ eligibility process. Mainly, a Head of Household will call or apply in person for a medical assistance for self or for child #1, child #2 etc. I created two tables tblHeadHouseHold and tblApplicants with a (one-to-many relationships) and, a main form (frmHeadHouseHold) and a subfrom (sfrmApplicants). So far, the database works fine and just recently, I was approached first, to make this database available online, so that applicants can go to a given center (clinic) to fill in the application, and we then pull the application from the office. Second, to add a new field (source of Application) where applicants learn about our program (Friend, School, Doctor, Advertisement, other) to create a ‘Source Report’, how many from friend, how many from school, from Advertisement etc.
I’m using access 2003 and would like to know:
1. What I need to make the existing db available online
2. Given the type of report I need to generate for ‘Source of Application’ shall I use check box, drop downs,
or a lookup table?
Thank you in advance,
OCM
View 1 Replies
View Related
Mar 30, 2007
I want to locate an address online from my access database program upon clicking a button. What will be the best way to do this. Does access database have the tool to link address from your program.
Any help p
View 3 Replies
View Related
Aug 28, 2004
Hello,
I was wondering if anybody could please advise on how to make the existing database(Ms Access) online.
Does IIS server come with Ms office? How to install and what are the steps to make it a client server application.
Would appreciate your help a lot. Thanks
Regards,
GreetInfo
View 2 Replies
View Related
Jul 28, 2007
I am developing a very simple little app online that is giving me 2 main areas of trouble. Basically, all this app does is take information from a form and put it into an access db which is located on a web server (it also sends out an email to the admin when the form is submitted, but that is working fine). So there is one page that is the form and it is pointed at a second page that does the insert to the db, sends the email and then displays a Thank You message. I set up a ODBC connection on the web server to the database that seems to be working fine ( I can run a SELECT query against it and get info out of it - I put one dummy record in the db just for testing).
I'm having 2 main problems as follows:
Permissions - the sys admin is hesitant to open up the folder that contains the DB (and nothing else) to allow for write/read control to the anonymous internet user account. Just to test it, he did and I was able to run the query on the page (although I had problems with inserting - see problem 2 below). The sys admin suggested that I "use different credentials" to access this db in this folder and set up a separate user account/password for this purpose on this folder. 2 questions:
1.) how dangerous is it to allow read/write access for the anonymous internet user account?
2. what kind of code (.asp) could I use to access the DB using the separate user account the sys admin set up?
Insert to the DB not working - When I do run this page, it seems to run fine, with seemingly no errors, but when I do a SELECT query against it, none of the data is there. here is the code I am using:
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=RVU_contact_db"
objConn.Mode = 3
objConn.Open
strSQL = "insert into `contacts`(first_name,last_name,email,phone,addres s,city,state,zip,subject,message,department) " _
& "values ('" & request.form("first_name") & "','" & request.form("last_name") & "','" & request.Form("email") & "','" & request.form("phone") & "','" & request.form("address") & "','" & request.Form("city") & "','" & request.form("state") & "','" & request.form("zip") & "','" & request.Form("subject") & "','" & request.form("message") & "','" & request.form("department") & "')"
objConn.execute strSQL
objConn.Close
%>
I notice that there is a .ldb that seems to stay open in that folder, even when I do a objConn.Close, and I don't seem to be able to delete this off the server.
Any ideas on how to solve these problems? Any help on any of the above greatly appreciated.
Sincerely
johnmr
*
View 1 Replies
View Related
Feb 2, 2006
:confused: is ther anyway to lock ms access files , so that people would not be able to modify then and only view them, would not get to vbs screen etc, and give a limited password that will expire in given ammount of time.
View 1 Replies
View Related
Jan 30, 2008
HI,
I have a MS access 2003 database (in MDB format) which I use as a basic accounts system for our company (15 user). I have certain tables password protected depending on user using the old workgroup information file. This presents a problem as anyone can copy the database without linking the Information file and effectively get full admin access. I was looking to upgrade to Access 2007 but I gather that there is a different security engine and also a new file format (accdb file). I know that you can keep the same user security settings when upgrading to 2007 (while keerping the mdp file extension) but would be interested to know if I can improve security using 2007 while also being able to retain user-level access to certain tables like in access 2003? The major weakness in my system at the moment is anybody can copy the MDB file to another PC and access everyting...it seems too easy a system to crack. Do I need to completely reprogram my database using MySql on MSSql? Any advice would be appreciated?
Thanks in advance,
Shane
View 2 Replies
View Related
Jul 13, 2005
I’ve recently added form functionality on my website, which runs with the aid of a perl script and sends the results via an email message.
I’m currently able to import, or link, data from a specific mail folder (Outlook 2002) to an MS Access database (Access 2002). However, my problem is the message body, which contains the data I’m interested in, is all placed in the one field.
I would like the data contained in the message body to be imported into separate fields but I have not been able to figure out how this is done.
I can arrange the data within the email message body to conform to a particular format if needed, even HTML, but I can't work out how to import the data into separate fields.
Tried searching this forum but couldn’t find the answers. Perhaps there is a better way of processing online forms, one which I’m not aware of.
My web service does support mySQL and also has ODBC dirvers for Access but this to me seems like an over kill approach particularly since I don't need access to data from the website (active pages)
Can anyone help?
Thanks.
View 2 Replies
View Related
Apr 8, 2013
Where does one start to look for information on what is needed to set up an online web form that can write to an Access database? I'd like to learn how I could possibly set up an online registration form for clients to use via a web page. I don't really know where to start, but I have seen some information on asp.net stuff. What's the easiest path?
View 6 Replies
View Related
Mar 17, 2015
I have developed on ms access project (MS OFFICE 2010) i am trying to make it online so anyone can open Forms through browser.
Does it possible to make ms access Form online and view in browser? if yes then how?
View 4 Replies
View Related
Aug 17, 2006
Hi,
Basically i have a single database with several tables in it. I want certain tables such as Ireland, UK, US etc to only be accessable by employees from those countries. Is this possible and if so, how?
I have looked at user/group permissions but can't figure out how to assign passwords to users etc.
Any help is much appreciated
Thanks
Scott
View 2 Replies
View Related
Apr 18, 2013
I just created a huge database using access 2010. How do i setup security level to allow access by groups to specific records?
View 14 Replies
View Related
Jun 6, 2005
hi to all,
does anyone know the code to close the access program.
That is when i select the close button on the switchboard, the whole of MS access is closed.
Thank
View 2 Replies
View Related
Oct 20, 2006
Hi,
I curently have a website that has a registration page on it that uses a simple access database that contains a single table with the same fields on as that of the reg. form. What I want to do, in one way or another, is to make some sort of macro that starts once some datails have been submitted to the database using an SQL statement I made within Frontpage, send an email to the registrant telling them what there customer number etc (autonumber in database) and various other welcoming messages etc.
The SQL statement is along the line of INSERT INTO...
Am I thinking along the right lines with a macro or some code or is the access database literally rendered to a table/number of table and thats it?
Cheers folks
View 5 Replies
View Related
May 5, 2007
Hi,
Recently, i had upgraded my computer with some new hardware, therefore i did a fresh install of win xp sp2.
Now I noticed that after i installed all the usual software including microsoft office 2003, when i am opening a ms access database and i open the first form, most of the fields on the particular form (no matter which form in the database as long as it is the first one) display just a value on most field (i am noticing those fields with text datatype), and i am noticing that the number shown is the same as the autonumber i have for that record. Eventually, closing and re-openining the form will fix the problem. this is happening with all of my access databases, some of which i have been using for ages.
Actually, i have tried running the detect and repair tool from the microsoft access help menu to no avail. I have even tried importing the database objects to a new database but still to no avail. Finally i also tried uninstalling and re-installing microsoft office, and the problem is still persisting.
Any idea what might be going on, and hopefully a resolution to sort out this nightmare?
Thank you very much all for your attention.
View 7 Replies
View Related
Jul 22, 2006
Hi,
I've asked this on a few other websites with limited or no success.
this is from one db. this table originally had about 20-30 different fields,
WarehouseNum ItemNum load_date Shipped
101 31 6/26/2006 200
101 31 6/27/2006 180
101 338 6/26/2006 162
101 338 6/27/2006 357
this table is from another db. Notice how WarehouseNum is '9' instead of '1' and itemNum is '000'. This is just one of many impediments I face. As well, none of the table fields are the same, I changed them here to make it easier to work with.
SupplierNum ItemNum WarehouseNum PlannedDelDate DeliveredQty
869747 00031 901 6/26/2006 250
869747 00031 901 6/27/2006 300
869747 00338 901 6/26/2006 490
869747 00338 901 6/27/2006 490
The goal here is to query the two simultaneously, perhaps with linked tables, type in an ItemNum using a parameter and know for instance that on the 26th, we received 250 item31 and shipped 200 for a remaining balance of 50. The 50 is what I'm after. Basically, my company uses one program for sales and another for purchasing and absolutely nothing for inventory management. I started with this company about 3 weeks ago and unless i can implement some kind of temporary solution, it will drive me insane.
Advice? Best approach? As well, this db will use data on two different servers
Thanks for the help.
As well, my access experience is limited and our company I.T. is seriously backlogged, besides which, I would like to learn how to do this myself.
Thanks again
View 1 Replies
View Related
Mar 25, 2006
Erm Hi everyone I'm new.
Sorry about the rather striking title, but I have an assignment with the deadline tomorrow and I need to find out how to perform numeric calculations in access with different fields (i.e. adding numbers, minusing etc.)
Well, I had to make a project at school for my GNVQ ICT, I chose the advanced sales database, since its a project we have to add in our own features and find out about them ourselves. Well I thought I'd create one for my company inside school, I wanted to create a database that would print invoices and monitor all the resources we have. The project has to be in on monday!
However all was going well until I came upon a slight problem, I'm not sure how to do calculations in Microsoft Access!
Well basically this is what I'm aiming at, its nothing too complicated really.
I have a table called RESOURCES which keeps track of all of the stock the company has (e.g. how much paper, how many mugs, tshirts etc.). I want the database to be able to automatically take 1 away from the selected resource when a form is used to file a new order.
E.g.
I have a form asking me the details of the design, In the resources table I have set the quantity of mugs as 100, i.e. I have 100 mugs in stock and available.
I use the form and tell the database that I am making a design which will use 1 mug.
The database then goes to the resource table and takes 1 away from the available stock of mugs making the total mugs available 99.
I then the database to be able to do this automatically, when a checkbox is ticked, when the form is submitted I want it to see which text boxes are ticked and take the correct consequent resources from the RESOURCE table.
I have Access 2003, I have attached the file incase anyone needs it, note that the Forms have NOT been made only the resource, customers and orders tables have been created.
If someone could tell me how to do this I'd be extremely greatful, this is very URGENT I have to hand in the project on Monday!!!
I know I'm asking alot but I'd be really really greatful if someone could help me out!!!
View 4 Replies
View Related
Aug 6, 2007
Hi
Please answer ASAP, this would be urgent!
I have two tables that need to be updated in tandem from a single access-page, by entering previously non-existent data.
One contains a contractor ID, and the name of the contractor; The other contains details of contracts, with the name of the Contractor selected from a drop-down box that draws its contents from the other table.
I have a data access page with an always visible drop-down box that shows contractors, and if I select one, it displays all contracts entered. This unfortunately means I cannot easily add new contractors, since they have no pre-existing contracts to display the details, and allow entering, and I cannot make the details fields permanently available.
Right now, I can add new contracts to those contractors who have at least one in the system already, but I'm unable to add new contractors. My aim is to have a single page add the contract data, and new contractors. Having a hyperlink open a new page that allows the adding of new contractors is also acceptable, but no coding, please, cause I suck at that...:(
Thanks in advance for your help!
View 2 Replies
View Related
Dec 9, 2005
hi to all,
I have a software which links itself to a fox pro database/tables. Now i want to link some of these free tables or database from fox pro to access. Whenever there is a slight change in the fox pro tables/databases they must reflect directly into access database. Is this possible and how?
thanks,
ashley
View 3 Replies
View Related
Nov 7, 2005
Please help...
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xcac Thread 0xcc0 DBC 0x1090064 Jet'.
The code: example.asp
Code:<%fp_sQry="SELECT count(*) FROM TEVPDATA where ((datediff('d', '" & date() & "', DT3PROF1) between 0 and 30)) and (COL2 = 'PROF1/SLM')"fp_sDefault=""fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records returned.</td></tr>"fp_sDataConn="Fabos"fp_iMaxRecords=0fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Truefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_iDisplayCols=1fp_fCustomQuery=TrueBOTID=1fp_iRegion=BOTID%>
Global.asa:
Code:'--Project Data ConnectionApplication("Fabos_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=data/Fabos.mdb"FrontPage_UrlVars(4) = "Fabos_ConnectionString"Application("Fabos_ConnectionTimeout") = 15Application("Fabos_CommandTimeout") = 30Application("Fabos_CursorLocation") = 3Application("Fabos_RuntimeUserName") = ""Application("Fabos_RuntimePassword") = ""
View 1 Replies
View Related
Mar 30, 2006
i'm doing my final year project and i have restricted the toolbar in access. I need it back as i need to make changes to the forms and switichboards, but i can not access them. Does anyone know how to get it back???????????
Please .......
Pamela
View 1 Replies
View Related
Feb 21, 2007
Access 2003
I've inherited an Access Application which has
(1) a number of linked tables that are used to seed the underlying SQL Server database.
This system has been set up and is working in Development. My task is to move it to UAT but with regards to point (1) above I can't see any alternative but to copy the Access Database, create a new System DSN and re-import the External Data from the new DSN. What I'd like to do is use the same Access Database to point towards DEV or UAT or PRD. Is this possible to do this or am I stuck with maintaining 3 different Access Databases ?
I am a developer with many years of experience but my Access knowledge is limited so any pointers would be helpful.
View 5 Replies
View Related
Feb 22, 2008
I'm having a problem on a workstation that I've always used to create databases in Access. When I open any of my saved .mdb's I get a the error "end query expression" with the table name. The message gives me the option to click OK or Help and Help refers to "<Message> in query expression <expression>. (Error 3075)".
I've copied the .mdb's to another PC with Access installed and they open with no problem and I've removed and reinstalled Access on the problematic PC but still the same problem.
Also, I have a UPS Worldship shipping application that uses an Access database and when it opens it gives me a Micrsoft Visual C++ runtime error then closes, which may or may not be related.
I get the sense that something is corrupted in either Access or Windows XP but I'm not sure where else to look.
Any ideas?
Thanks,
Stuart
View 2 Replies
View Related
Aug 26, 2004
I want to publish my access database on my local pc and was thinking of using something like Dreamweaver to do this. Is this possible? I don't want to put this on the webserver but on my local machine (only a few people will be connecting), and I've read something about a Personal Web Server so this could be done. Does anyone have any ideas / thoughts on the best way to do this? Oh, I want the database / web to be "live" so the tables get updated as they are changed over the web.
View 3 Replies
View Related
Jul 31, 2014
I have an access db as the backend with the tables. Then multiple front end access dbs that link to the tables (as external sources). The front end dbs are setup with different forms on a per user basis, depending on their role. From my user db I want to be able to request information from another user. I want something in their db to pop-up and request the information.
I was thinking about approaching it using the datamacros. I thought maybe each front end db could have a messages table that the main db and other front ends link to. Then whenever they add data to your specific table it would respond and ask the user for the information. The info would then populate back into the message table where it could be retrieved by the requester.
Example: User A opens A.accdb and has a table called A_tbl. User B opens B.accdb and has a link to A.accdb.A_tbl. User B adds a record to A.accdb.A_tbl with Field1 = "what is your name". User A receives a pop-up with the info from Field1 and responds in a textbox for Field2. User B can then look at A.accdb.A_tbl and see the response as Field2.
Another option I thought of was simply trying to get one db to run a form/macro on another db remotely.
Example: User A opens A.accdb and User B opens B.accdb. User A clicks a button on one of his forms and it opens B.accdb.FORM in the session of User B. User B fills out the form and submits. User A retrieves data from shared tables as normal.
View 2 Replies
View Related
Sep 27, 2012
I have to coordinate a dbase in the US, one in the UK, and one in the KSA. I have multiple documents that may, or may not, be in each of the three dbases. I need to merge all three, and maintain them so that the document additions, as well as any changes associated with that document, (i.e. "revisions"), are updated. Having looked at access and having read through some of the Access forum questions, I understand that it can do that, but after having identified the information from the dbases that will go into access, I'm trying to establish a consistant process for maintaining and updating it. Can I export my information from each of the dbases, into an excel spreasheet, (1 for US, 1 for UK, and 1 for SA), and have the access dbase search for the document number, compare the data following the document number, and if it's the same ignore it, and if it's different, update it?
I'm trying to muddle through this and get access and excel to do as much of this as possible, as it's a very tedious and time consuming process to manually check each one, one or two times a week.
View 8 Replies
View Related
