Access File Cant Be Opened

Mar 9, 2008

I have Access 2000 at home, and 2003 at work.

I can still open my file at work, but the same file at home cant be opened. It keeps giving "microsoft access has encountered an error" etc.. send error report..

Any suggesstions?

Thanks!

View Replies


ADVERTISEMENT

Not Allowing Multiple Users Unless File Opened Through Access

Jul 9, 2013

I have a database with three users, only one of whom has editing privileges. As such, I didn't see the need to setup a front end and back end (nor did I know how at the time). Anyway, that's not the issue. The database is saved on a networked computer that all users can access. Unfortunately, when accessing the database in the shared network folder, only the first user can access it. Other users will double click the file and virtually nothing happens.

However, users can instead open Access first, and open the file through the program fine. Why this would be the case and how I can have multiple users open the file from the shared folder?

View 4 Replies View Related

Forms :: Copy Table In Currently Opened MDB File

Jan 8, 2014

How can copy table from another mdb file in current opened mdb file? If copy table is exist in current file table will be replaced.

View 7 Replies View Related

Modules & VBA :: Making Already Opened Excel File Invisible

Jan 14, 2014

I have the following code. In the Else part of the code, after the wb.Activate line, what code can I place here that will assign wb.Name to the objExcelApp object ao that when the line .Visible = False kicks in, it will make the already opened MS Excel file invisible.

Code:
Dim strExcelFile As String
Dim wb As Workbook
Set objExcelApp = GetObject(, "Excel.Application")
If objExcelApp Is Nothing Then
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Workbooks.Open FileName:=strExcelFile

[code]...

View 2 Replies View Related

Forms :: Access Form Must Be Opened In Design View Before Use

Oct 1, 2013

I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.

View 1 Replies View Related

Modules & VBA :: Export From MS Access To PDF With Set Variables From Opened Form

Jul 9, 2015

I have been at this for almost 3 weeks now and I'm having great difficulties trying to get this right and working. First let me explain what I am doing and what I am trying to do.

Firstly, I am making a Maintenance database using MS access software, what I have are tables, forms and no queries or report existing so far. The forms and tables all work correctly.

After the form (Job request) has been completed I need to save/export into PDF so I am able to hyperlink it against its existing asset card elsewhere.

now what I have done is Created button, on event "on click" I have tried to go to macro builder

ExportWithFormatting
Objet Type: Form
Object Name: FrmMachineFault/GenMaint
Output format: PDF
Output file:
Auto Start: No
Template File:
Encoding:
Output Quality: Print

when I click this button it opens to save to and it works perfectly but I have to manually type the file name when it gets to the Save to section.

What I want it to do is define the name by the existing fields in the open form. Example Closed date, Effected area, Asset and title.

What I am hoping for is something like this.

10/07/15_Foundry_Furnace_LPG_Leak
(Closed date)_(Effected Area)_(Asset)_(Tittle)

Is this possible?

View 14 Replies View Related

Which Tabel Was Opened, Who And When Opened It

Apr 26, 2006

Hi
I want to see Which tabel was opened, who and when opened it.
And if possible I want to see what is changed.
I want to see as I mentioned above as a "log file"

Thank you
Sedat ONAT

View 3 Replies View Related

Forms :: Access 2007 - No Records Shown When Continuous Form Is Opened

Dec 21, 2014

IN Access 2007 when a Continuous form is opened there is no records shown.

Only after hitting the page down records are shown.

View 1 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

Backup Current Access File Using Vba While The File Is Open

Jul 11, 2007

I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?

I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.

View 3 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.

Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?

View 2 Replies View Related

How To Make Setup File From Access File

Dec 7, 2006

i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.

View 3 Replies View Related

How To Convert .MDE File In To .MDB File In Access 97

Jul 18, 2007

Hi,

I want to make some changes in .MDB file and i do not have it. I have only .MDE file.. Could you please let me know how i can convert .MDE file into >MDB file so can change tabelsa nad reports...

Many Thanks

Nitesha

View 1 Replies View Related

Can Put Flash File Or Swf File In The MS Access

Nov 27, 2005

Hi,

In the Forms of the MS Access,

Can we add the flash file, or swf, other animation file on the form?

Thanks.

View 1 Replies View Related

Convert Access File To Exe File?

Dec 30, 2011

i want to convert accdb file to an exe file that not display any design view in other words i want the user watch only the forms and handle with the application as a program.

View 2 Replies View Related

Database Name Changes To Db1 When Opened Or In Use

Aug 13, 2014

I have a shared database and at times the database name changes to db1 when somebody is working on it. It doesn't happen all the time or with specific user.

For example if my database name is Incentive.mdb it will automatically change to db1.mdb when its opened and saved.

View 2 Replies View Related

Subform Is Not Opened Error

Nov 4, 2005

I have a subform inside a Form.
When I'm trying to upadate the subfrom from an event triggered by a control in Form I get the error message that subform is not opened.Why is that?
I've tried commands MoveTo or Select (subform) before update command in order to force update command to understand that subform is opened but without any result.
I guess is a common problem but I can't find the solution. :(

View 1 Replies View Related

Form Won't Stay Put When Opened

Nov 8, 2005

I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront of my Main form's tab control so I need to move it down an inch to get to the tab control.

I've positioned this form where I want it and saved it numerous times. But once I select the tab, it opens up right ontop of the Main form's tab control again. I have the AutoResize set to No and the Auto Center also set to No.

Any ideas how I can get this form to stay put?

Any help is most appreciated. Thanks.

View 2 Replies View Related

Formatting A Form Before It Is Opened

Jan 2, 2006

hopefully someone will know what to do...

i have a form that has a bunch of check boxes and labels that are hidden to start with,and become visible when a confirmation button is pressed. Wen i set this up in the design view i.e making their visible status = false, everything runs accordingly - however when the next person comes to update their details the form will not format properly. i think the reason has something to do with the check boxes having different visibilty statuses after the initial confirmation i therefore used code on the form open event

If Check2.Visible = True Then

check.Visible = False
End If

however this tends to fail at the first checkbox, however if i then press run on the VBA screen everything else seems to then run fine and so only the first checkbox is left visible...

can anybody help....

thanks in advance i hope i have made myself clear..

View 2 Replies View Related

Form Size When Opened

Jan 18, 2006

Hi
Is there a way I can make a form open to maximum size to fill the work area without click the forms Max button


dave

View 1 Replies View Related

Database Is Already Opened Exclusively

Oct 16, 2004

I have a VB6 project that connects to a Access database. I get a run time error when I try to copy the database as a backup - "You attempted to open a database that is already opened exclusively..."

I need to be able to copy this database while it is still open. How do I work around this?


Thanks Steven

View 2 Replies View Related

Check Who Has Opened Db In Network

Apr 21, 2007

I am having a db whose back end is in a shared computer and front end (all queries, forms & reports etc) are on local users machines. On opening db first form openes is user id for login.

Now I need to do more on that, 1st step is - how to check who has the db running on pc. Then to refresh his form and send him some message (popup).

Can somebody take me through?

View 2 Replies View Related

Allowing A Database To Be Opened By More Than One Person

Apr 9, 2008

How can i have multiple people entering data into a database, also there is an excel file that imports the info every few min, if i have that open i cannot enter data into the database. theres going to about 4-5 users plus the excel file.

View 1 Replies View Related

Viewing Form When Database Is Opened

Sep 2, 2005

Hey there, when a user opens my database, I want the form to enter records to automatically open. Can someone plz help with that... thx

View 3 Replies View Related

How To Disable Form Window While The Second One Is Being Opened?

May 17, 2006

Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?

thanks

View 3 Replies View Related

Modules & VBA :: Send Email When DB First Opened

Feb 11, 2014

I have the code for sending an email but I only want to send a single email when there are records in a query and only when the database is first opened.

I hadn't considered this in my design so what structural requirements would it require if any?

View 5 Replies View Related







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