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
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.
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!
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.
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.
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)?
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.
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
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?
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?
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?
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.
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.
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.
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
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
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 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
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.
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
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?
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?
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)