Database Not Working?

Jun 23, 2005

Our database is 1.6gb in size.
It has stopped working, is there a way to delete old records?
We are told it will crash the computer, because access needs the same space as the data its self.
Any ideas?
Thank you for your time in reading this post

View Replies


ADVERTISEMENT

Seeing Who Is Working On Database

Nov 3, 2004

Hi,

I have a database in company network which all users can reach. Can I see who is working on the database as administrator?

It is possible in excell, how it happens in access?

Thanks
Ilkem

View 1 Replies View Related

Working Access Database

Apr 26, 2005

Hi.

I am having a hell of a time trying to make my order and invoice processing database to work properly with useful functions. Is there any online resource from which I can download a working example of such a database in order to use as a case study and examine how everything relates and how complex order forms are created? :confused:

Thanks.

View 2 Replies View Related

Very Large Database, Not Working

Jun 25, 2005

Hi
Many thanxs for replies, Like the idea of compacting.
We are traveling down the path of setting up a delete query.
This will hopefully delete the records but not the structure.
We are networked and a computer Warp2, writes data at Midnight to the sever, and then we use access on Windows NT to view the data.

We can then compact to maintain the database and not allow it to grow to 1.6 GB again.

Any ideas on the delete query thingy would be greatly appreciated.
:cool:
Many thanks for reading this post from a new starter.

View 2 Replies View Related

Database Not Working For Some Users

Aug 7, 2007

I am having a problem that I have never encountered before and thought I start here. Using Access 2003
I have a database that resides on a main computer and my users connect via the network to this database. On my forms I have command buttons that run simple macros to copy and paste data from one field into another. The macro contains a GOTOCONTROL, to copy the contents and then moves to the next field. Then I have SEND KEYS command and wait is set to yes, then PASTE. When they press the command button it seems like the SENDKEYS is not waiting then the macro halts becuse it is saying the COPY command is not available. This happens to all users except for one. That other user is also connected to the database via the network. I checked the OPTION for all the computers that are connected and they all match to the one computer that works. The one computer that does work is the one that was used to write the database but the databse is now on another computer that is always on. The funny thing is that if I were to change any option under Forms/Reports, the macro's will work for a while then stop. I did do a compact and repair several times but this has no effect. Sorry for rambling but I am just frustrated because this databse worked fine at another account of mine and I just can't figure out why this is happening.
Thanks in advance for your reply.

I now haw 2 laptops that work and 2 desktops and 1 laptop that don't.

VAD

View 13 Replies View Related

Working With Linked Database

Feb 6, 2007

I am slowly but surely learning more everyday about Access. I inherited a database system from a gentleman who set up a lot of great stuff but did not document anything! I am working with a linked database in Access. I am trying to add information to a look up wizard. I am unable to de-select the "Enforce Referential Integrity", so I deleted the one to many relationship in hopes of being able to add the information. However, I am still not able. A message pops up stating it is a linked table and some properties can not be modified. My look up wizard Row Source can not be modified.

Any tips on how to get around this?

View 1 Replies View Related

Troubleshooting Split Database That Was Working Before

Oct 1, 2004

I created a database which had to be split to allow multiple people to access it with three 'front-ends' so that different people had different levels of access. Due to security problems this database had to be moved to another location on the network. Now I have used the linked table manager to update all of the frontends so they can locate the data. Previously users would just copy their own version, appropriate to them, and use this to update; now though only one person can open the database at a time with the backend database being opened and hence locked (if that makes sense).

Any suggestions as to why this has happened, or solutions would be appreciated.

mjc65

View 2 Replies View Related

General :: Possible For Database To Get Working With Voice?

Dec 27, 2013

I have an asked and i want to give the answer , when we create a database application it is possible the database working with voice ? for example when i tell the databse login form username is Admin and password is 12345 the database was opened ? if it is possible, how to do it because before i see it but i don't no how to do it .

For example like this code

Dim message, sapi
message=InputBox("What do you want me to say?","Speak to Me")
Set sapi=CreateObject("sapi.spvoice")
sapi.Speak message

View 1 Replies View Related

Request: Database Sample With Working ListView

Jun 27, 2005

Hello all,

I finally got TreeView to work, by downloading the example database from this (http://www.access-programmers.co.uk/forums/showthread.php?t=80805&highlight=treeview) thread. I haven't had as much luck with ListView, though. Does anyone have a database they could post that has a working listview? I'd greatly appreciate it!!

Thanks,
Eric

View 1 Replies View Related

Multiple DataBase Working On Local Network

Jan 14, 2008

Hi! I work at a company where a same DB is being opened by more than one user, is there any way to allow many users be working on a same DB?

Actually I cannot even open it if its already opened. It appears another file with a "lock", which seems to be protecting the DB. :confused:

View 5 Replies View Related

Access Database Quits Working Correctly

Mar 26, 2008

I am working on developing a database that develops requests to send to another department. There are a lot of forms, macros, reports and queries. A user inputs information into a form, and then selects a command button that is attached to a macro that builds the request. Midway through the build, another form comes up to complete missing information. I was going along just fine - at the testing stage for this part of the process - when the database stopped working like it should. Some of the issues I am seeing:

1) If you open a new query and try to close it without saving it, it just keeps asking you if you want to save over and over even though you select No.

2) If you open an existing query and make a change, it closes it and saves the changes without any prompting at all.

3) Macros and forms do not work right. I have a macro that deletes the records from one table. The form for that table now shows #Deleted in all the fields instead of blanks.

If you compact/repair the database is good for one run through but then it doesn't work correctly again. I have had this issue in the past but have no clue how I break my databases! I have a general knowledge of Access, I am not really a VBA coder if I can avoid it at all costs. There must be something in the relationship between all my tables, queries, forms, etc but I have no clue even where to start to troubleshoot. HELP!!

View 3 Replies View Related

Forms :: Multiple Users On LAN Working On Same Database

Jan 21, 2015

How multiple users can work on the same database across LAN, without using share point.

View 6 Replies View Related

General :: Access 2010 - Database Only Working In PC?

Aug 27, 2014

I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form.

I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is not working. I mean, The Form is opening but when I click the Button nothing is happening. My Colleague is using 2007 Version of MS Access.

View 5 Replies View Related

Database Not Working After Adding Attachment Field?

Aug 5, 2013

I created a database a while ago which has been working just fine, until I wanted to make one addition: an attachement field to one of its tables.

If I do so, some queries don't work anymore and as a result of that, some (sub)forms do not work. The only error I get is: The search key was not found in any record.

When I add an other kind of field (like a text field), the problem does not occur..

When I remove the attachment field again, everything works fine again...

View 8 Replies View Related

General :: Dial Button Not Working In Standalone Database

May 23, 2014

I have an Access 2007 database which has a form on which is a button to dial the currently selected phone number. All works fine. My intention is to send out partial databases to people not having access installed and they will use the access runtime module.

When the same database is run using the runtime it does not dial and does not give an error message. It just stays the same as though I didn't press the dial button.

View 10 Replies View Related

General :: Access 2010 Split Database Hyperlinks Not Working / When Copy Of Front End Moved

Jul 14, 2014

I have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end?

View 3 Replies View Related

Access 2000 Database Not Working Under Access 2003

Dec 7, 2005

i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:

You dont have permissions to modify.

If i run it on access 2000 it runs fine.

Someone please help.

View 5 Replies View Related

Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File

Dec 27, 2014

I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.

The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?

View 1 Replies View Related

Duplicate Record Command Button Not Working For One Form But Is Working For Other Form

Jan 15, 2015

I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.

I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?

View 13 Replies View Related

Working Out How Old Someone Is

May 10, 2005

Hi all,

I'm making a simple query to tell me how old a list of members are in a database.

I figure as I have their birthday, armed with todays date access should be able to tell me (in years only) how old they are.

Any help is appreciated

View 14 Replies View Related

MDE Not Working?

Jul 19, 2005

Hi,

I have 2 computers (computer 1 with Office XP and computer 2 with Office XP SP1). An MDE file created from an MDB file on computer 1 will not work on computer 2 (run time error), but an MDE file created on computer 2 also does not work on computer 1 (error message was "database corrupted").

Does anyone know why and what I can do to make the MDE work on both machines?

View 6 Replies View Related

MDE Not Working

Jul 21, 2006

Hi. I have got a small database, I have split it into front and back end. I then try to make an MDE out of the front end and after going to tools>db utilities>make MDE file, i got the save as box open up and i pressd save to my desktop,the box disappears and the screen is just blank(like there is no database file has been open,at the bottom of Access it says Make MDE/ADE.
And it just crashes.. it doesnt come up with any errors.
If anyone has any information pleeeeeaaaseee help.......

View 8 Replies View Related

Cbo Not Working Well

Aug 2, 2005

My Combo Box works and displays new entries in text boxes in my form. The selection appears in every record. I would like the selection to be stored only in the displayed record and not for each and every record. Any ideas?

My combo box works on an existing query( Qry1). I would like the data from my query (Qry1) to be displayed in the record (in Form1) which I am viewing. When I go onto a new record (IN Form1) I would like to make a new selection from my query (Qry1) and then store these details in the new record in Form1.

I am a little frustrated - please help.

View 3 Replies View Related

Sum() Not Working

Sep 20, 2006

This seems so simple, but, being a novice, I'm scratching my head.

I'm using an unbound text box in the form footer to sum the value of a column in the form ( =Sum([LineTotal]) ). [LineTotal] evaluates correctly, yet the sum is always #ERROR. Is there something I am missing, or am I correct in thinking that this should work?

Thanks to anyone who can shed some light.

-Don

View 7 Replies View Related

Why Is This Not Working ?

Nov 8, 2004

I open a form that is bound to a linked SQL table. On that form a have a list box that shows a series of records based on a query. The listbox DOES contain the PK field "Record_date" in its query.

I am expecting that if I click on a given record in the list box the form would change to that matching record. What am I doing wrong ?

List box code:

Private Sub List212_AfterUpdate()

' Find the record that matches the control.
Dim rst As Object
Set rst = Me.Recordset.Clone
rst.FindFirst "[Record_date] = #" & Format(Me![List212], "mm/dd/yyyy") & "#"
If Not rst.EOF Then Me.Bookmark = rst.Bookmark

End Sub

If I change the form record and click the list box, its always takes me back to the 1st record - not the matching record selected in the form.

Help ?

View 3 Replies View Related

Why Is This Not Working??

May 8, 2005

Hy,i've got three tables:
products:
product_id,product_name
months:
month_id,name_of_month
calculations:
calculations_id,month_id,amount

Also have this query:

SELECT DISTINCTROW products.product_name, Sum(calculations.amount) AS [Sum Of amount]
FROM products INNER JOIN calculations ON products.product_id=calculations.product_id
WHERE calculations.month_id in (forms!frmMyForm!txtMyTextbox.value)
GROUP BY products.product_name;

My problem lies in this part of query :
WHERE calculations.month_id in (forms!frmMyForm!txtMyTextbox.value).

I've got problem when i want to get values from my textbox on my form.
If i instead (forms!frmMyForm!txtMyTextbox.value) put (1,2) my query works fine,but when i wanna get this same values from textbox on my form it returns me an error.
I have also noticed one more thing:If i put in my textbox just value 1 it works fine,but if i use more values separeted by comma instead of result it returns me an error.
Why is this,and how to avoide this problem?
Thanks!

View 8 Replies View Related







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