Member Avatar for suasi2007

am working on my project and the requirements are that i develop a web site and have it connected to an access database. the site is ready and the database the problem is how do i connect to the database.could someone help please.

  • 2 Contributors
  • 3 Replies
  • 103 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Lusiphur

Dani AI

Generated

For — building on ’s prompt about server-side code, here is a focused, practical workflow you can apply right away (using PHP because it’s commonly available and matches the thread tag). It covers setup, a minimal insertion example, and the usual gotchas you’ll hit with a file‑based Access database.

  1. Environment/setup
  • Create a System DSN (ODBC) that points to the .mdb/.accdb using the Windows ODBC Data Source Administrator. On 64-bit Windows, remember the 32‑bit ODBC tool lives at C:\Windows\SysWOW64\odbcad32.exe (PHP builds are often 32‑bit).
  • Put the Access file outside the web root (e.g., C:\inetpub\App_Data\booking.accdb) so it cannot be downloaded directly.
  • Give the web server process user (IIS AppPool identity or the Apache/Service account) Modify permissions on the folder so the engine can create the lock file.
  1. PHP basics and a minimal safe insert
  • Enable the ODBC extension (or PDO_ODBC) in php.ini, restart the server, and use parameterized queries rather than string concatenation.
  • Example using a System DSN named BookingDSN:
<?php
$conn = odbc_connect('BookingDSN', '', '');
if (!$conn) { die('DB connect: ' . odbc_errormsg()); }

$name  = trim($_POST['name'] ?? '');
$email = trim($_POST['email'] ?? '');
if ($name === '') { die('Name required'); }

$sql = "INSERT INTO bookings (customer_name, customer_email) VALUES (?, ?)";
$stmt = odbc_prepare($conn, $sql);
if (!odbc_execute($stmt, array($name, $email))) {
    die('Insert failed: ' . odbc_errormsg($conn));
}
odbc_close($conn);
?>
  1. Troubleshooting & cautions
  • “Could not find driver”: check 32/64-bit ODBC vs PHP build.
  • Permission errors or “file in use”: verify folder write permission and that the engine can create the .ldb/.laccdb lock file.
  • Access is fine for small class projects, but it does not scale well; plan to migrate to MySQL/SQL Server for anything with concurrent users.
  • Always validate and sanitize input, keep the DB out of web root, and keep regular backups.

This should get the booking form saving reliably. If a specific error appears, include the exact message and server (IIS/Apache, Windows version) for targeted help.

Recommended Answers

All 3 Replies

Member Avatar for Lusiphur

Perhaps if you gave a bit more detail...

Such as, why are you connecting to the database? Are there dynamically loaded objects in your site that require DB access? Are you sending information to the database from inputs on your site?

Do you have any knowledge of ASP.Net or VB or any other web-compatible programming/scripting languages for that matter? Is the database local to the site or on a server somewhere?

All of this information would be handy for someone to be able to better evaluate the question you are asking and to allow people to provide the correct type of help to fit your needs.

Member Avatar for suasi2007

Thanks Lusiphur:
the site is a online booking, thus it requires customers to type their info on a form then submit. which should be updated on the database.
I have actually done other projects in VB 6. ASP am not well conversant with it. i have also used javascript in the past.
the data base is local to the site(its a class assignment)

Member Avatar for Lusiphur

Excellent, at least that gives people a place to start.

So ideally what you'd be looking for in this case would be a method using VB (read: ASP.Net as that can be either VB or C#) or javascript or a combination of both which allows you to connect to an Access database and inserts/updates information based on user input on the site's form.

Me, I'm a C# person, not very strong in VB but...

might help put you in the right direction, as might this reference.

Hope these help :) Please remember to mark as solved once your issue has been resolved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.