Publishing Your Results Online
Dec 18, 2005
Hello. This is my first post so be kind!
Im currently working on a project which involves taking customers data via MS ACCESS and storing it in a database. Which has in iternet connection. I would like stored data to be available online.
Which would be the best way to go about this?
MYSQL?
Just a little confused.
Also had a quick browse round the forum and looks like i might be spending a lot of time here:D
View Replies
ADVERTISEMENT
Oct 5, 2006
I have googled and search for this subject and am more confused now...
I am running an offline A03 db with XP and have a hosted website. Right now I have a separate db online that is used for the results on the website, and it works correctly. I used frontpage to create the form.
Now with our offline db I would like to enter the information on a form, and have the results show up on our website, to avoid keying the same info multiple times.
The data that shows up on the website will not be edited, but the table offline will have some fields for edit, that will not show up online.
Is there a way to connect an offline table/query to show up as results online? And if so how or examples? Thanks in advance.
View 1 Replies
View Related
Sep 25, 2006
Hi folks,
I'm new to the business of publishing a database on the net... though I have some experience with HTML and XML, I have absolutely no knowledge of ASP at all. I wonder if anyone would be kind enough to walk me through the steps of getting my database up and operational on the web. Thank you in advance!
~Lana Faith Call
View 2 Replies
View Related
Mar 7, 2005
How do I Pubish a from from access into word using a word template i have created? and not just into a blank word document?
View 1 Replies
View Related
Oct 29, 2005
Hi,
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
View 1 Replies
View Related
Nov 1, 2006
Brain-death is a horrible thing to witness.
I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.
Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?
Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.
Please point me in the right direction.
Thanks - Bob
View 3 Replies
View Related
Feb 14, 2006
Maybe this shouldnt even be done in a form as simple of a task i need. I have a query of multiple tables andi want to be able to export it to word with only a few of the columns from the query as well as displayings yes/no instead of -1/0. Basically im just trying to make a table in word so i can have all the correct pages headers and such to make our document control people happy.
Is there a way to publish a form to a word document and get the header of each column to appear at the top of each page? I noticed that if i export the form to HTML then copy and paste the table in the html file to word its works but thats a huge pain in the you know what, and the table ends up looking a bit odd in word and no amount of table formatting seems to fix that but thats a different issue.
Thanks
View 3 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
Feb 1, 2013
I have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel etc.
I am little confused how to achieve this and what are my options? I assume I have to set by database somewhere on server and so my customer could access it any time? Do I have to upsize access database to SQL express or similar?
Also, one more important question: is it possible to "convert" access database into HTML code or similar so it could be accessed via web browser without need to install microsoft access and with freedom that it can be opened from any type of PC OS (Linux, Mac etc)?
View 14 Replies
View Related
Feb 4, 2013
My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.
I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.
View 7 Replies
View Related
Sep 24, 2003
Hi all,
It's my 1st posting! Need help on how to get Unbound OLE objects (i.e. lines, pics, et.) reflected when publishing my Access report into MS Word. So far, only the data are exported. Appreciate your help.
System Info: Intel Celeron 700MHz, W98SE, MS Access 2002
View 4 Replies
View Related
Dec 6, 2012
Having experimented with Access for a few months now; I know you can link an Access Database to SharePoint, and you can export Excel files into Access for inclusion in tables.
My question is; If I have a daily report being produced, through script, with an excel output. Is there anyway to automatically publish this in Access, negating the need to manually go into Access to import?
View 5 Replies
View Related
Apr 7, 2008
Have any of you ever used some really good online training? I really need to get good with ASP.NET, VB.NET, ADO.NET and SQL 2007 Server ect. I want to do some self pased online training, anyone used a really good service for this?
Thanks you!
View 1 Replies
View Related
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
Nov 10, 2005
Hey guys,
I was wondering if there are any online tutorials you know of on the subjects of table relationships and normalisation?
Any help would be great
Thanks,
The Yetiboy
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
Jan 27, 2006
I have 5 computers in my office. What I want is after networking these computers, I want that the Office note and other work done by one employee should go to another with some pasword and it should also have a log details.
View 3 Replies
View Related
Jun 12, 2006
I read a lot of threads and some KB articles before this, but am still confused.
Can a copy of the BE database be made on the Server while users are logged on ? Max No. of users is 7.
Does copying a BE while work is going on lead to corruption in the database.
Right now i make a copy of the database thru code and then compress the copy for a backup.
View 2 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
May 25, 2005
I currently have a database on my hd and four other ppl have a copy on theirs. (We are in different physical locations which makes it very slow to put the database on our server).
Currently eveyrone is sending me files that i upload to my copy of the database so i have all of their data.
the obvious setbacks to this is that the data is not live and some of the changes might be missed etc.
i would like to move this and house the tables on my company's intranet
what would i need to do to accomplish this?
View 1 Replies
View Related
Feb 13, 2007
I would like to put my database that I have created online so I can update it from anywhere, and was wondering what are my options - does access have a feature to do this? Or will it involve using dynamic coding to update the tables? I would like to use the forms that I have already created etc ... but is this possible?
I have my own server if this helps?!
thanks
d
View 3 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
Oct 10, 2007
Hi
I have lost a link for a great website that had online video tutorials in Access. It was pitbull or bulldog or something like that (tried all the combinations in google)
Jog anybody’s memory for a url
cheers
View 3 Replies
View Related
Oct 23, 2007
I found a web site that reports 2007 bugs that says this:
Do not use offline folders to store your databases.
Actually, the full thing says:
Update Sep 14, 2007: There is now a known issue where a database stored in offline folders is lost when compacted. There is also another bug where you lose the objects from the Navigation Pane when you delete an object, if the database is stored in an offline folder. Do not use offline folders to store your databases.
What does this mean? I shoudn't have my database on a server? I should have it on the web? Eh?
Erin
View 3 Replies
View Related
Jun 4, 2005
I am new to Access and not a sophisticated user of computers. I've been given the task of redesigning some forms on an existing data base. I understand how to put the new fields I'm adding into the table associated with the forms I'm working on, but I've having a hard time actually moving stuff around the screen and getting it lined up.
Is there an online tutorial or reference I can go to that will teach me the layout basics?
View 1 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