Problem Opening .mdb File

Dec 7, 2006

Access 2000
WinXp Pro

Greetings:

I have a small access database that I keep on my thumb drive, the last time I closed it I removed my thumb drive before it finished saving and I got the windows was “unable to save” dialog box. Well, the next time I tried to open it, it would not open; when I click on it, it asks for the password (password protected) but when I enter the correct password “Nothing”. I tried to compact and repair but all I get is the option to browse as though there is no file open.

I have researched but can find no solution. Any help will be greatly appreciated.

thanks

Mickey

View Replies


ADVERTISEMENT

Modules & VBA :: Determine Excel File Type Without Opening The File?

Aug 14, 2015

Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?

I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.

I'm using Office 2010.

View 3 Replies View Related

Forms :: Storing File Location And Opening File From A Form

Dec 5, 2014

i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text

i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.

View 4 Replies View Related

<>Opening A Word File<>

Aug 31, 2005

Is it possible to open a Microsoft Word FILE using a macro(or even a query??)? I know how to open Word itself using a Macro by Selecting the Run App Command and typing in my Word address e.g C:Word.exe . I have tried opening a word file using C:filename.doc but no success, the address is correct as I've successfully opened it using Start, Run

Any help would be superb
Cheers All

View 1 Replies View Related

Opening A File With A Macro

Sep 8, 2005

Is it possible to open an Excel FILE using a macro, if so could someone shed some light on this? I know how to open Excel itself using RunApp but it doesnt work with files.

Any help would be appreciated
Cheers all

Bikeboardsurf

View 1 Replies View Related

Opening PDF File From Access Is This Possible

Nov 24, 2005

Hi All

I'm not sure if this is even possible but I have a table which has a list of Categories(text) and another field named filepath(also text) which contains a file path which points to specific pdfs. So my question is Can I create a report which then prints the categories with a button next to them which if clicked on opens the coresponding pdf ?

Any help will really be apreciated I am a database novice but am really good at following instructions and copying code :)

Thanks in advance
Mel

View 3 Replies View Related

Opening An Excel File In Access 97

Aug 26, 2005

I created an Excel file using:

DoCmd.OutputTo acOutputQuery, _
"Compile_Query", acFormatXLS, _
"G:ServiceCompanySanDiegoWarehouseLCDLine_Summa riesDaily" _
& DateMonth & DateDay & DateYear & ".XLS", False

However, after creating this excel file, i want it to automatically open.

Is there any way to do this in 97?

View 1 Replies View Related

Problem Opening Access File

Apr 9, 2007

Hi

I am having trouble opening a file I created like 6 years ago. The verison has changed and I have changed computers. When I try to open the file I am receiving an error. That the current user account doesn't have permission to convert or enable this database. Is there a way to correct this? Thanks

View 1 Replies View Related

Stop User From Opening FE MDE File Twice

Oct 18, 2007

Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)?

I've been searching the forum and found this
http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html
but since im not using an .exe updater is not my case t.t

View 5 Replies View Related

Opening Other File Types From Within Access

Nov 16, 2004

I have a database application that I have to get to display some external PDF files.

I thought that I would create a command buttone and use that to open the files, but that doesn't want to work. Can anyone provide some thoughts on how to open a Word document or PDF file from within an access form? I only need to display it and then close the file so it doesn't have to be anything fancy.

Help

View 9 Replies View Related

Opening A MSword File From Access

Jan 27, 2005

I wish to open a specific MS Word file using a button on an Access form. Word opens OK, but how do I get it to open the particular file please?

Thanks

View 6 Replies View Related

Opening File In Shell Execute

Dec 20, 2005

I seem to be having a problem opening a file if there happens to be any spaces in the file name. If I open a .pdf no problem acro reader opens it but if it is in word or excell or any other tells me that the file can not be found and seems that only the first part of the file name before a space in the name and the file extention.
example: "Test it.doc" would appear as "Test.doc". somewhere it seems to be trimming the file name.

View 1 Replies View Related

General :: File / Options Not Opening Box?

May 8, 2015

Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!

View 4 Replies View Related

Modules & VBA :: Opening PDF File In Form?

Jul 22, 2015

I've got a table with field define as hyperlink which stores link to a external pdf.

Then i create a form including this field and add a unbound field which has got intermet browser format (as a type).

What code I have to put in onclick event in a hyperlink property sheet to open PDF inside the form?

View 1 Replies View Related

General :: Opening ACCDR File

Nov 8, 2012

A colleague sent me an .accdr file, and since I don't have Access, I was told to download Access Runtime. From other forums I see that I'm just supposed to be able to double-click the file to get it to open, but I cannot. The file is associated with .7s, and since I can't locate the Access Runtime program, I can't change the association.

View 1 Replies View Related

Got Warning Everytime Opening An Access File

Dec 3, 2006

Hi,

I wonder if anyone here might be able to help me out here. I've been pondering this issue for so long and i was almost giving up.

I've been getting this warning everytime i open up an Access file (.MDB) especially, when trying to open up a file that's sitting on another computers. i have a few computers and they are set up in a peer to peer environment.

I took a printscreen of the warning message and attached it to this post. Please take a look at it. It's called "access.jpg"

Is there any way of turning it off? is it to do with the peer to peer networking?

Thank you in advance

View 2 Replies View Related

Batch File For Opening Secured Databases

Jan 17, 2007

I'm sure most people use Windows shortcuts to open their secured databases, but I found that it didn't always work (depending on which computer I used). Editing a shortcut is pretty confusing since the command is all on one line. I decided to make a batch file to open my secured databases instead. Here's a batch file I use to open a database of mine:@ECHO OFFREM - Set variables to be used in the batch file.SET BACK=Z:BobManager Listdb_be.mdbSET FRONT=Z:BobManager Listdb_fe.mdbSET WRKGRP=Z:BobManager ListSecured.mdwSET OFFICE=C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXEIF EXIST "%OFFICE%" GOTO PROMPTSET OFFICE=C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXEGOTO PROMPTREM - Ask the user which end to open.:PROMPTCLSSET /P dbChoice=Do you wish to open the frontend(1) or the backend(2)? if "%dbChoice%" == "1" ( "%OFFICE%" "%FRONT%" /wrkgrp "%WRKGRP%" GOTO END)if "%dbChoice%" == "2" ( "%OFFICE%" "%BACK%" /wrkgrp "%WRKGRP%" GOTO END):ENDThis isn't the simplest batch file ever, but if you want to use this you just need to change the paths to your frontend, backend, workgroup file, and your version of Access. If Office was installed in the default location you shouldn't need to change those lines, unless you know you'll always be using the same version of Access.

View 1 Replies View Related

Opening An Mde File In A Newer Version Of Access

Apr 22, 2007

I have an mde database originally created in Access 2003. Will I be able to open it in Access 2007?

(I ask because this mde file was originally created in Access 2002, and wouldn't open in A03. We had to track down the creator and get her to resend a new mde file that was 03 compatible. Are we going to run into the same problem after the next upgrade?)

View 1 Replies View Related

Exporting Data To Excel And Opening The File?

Mar 9, 2005

Hi guys, this might be a quickie, I did a quick search but couldn't find anything :/

Basically my database creates a table which some people would rather analyse within excel because they're not comfortable with access. I can get the table exporting to an xls file no problem, howeevr what I would like is for the database to export the file and open the file in excel at the same time so the user doesn't need to open up excel and find the file etc...

Any ideas??

View 2 Replies View Related

Autostart A Specific Form When Opening Mdb File

Mar 14, 2005

hello,
i have an .mdb file, with one main form in it.
i want to send to some friends of mine this file, but i want that when the file is opened, automatically, that main form will be opened.
how can i do that?

thank you.

View 4 Replies View Related

Opening Different File Types With Ms Access 2003

Jan 15, 2008

hello good afternoon.
i am trying to open different file types using ms access. the following piece of code i found would only open 'word' documents. how do i make this piece of code more flexible to open pdf documents and excel as well. as it is currently i have a txt field on my form and if the path in the txt fiels leads to a word document when i click a button the word file opens. i want it to open a pdf or excel doc if it was in the txt field

[code]
Sub OpenWordDoc(strDocName As String)
Dim objApp As Object

'Opens the document

Set objApp = CreateObject("Word.Application")
objApp.Visible = True
objApp.Documents.Open strDocName

End Sub

View 4 Replies View Related

Forms :: Show Only Form When Opening File

Dec 31, 2014

I enclose a part of my project. I've taken out the table, query and so on.Only the form.What i want to do is to view only the form when entering the app. But if you open the file you could see a flash of the app before minimizing it. Very few, but you can see it. I've deleted some more code in the opening form that made the flashing a little bit longer.My code for entering is the following:

Code:

Private Sub Form_Open(Cancel As Integer)
DoCmd.RunCommand acCmdAppMinimize
Call fSetAccessWindow(0)
End sub

And then in another module:

Code:
Option Compare Database
Option Explicit
Global Const SW_HIDE = 0
Global Const SW_SHOWNORMAL = 1
Global Const SW_SHOWMINIMIZED = 2
Global Const SW_SHOWMAXIMIZED = 3

[code]...

how can I avoid this flashing at start?

View 2 Replies View Related

Modules & VBA :: Opening File Using Shell / CPAU

May 27, 2015

I want to open files from a networklocation from VBA, only normal users don't have access to that location (and should preferably not get it).

I instead of using shell("explorer.exe filepath") to open files using windows standard app for the file, which needs userpermissions to the path the file is located, for the currently logged in user.

I'm trying to use CPAU in combination with Shell, because using CPAU you can pass a user/password that has permission to open a process

The only problem is that the filepaths have spaces in them and that is Always a bit of a tricky thing to tackle.

So, for example, this works:

shell("N:GuidelineOntwCPAU -u DomainUser -p password -LWOP -ex " &
Chr(34) & "C:windowsExplorer.exe c: emp est.pdf")

But I cannot get it to work with a file that is on a path with a space in it (or with a space in the name), like

Code : N:EngineeringJB-MATBBBB-004_Panel PinBB-004_Panel Pin.pdf

I'm trying all kinds of thinks:

- adding chr(34) at certain places
- using """
- the above in different versions

But to this point without result.

Trying to figure out the plain cmdline:

Code:
N:GuidelineOntw10_Ontwcpau -u Domain/User -p Password -ex "c:windowsExplorer.exe "c: emp est.pdf""

Doesn't work:

Code:
N:GuidelineOntw10_Ontwcpau -u Domain/User -p Password -ex "c:windowsExplorer.exe "c: emp est 1.pdf""

(difference in filename with a space in it)

The last command start explorer, but doesn't open the file (just as the first line I posted, it opens Explorer, but not the file. Must be something with the way I pass the filename?)

Code : explorer.exe "C: emp est 1.pdf"

Also works in commandline...

View 4 Replies View Related

Forms :: Opening PDF File From Button Command

Aug 19, 2015

I would like to open a PDF document using a button control on a form to a file path listed in a field on the form (Me.Link). I am trying to use the followHyperlink code but I keep getting the runtime 490 error.

This is the code im using:

Dim strFilePath As String
strFilePath = Me.Link
Application.FollowHyperlink (strFilePath)

If I put a filepath to one of the pdf documents in the place of (strFilePath) it opens that pdf document fine but not when I declare a filepath based on the one listed on the form.

View 8 Replies View Related

Opening Doc File Through Microsoft Access Ribbons

Feb 17, 2012

Any module that would open a word document. Also, If that module could be linked to a ribbons menu item...

View 3 Replies View Related

Modules & VBA :: Opening Excel File From Access Form

Sep 21, 2014

I am trying to program a button on my ms access form to open up an excel file.. So far the simplest code ive found online was from URL....

<code>

Private Sub Command57_Click()
Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open "C:Excel1.xls"
xlTmp.Visible = True

[code]...

However the code doesn't work, any way to open a file from within access?

View 1 Replies View Related







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