473,473 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

working with ASP and Access database

I have a current site that I'm working on that has multiple HTML forms that
writes the information to an Access database using ASP. I've recieved input
that Access can encounter data corruption when there are multiple reads and
writes to the database tables. So, I was interested in getting any feedback
on using multiple .mdb files with only one table in the database for the
different HTML forms. Would this be a better approach to prevent data
corruption or would it make no difference?? The site is only a local
business that wouldn't be getting high volume traffic and my thought was to
seperate the forms to seperate .mdb files, if this would be beneficial?? I
have been told to use a SQL server database, which I'm starting to get my
feet wet with. In the meantime, Access is what I'm using and want to find
the best method to prevent data corruption. Any feedback is appreciated.
Thanks in advance.
-D-
Jul 19 '05 #1
2 2472
TJS
One database is more than sufficient, if you are concerned about data
errors, use transactions
"Dwayne Epps" <dw**************@centurytel.net> wrote in message
news:Wc********************@feed2.centurytel.net.. .
I have a current site that I'm working on that has multiple HTML forms that writes the information to an Access database using ASP. I've recieved input that Access can encounter data corruption when there are multiple reads and writes to the database tables. So, I was interested in getting any feedback on using multiple .mdb files with only one table in the database for the
different HTML forms. Would this be a better approach to prevent data
corruption or would it make no difference?? The site is only a local
business that wouldn't be getting high volume traffic and my thought was to seperate the forms to seperate .mdb files, if this would be beneficial?? I have been told to use a SQL server database, which I'm starting to get my
feet wet with. In the meantime, Access is what I'm using and want to find
the best method to prevent data corruption. Any feedback is appreciated.
Thanks in advance.
-D-

Jul 19 '05 #2
Response.Buffer = True

And that is the default anyways with ASP 3.0.

For high traffic though perhaps consider MySQL (basically free).

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: rob | last post by:
Hi to all. I am pretty new to using Access and am having a problem I hope someone can help me with. I want to access a MS-Access database from a web page. I have managed to get it "sort" of...
7
by: carl.manaster | last post by:
I'm new to this game. I can find my way around C# without any trouble, and I've used Access, a little bit, in the past. Now a friend wants an application of mine to read from his Access database....
3
by: Russell Read [MSFT] | last post by:
Hi all, I am using VB script in ASP to access a MS Access database. This works fine until I want to access the same db placed on a file share. The code I am using is... 'create connection...
3
by: MW de Jager | last post by:
I'm having endless problems with gaining access to an Access Database that sits on a different server. My ASP.NET app cannot gain control. The errror message I get is: The Microsoft Jet...
7
by: Larry B via DotNetMonster.com | last post by:
Hello, I seem to be having a problem with inserting data, from a web form, into an access database. I have tried to do the same thing in a regular windows app, there it works fine, but when I...
18
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...
0
by: Nymus | last post by:
I would like to use an access database as a shared database on a remote website. I don't know if it is possible, but this is what i would like to do with this database: - Use it to run a database...
0
by: asad56 | last post by:
I am workin with a superstore managment project. I connect Access database with main form . Then it work properly. But now I connect same database with another table or field in another form which is...
0
by: Chuck.Dieterle | last post by:
I have a very frustrating problem. I have a situation that works fine on some computers, but not on others. I have SQL Server Express 2005 and Access 2003 loaded on 4 computers. I have set up a...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.