I have an access database with ODBC linked tables with a query. This ODBC connection is only available on my LAN because it uses specific ODBC engine.How can I publish the output of this query to a hosting space that my developer can query for a website project?The data needs to be published once a day.
View RepliesI would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures.Within my access database i have a link to the product picture stored by filename. I'm looking for an easy solution to do this, i'm using mysql as database on my hosting provider.I can do the export to mysql myself (interfacing between access and mysql) but am looking for some hot software to display the catalog easily without programming the front website myself. I already have oscommerce installed but don't want a webshop and don't know how to disactivate all the features within oscommerce to only retain the article browsing.Thanks if you have a hint
View 3 Replies View RelatedHi!
I need help!!!
I have made a books-database in MS access. I want to publish it on my web site. It should be possible for the visitor that search different books on my database.
I am able to write HTML code (using MS FrontPage) but how make a search form and how would the HTML contact my database (book.mdb) on my web-server?
I have find some HTML code.. for search-form but here it is used kbook.asp what I don’t understand it . I have tried to replace kbook.asp with book.mdb, but it does not working.
I have heard that there are some software that you can easily publish your database on your homesite but which software???
Kind regards, sofi
Code:<HTML dir=rtl><HEAD><TITLE>K</TITLE><META content="text/html; charset=windows-1256" http-equiv=Content-Type><LINK href="kformat.css" rel=STYLESHEET type=text/css><META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD><base target=kDown ><BODY bgColor=#EDF2EC text=#000000><FORM action=kbook.asp method=post name=SEARCH><TABLE align=center bgColor=BDCEB9 width=420><TBODY><TR><TD width=120>Choose</TD><TD width=220><SELECT name=Kids><OPTION selected value=DIV>Kids<OPTION value=CHD>History</OPTION><OPTION value=CIN>Animales</OPTION></SELECT> </TD><TD align=right width=80><INPUT type=submit value=Show></TD></TR></TBODY></TABLE></FORM></BODY></HTML>
Access to Web. Is it possible to publish access to web without SharePoint?
View 4 Replies View RelatedSir,
In MS Access there is a separate option to create "data access pages". Can we publish these pages on web.. Please help me
From
somashekhar
I have a Access - front end / SQL Server - back end application. I use an ODBC connection. I want to publish this on share point. The users have a windows account but they are not on the network. I can not create an ODBC connection for them. There is any way they can use this application?
Can I connect in different way to SQL?
Any help will be appreciaied. Thanks,
Mary
Currently, I have a button on my form that users can click on to generate a report based on the info from the form. Once the report has opened, they publish the form with MS Word for further edit if needed.
How do I set up the button so that it opens the report then automatically publishes the report with MS Word?
I produce a report from a query. One of the fields combines in a calculated field based on numerous other fields, a sentence that may be up to five printed lines of text. While it views correctly in the Report's Preview screen, it is less than perfect when I send it to a Word 2002 document using the Office Links/Publish with Word tool. Despite producing the same font face and size and having the same left/right margins, it truncates unpredictably and inserts a hard-return. It will take a five-row report field and produce a five-row Rich Text Format field...but often with a few lost words at the end of the final row. Some rows have an inch of unused space at the end of them in the RTF file...wasted space.
Any suggestions as to cause?
I got an access database but how do i make it to be able to publish to web and allow phone browser to access and enter data as well?
View 1 Replies View RelatedI have created a report in MS Access. When I choose the option to Publish to MS Word, I loose all of the background colors. Is this correct or am I doing something wrong? Is there a way to maintain all of the Format features when I publish?
View 1 Replies View RelatedHello, I have a question about querying some tables that i have linked through ODBC. I searched through the forum, but was unable to locate anything that helped me, please excuse me if i missed something.
I am trying to create an Access front end for user to query our AS400 through ODBC. I have a form setup for users to select a date range with my query pointing to the two text boxes on the form. This part works ok.
I would also like them to be able to pull specific codes, so i did the same as with the dates, and put a text box on my form and pointed the query to the text box. When running anything in this way, the query returns zero records.
For example, if I put any of the following in the query criteria, it will work and return records:
"MI"
Like "MI"
Like [Enter Code Here] (I then type MI when prompted)
however, if i put this in, it will return zero records.
Like [forms]![form1]![text33]
Yes, all the field names and form names are correct, i am keeping it simple for testing right now.
And even stranger, if I leave the LIKE off the above criteria, i get an ODBC error that says "ODBC -- Field would be to long; Data Truncated"
I in Text33 on my form, i have tried both "MI" and MI (without quotes), but they both return zero records.
Any idea what could be going wrong here?
Thanks in advance,
Hello all,
Need some help with someone who knows what they are doing (not me).
I have created a statistical analysis db in Access. Unfortunately the raw data I need is on the server in a different system. I understand I can run a pass through query to get that info and put it in my tables but.....
This apparantley requires connecting to the foreign database using ODBC something or other. I have the string, I just don't know how to write the code in VBA to do it so I can run my queries. What kind of code do I have to include using VBA to connect to the foreign database so I can run my pass through queries?
ODBC Connection String (I think thats what i need, right?) is below......
ODBC;DSN=spillman;HOST=10.0.40.20;UID=wjarre;PWD=* *****;
DATABASE=spillman;SERVICE=sqlnw
How do I write/add this in to my code?
confused
I am trying to publish an Excel Pivot Chart, but keep getting Run Time Error 1004 - Application-defined or object-defined error...
I have tried the code 2 ways:
Code:
Sub PublishChart() Worksheets("Historical_Pivot").Activate
With ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", _
"Historical_Pivot", "JAMALCO", xlHtmlStatic, "ABC REQ BACKLOG_2013", "")
.Publish (True)
.AutoRepublish = False
End With
End Sub
Code:
Sub PublishChart()
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ThisWorkbookSet ws = wb.Sheets("Historical_Pivot")
ws.ChartObjects("JAMALCO").Activate
With wb.PublishObjects.Add(xlSourceChart, Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", ws _
, "", xlHtmlStatic, "", "")
.Publish (True)
End With
End Sub
Trying to make this code work, don't know how to filter as it prints identical all reports.
Private Sub cmdExportPDF_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyPath As String
MyPath = "C:Reports"
If Len(Dir(MyPath, vbDirectory)) < 1 Then
MkDir (MyPath)
[code]....
How to publish an Access db with Windows IIS but without Sharepoint
View 1 Replies View RelatedI have a query that I want use as a pass-through query (SQL Server databases).
The query has a sub-query that references another database. The query runs fine in Enterprise Manager because EM allows me to access both databases.
If I wanted to I could link both tables through ODBC and then run an Access query that would do the same, however, I would rather use a pass-through-query for this.
The problem is that a pass-through-query in MS Access only allows me ONE ODBC connection (as far as i can tell).
My question is:
Is there a way I can run a sub-query (referencing a different database. i.e. second ODBC connection) which references a second database?
Is this possible?
Thanks
-Gary
I made multiple pass through queries that receive their data via an ODBC link which is established. Currently the username and password is entered seperately in every query but I was wondering if it is possible (and how) to make both look for the values in a table (OR somewhere else if possible) for these values. The following code (with edited information) is used in all queries.
Code:
ODBC;DSN=DSNNAME;Driver=Firebird/InterBase(r) driver;Dbname=Database.FDB;CHARSET=NONE;PWD=Password;UID=User;
The reason that I would like to do this is to ensure that the user can change it easily.
Hi,
The situation is that we have a split DB on a LAN using Windows Server. The BE is on the server and the FE are distributed to each user PC on the LAN. (For historical reasons there are differing versions of Access at each user which was the primary motivation to split the DB)
We also have a copy of the DB on the company website which is to be updated via FTP on a regular basis. This is used for queries only by visitors. We now want our clients to be able to update their information on line in tandem with our local users.
The question is - what is the best method to keep these DBs synchronised?
My thought is to use replication with the LAN BE as the master DB and the website having a replicated version. Then we can periodically download the website version and synchronise the two - presumably we would have to disable the updating function on the website while we do this and then reload the new replicated version up to the website.
A problem I see already is that the website DB is not split where the local version is - is it possible to rejoin a split database? Synchronise it, upload a a replica and then split the BE and FE again?
All Ideas / Suggestions welcome
Tony Randell
I need some assistance parsing some information from a web address. Here is an example of what the web address is.-http://www.websitename.com/ct20/pages2/client_bcphone_service_order.aspx?client_id=160399 4&contract_document_id=924182&cipid=206123444-What I am trying to do is get the client ID and the contract id. The client id being 1603994 and the contract id being 924182. Any ideas would be appreciated.Gregg
View 5 Replies View RelatedI am having a problem with locking, and it is crashing our website.
I suspect it is a locking problem because everytime the database goes down, I ftp into the site and see the dreaded *.ldb file.
Access is suspose to support from 15 to 20 concurrent users, right? The log files show no more than two or three users accessing the database at the same time. By "same time" I mean within one second.
Below is the code which updates the database. Can anyone see anything wrong with this?
Also, if I wrote the information to a text file with the FileSystemObject instead to Access, would I solve the problem of locking?
BEGIN CODE -----------------
sub OpenDB(sConn)
'Opens the given connection and initializes the recordset
conn.open sConn
set rs.ActiveConnection = conn
rs.CursorType = adOpenStatic
end sub
OpenDB sConnStats
'Get ID's by Names
lIdOS = GetIdOS(sOS)
lIdColor = GetIdColor(sColor)
lIdBrowser = GetIdBrowser(sBrowser)
lIdPath = GetIdPath(sPath)
lIdRef = GetIdRef(sReferer)
lIdRes = GetIdRes(sResolution)
sSQL = "SELECT * FROM Stats"
rs.Open sSQL,,,adCmdTable
'Save the data
rs.AddNew
rs("OsID") = lIdOS
rs("ColorID") = lIdColor
rs("BrowserID") = lIdBrowser
rs("PathID") = lIdPath
rs("RefID") = lIdRef
rs("ResID") = lIdRes
rs("Date") = date
rs("Time") = time
rs("IP") = sIP
rs.Update
'Terminate database connection
CloseDB
I have a query that uses an odbc table.
The query prompt for a date: [Enter Date]
After entering the date, I get error: "ODBC Call Failed"
Yet...when I set the criteria to the date I want: #01/01/2005# I can retrieve the data, no problem.
Any idea why I get the ODBC Call Faile error when prompting for the date?
Thanks....
BJS :confused:
I have a problem with my query which works fine prior to upsizing to SQL Server. Now I have an Access Front-end with SQL Server (2005) back-end client/server setup. This problem has bugged me for over one full day and I can't find anything that seems to solve it.
The error that comes up is this:
Run-time error '3146':
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='. (#102)
The line that's producing the error is a DoCmd.RunSQL "SELECT tblPBC..." The full statement is below. I can't seem to see anything wrong w/ my syntax below....
Hi! I have a query setup that feeds off of three combo boxes on a form. It is setup to allow a user to search and calculate revenue for a selected time period by company, then department, then page. If all three or just company are selected, there are no issues running the data. However, if only company and department is selected I receive an 'ODBC--Call Failed' message. The issues seems to be stemming from the department field as I can link the department table to the main table and the query will run without error. The problem with that bandaid is that the query takes more than 15 minutes to run that way as opposed to about 2 minutes to pull more data at the company level.
Any suggestions on why this is happening or a fix that can be put in place? Any help is greatly appreciated.
I can provide more details if needed. Thanks!
Hi all,
I work for a construction company and am after a bit of advice.
We are looking in to designing a database system to manage one of our property maintenance contracts.
We want to be able to accesss and update the database using a website, so users can gain access via Laptops / Smartphones etc. For Example a plumber can log on to the site on his PDA using a username and password and view a list of jobs outstanding for him and update the status once completed.
We also want to have a section for clients where they can log on and view reports on the status of the project.
What is the best way to impliment this? I have been looking at Access 2007, SQL, Coldfusion, Sharepoint but still so confused.....:confused:
Any advice would be great.
Cheers
Craig
Hello! intermediate databaser here and its good to be here.
I own a bridal shop and i'm creating a website to sell my dresses. I know the first step is to have a database ready, since I have so many dresses. I have my tables done with one table holding customer attributes, including name, address, and other personal information, one holding dress attributes such as color, quantity, style, price etc., and other look up tables that has to do with the styles, colors, and quantity (up to 5). Here is where the problem comes in at:
I want to keep up with the orders placed such as the date ordered, what dress they ordered, who ordered it, price paid, shipping and handling (flat rate), etc. but I do not know how to link this up to run off the website. I would like to know what are the key fields I would need in order to place orders appropriately.
Do I need special type of tables since this will be going online?
Would this be the easiest way to go about doing such a thing?
If you could point me in the right way, or to a tutorial I would greatly appreciate it.
Forever Yours
here is a link to my website http://www.justevents.biz if there is anyone who would be kind enough to look at it and tell me how to build an access database for the categories and search by zip, etc. i would be greatly appreciative. I have tried all the tutorial helps and built about 15 different databases and can't get a single one of them searchable under any circumstances. I have tried all I know to do.
View 2 Replies View Related