Gaming, Computer Tech & Electronics Fortnite.CounterStrike.CallOfDuty.Dota.MineCraft.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 |
11-26-2015, 10:05 AM
|
#1
|
|
RS Lurker, I don't post!
Join Date: Nov 2015
Posts: 1
Thanked 0 Times in 0 Posts
Failed 0 Times in 0 Posts
|
Cannot open access 2003 database
Sure this is a very common problem people have.
I'm using Access 2003 with front-end forms, 5 people log into the database most of the time and access the same table from the front-end forms. Now and again a record becomes corrupt and just shows "#error" or "#Delete" in all the fields and it can't be deleted. I first thought this could have been just a network error but it's happening to often. I then changed the layout of the table as it had a "memo" field which I have now taken out and put in its own table and this table now doesn’t' corrupt.
So I can only think it's down to the multi-users hammering the same table at the same time. Is there anything I can do to stop this, if it's to change the design of how everything works or anything else I can do to the database?
Thanks
|
|
|
|
11-26-2015, 10:27 AM
|
#2
|
Join Date: Apr 2006
Location: Burnaby
Posts: 4,004
Thanked 3,863 Times in 1,041 Posts
Failed 268 Times in 77 Posts
|
have you tried turning it off and on again?
__________________
Quote:
Originally Posted by jasonturbo
Too bad it isn't about flipping cars to lose money, I'm really good at that.
|
Quote:
Originally Posted by SkunkWorks
This wouldn't happen if you didn't drive a peasant car like an Audi...
|
Quote:
[14-05, 14:59] FastAnna You tiny bra wearing, gigantic son of a bitch
[15-05, 10:35] FastAnna Yeah I was dreaming of those big titties in that tiny bra
|
Quote:
Originally Posted by westopher
I'd probably blow someone for that 911
|
|
|
|
|
|
11-26-2015, 01:33 PM
|
#3
|
|
Zombie Mod
Join Date: Aug 2003
Location: Langley
Posts: 9,956
Thanked 5,279 Times in 1,592 Posts
Failed 120 Times in 54 Posts
|
Could it be a user entering a character or combination in that field that's screwing things up? I used to repair access databases years ago, so I'm beyond rusty, but I recall a majority of my fixes was removing a quote or comma.
__________________
Romans 10:9
|
|
|
|
11-27-2015, 09:46 AM
|
#4
|
|
Los Bastardo owned my ass at least once
Join Date: Nov 2005
Location: vancouver
Posts: 6,004
Thanked 1,385 Times in 483 Posts
Failed 51 Times in 26 Posts
|
from what i always found, it was some invalid things going into fields that screws it over in access.
I've been moving my access database to sql databases as they seem to be less troublesome from what i found... or users just stop entering invalid things lol
|
|
|
|
|
11-29-2015, 07:43 AM
|
#5
|
|
RS Lurker, I don't post!
Join Date: Nov 2015
Posts: 1
Thanked 0 Times in 0 Posts
Failed 0 Times in 0 Posts
|
The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:
1. Do not open Access database must closed
2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
3. Close the .mdb file related to .ldb file before you delete the .ldb file.
4. Then Run the Compact and Repair tool
But sometimes .mdb file are damaged seriously, if nothing of these can't be effective, you may use next solution https://www.repairtoolbox.com/accessrepair.html Access Repair Toolbox
|
|
|
|
|
11-30-2015, 05:05 PM
|
#6
|
|
Rs has made me the woman i am today!
Join Date: Oct 2001
Location: Here! n There!
Posts: 4,149
Thanked 498 Times in 222 Posts
Failed 121 Times in 59 Posts
|
I would have probably answered your question 10 years coz i designed my own front/backend stuff but man stuff become so outdated rather quickly
__________________
Go Canucks Go!
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -8. The time now is 01:37 PM.
|
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
