Website .mdb Locking Up

Nov 18, 2004

I 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

View Replies


ADVERTISEMENT

Synchronising A LAN BE With A Website DB

Feb 10, 2006

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

View 4 Replies View Related

Website Parsing

Mar 25, 2008

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 Related

Database Driven Website

May 15, 2007

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

View 6 Replies View Related

Getting A Database Ready For A Website

Jul 14, 2007

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

View 1 Replies View Related

Database Help Needed For Website

Mar 6, 2005

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

What Feilds Should Be Editable From Website?

May 10, 2005

Hi every body. I have an access database that u can see the tables and their reletionship in the link i posted.
I would like to web enable this db and would like to get some suggetion on what fields should i allow to be edited and what records should i put delete option for? In order to keep the refrential integerity of the acces db.i be happy to get some feed back from u guys.Thanks

http://i5.photobucket.com/albums/y180/method007/dbreletionship.jpg

View 2 Replies View Related

Linking Local DB To Website DB

Oct 25, 2005

Hello,

I've searched the web for almost 2 days...and i'm completely lost:

I've got a simple online DB which stores information from a webform (e.g. name, adress, order, etc). Let's say it's called: www.mywebsite.com/onlineDB.mdb

Is it possible to link the online DB to my local DB (e.g. c:localDB.mdb), without downloading it manually?

Or do I have to put the webform information in a MySQL DB and link that one to my online DB?

TIA,
Leon

View 1 Replies View Related

General :: Sending PDF To A Website

May 5, 2013

I have a DB that runs on a user's pc. It creates a pdf from a report automatically at a specific time of day. The user now wants me to automatically send this pdf to his web site so that his customers can view the report over the internet. The pc that the db runs on has an internet connection but no email system (they do not want email on this pc).

I have not been able to find code to do this. I can find code for sending email but this is not what I want to do. I'm sure it must be possible but I've never done anything like this before.

View 5 Replies View Related

Database For Blog Hosting Website

Mar 31, 2006

Hi,

I need to design a database for a blog hosting website but I have no idea about how to do this. please please please could someone help?

katy_deacon

View 1 Replies View Related

Publish Products From Access On Website

May 28, 2006

I 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 Related

Link To Website (MS Access Database)

Sep 16, 2005

Hi,
How I can link to website MS Access database?
File->Link Tables doesn't understand http or ftp.
Provider doesn't support MS Access.
Thanks for your advice.

View 2 Replies View Related

Update MS Access Datbase From An Website

Oct 2, 2007

Hi,

im new this forum and this is my first post, ive tried searching but if anyone could direct me in the right direction that will be great,

bassically i have created a basic Ms access databse for a hotel reservation system, with queries, reports etc. The database works fine.

I need to create an website which will connect to the database so that i can enter,view, query records from the website.

I have very little or no programming knowledge so whats the best solution. I was going to make the website in either dreamveaver or frontpage but ive read that these static websites cant connect to an database.

im sorry if this question problably has been asked a million times before but i need some advise as im a beginer.

any help much appreciated.

Thanks

View 13 Replies View Related

Modules & VBA :: Import Data From Website

Aug 23, 2014

I want to import data from a webpage using VBA and then store the HTML contents in a table (well, actually just part of the contents in fact).

View 7 Replies View Related

General :: Open Certain Website After Checkbox Is Checked?

Jul 17, 2013

is there any way to open a certain website after checkbox is checked?

View 1 Replies View Related

General :: Website To Get Data From MS Access Database?

Jan 10, 2013

Is it possible for a website to pull data from an Access database?

We have all our department's policies in a MS Access database on our server. Some of these policies need to be made available to the public on our website. I'm wondering if there's a way for the website to pull directly from the database rather than having to manually upload the policies to the site every time they change (annually, semi-annually).

View 1 Replies View Related

Forms :: Access Website And Type In Search Bar

Feb 3, 2014

I am trying to get a button on my form to open two reports, and also go to a website. Once at the website I want it to type in a search bar based off of the criteria of the two reports. I currently have it able to open both reports correctly, and I can get the website to open, but I am not able to find a way to get access to type anything once on the website.

I am opening the website using:

Application.FollowHyperlink _
"enterwebsite"

View 4 Replies View Related

Publish ODBC Query Results From LAN To Website

Feb 2, 2012

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 1 Replies View Related

How To Open A Website URL In Pop Up Mode From A Form In Access

May 4, 2015

I am writing a program that allows users to enter customer info and I want to be able to pop up a window that will search for Postal (Zip) codes using the Postal Service URL. (I would like to position the popup so that the contents of the Address and Postal Code fields are still visible on the form). I would also like to know if there is a way to copy the contents of the Address Field in my program to the Windows Clipboard, using VBA code, so that I can paste it into the Postal Code Finder without highlighting the field contents and pressing Ctrl-C.

View 2 Replies View Related

Modules & VBA :: Using Access To Check Whether A Specific File Exists On A Website?

Aug 19, 2013

Actually what I am looking to do is have an Access application check some Web site for the presence of a number. This number could be the Serial number of the application and if this number exists to maybe show a message in the aplication or even terminate the application.

A quick and dirty way is for User Serial number 254, to put on a specific page of a Web site say arbitrary file 254.jpg (invisible on the Web site). The application would check for the existence of this file and if it is there, it could take some action. Everything would have to be done in stealth mode.

The following code can tell me if a specific URL exists, in this case [URL]

Code:

Private Sub cmdArbitray_Click()
Dim blnDum As Boolean
blnDum = blnCheckURL("http://www.VisualDentist.com")
' If blnDum = True then it exists
End Sub
Public Function blnCheckURL(ByVal strURL As String) As Boolean
Const FLAG_ICC_FORCE_CONNECTION As Long = &H1
blnCheckURL = (InternetCheckConnection(strURL, FLAG_ICC_FORCE_CONNECTION, 0&) <> 0&)
End Function

1) How can I check for file 254.jpg?

View 1 Replies View Related

Modules & VBA :: Click Button On Form In Database And Login To Website?

Jul 11, 2014

I'm new to Access and I'm using Access 2010.

I would like to be able to click a button on a form in my data base and login to a website using my username and password.

The manual login, requires two clicks after username and password, "Login" and "Click to continue"

I have tried many solutions found on the internet, none work for me. One forum reply was to send me a link to another site and it was for Excel. Is the code the same? Didn't work anyway.

From the website I want to login to, I have copied the code into a Word doc from the "inspect element" to work out the names of the fields I'm trying to put my username and password into. (see attached)

I would also like to be able to use Google Chrome as my web browser if possible?

View 8 Replies View Related

General :: Input Data Into Website Based On Selected Record

May 19, 2014

Is it possible, to input information from my continuous form into a web control form. at my job we a required to tract our jobs by equipmentid and job control number(jcn). When a job is done we have to upload the id and jcn into a website to tell it is cleared. I am looking for a way for that info to automatically be filled in when i load the website based on the job i have selected in my form?

View 1 Replies View Related

Modules & VBA :: Web Browser Control To Navigate A Website That Only Allows One Session At A Time

Oct 16, 2013

I have constructed an application in Access2010 that uses the ActiveX WebBrowser Control.I am using the Web Browser control to navigate a website that only allows one session at a time and normally (if using a regular web browser) if you close the tab you're working on, you have to completely close the browser and reopen it to be able to acces the website again.

I have this application on 2 networks.

On PC

A) when using the WebBrowser control I can navigate to the site. But if I need to navigate away or need to log in as a different account on the site, I can close an reopen the form and that will suffice to regain access to the site.

However on PC

B) it will not allow me to navigate back to the site by closing and reopening the form (the website recognises it is not a new session). I have to close the entire database and reopen it to get the site to work again.

I would very much like PC B) to be behaving in the same manner as PC A) so that I do not have to tell users to restart the whole database in order to reaccess the site.

View 1 Replies View Related

General :: Connecting Access Database To Website To Import Data Automatically

Jun 30, 2015

I just created a database and need to connect it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up message to save a csv file which contains all the data. The extension of the http website ends with csv. So it is something like http (slash slash...) Intranetname/referral_dbase.csv

Currently, I am opening the file using firefox, copying all the data manually, and pasting it in a text file using notepad. After that, I import the file into access. The delimiter of the data is this symbol: |

I am trying to find a way to link my database to the website where the data is located so that I can skip the manual process of opening the website and copying the data and saving it into a text file and then importing that file into access. I was thinking to have like a form in access with a bottom that will automatically import that data from this link and paste it into a table in access using the delimiter symbol mentioned above.

Is this too complicated? Is it even possible in access 2010?

View 1 Replies View Related

Locking A Database

May 8, 2005

I have a company wanting to asses my database and i am willing to show them but i need to be able to lock the database so that they can view it but cannot edit anything in it either adding deleting or plan editing. How can i do this.

Bullfrog
The Amateur

View 4 Replies View Related

Split DB, Keeps Locking Up

May 24, 2005

Hi, I just recently split my Access db (FE/BE), copied the FE to each of the clients, and it seemed to be working fine. This morning however, two users went into the db, and the second user kept getting the error can't find the file \servernameshare_namedb_fe.mdb. Now, none of my users can launch it. How can I resolve this? Will this keep happening?

AP

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved