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!
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
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?
Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:
Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?
Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?
Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.
So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.
I'm not very technical with access (not yet) so things might be done differently than I do to speed up things
Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.
So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.
My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.
Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:
Database Design Tables Queries Forms Reports Macros Modules Other Issues
I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.
Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:
So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.
Any recommendation is welcome.
I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.
There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.
I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.
I know that the user will be looking at a web front end which in turn will be accessing the Access Database.
I'm trying to design a system for an electronics shop. I have two tables, one called Products and another called Suppliers. The Products table has the following fields- - 1) Product ID 2) Supplier ID 3) ProductName 4) Information 5) Price
The Suppliers table has the following fields- - 1) Supplier ID 2) Company 3) Address 1 4) Address 2 5) Address 3 6) Town 7) County 8) Post Code 9) Country 10) PhoneNumber 11) FaxNumber
Basically I want to create a form to show the supplier name and ID and then implement a sub- forum which shows all the product details for that supplier. How do I do this? Do I have to use a query? Thanks
Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes. Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL. Has anyone got some recommendations ?????
Did you know that you can use Google to search the Access Forum and get a more refined result?
I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.
To get this sophistication do this:
Open Googles advanced page: (http://www.google.co.uk/advanced_search?hl=en)
The first section of this page is shaded blue, and contains the following items:
with all of the words with the exact phrase with at least one of the words without the words
You can add words to varying degrees of sophistication for your search.
This is the important bit! Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:
http://www.access-programmers.co.uk/forums
Now give it a try! Try searching for: "Date Selection" (without the Quotes)
If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.
Caveats: Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.
Hi, I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access. Any answers can help me. You could send me a link to a webpage that tells me how to do this stuff. Any Tips?:)
hey all, i'm making a database to catalogue a whole bunchs of projects of mine. i have a few questions but i'll ask one for now. i have made a form with a check box and i want it so that once that check box is clicked, another element appears or becomes un-grayed or something. basically if the check box is checked then i have to specify a file location for the file that i'm confirming exists. (if that makes sense)
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.