General :: Lock Down Application By Saving As ACCDE File

Sep 29, 2012

Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.

When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?

View Replies

General :: Make Accdr File Out Of Accde File?

Sep 10, 2012

How do I make an accdr file out of an accde file?

View 9 Replies View Related

General :: Form Controls Running ACCDE File

Nov 21, 2013

I've Saved an Access 2010 File as an .accde version that opens Ok however none of the buttons (eg; delete record, go to first record, next record) that I placed on the form work at all (the standard record selectors at the bottom of the form still work). All the buttons work fine in the .accdb version - only the .accde version that doesnt work...

View 1 Replies View Related

General :: Command Button Not Working In ACCDE File

Oct 19, 2014

I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working.

View 7 Replies View Related

General :: Lock Individual Records After Saving

May 4, 2014

I have 4 users all with the same rights. What I want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). i.e., They can all read each others created records BUT only update/modify their own created records. They all have individual passwords to log in.

View 4 Replies View Related

VBA Code Doesn't Work After Saving In ACCDE

Oct 2, 2014

I saved my front end db as .accde in order to distribute it without user being able to edit my objects. As it turned out, when I open the .accde now I see my code doesn't work anymore. I have a lot of startup code and now it doesn't trigger at startup. Basically all my forms use vba code and none of them works in .accde . Accdb version works without any issue.

View 3 Replies View Related

General :: Access Database To Application (EXE File) To CD?

Nov 24, 2012

Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..

View 1 Replies View Related

General :: Convert Web Access File To A Desktop Application?

Oct 21, 2013

How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.

The use of file is only in desktop.

View 3 Replies View Related

General :: Program That Can Be Used To Create EXE Type File For Application?

Dec 12, 2012

I have been reading a lot about Access Runtime and the problems that occur when a runtime application is installed on a machine that already has a full version of Access. Any program that can be used to create an .EXE type file for an access application that will eliminate all of these problems? The cost of the compiler program is not a major concern if it works!!!

View 12 Replies View Related

Forms :: Converting Accde File To A Normal File

Apr 22, 2013

I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.

How can i change it to its normal file format

View 4 Replies View Related

General :: Lock File Shows Admin User Active For All Clients

Jul 2, 2013

We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.

View 12 Replies View Related

General :: Distributing MS Access Database File With Creating Application Shortcut

Nov 4, 2014

I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.

Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.

I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?

View 2 Replies View Related

Lock A Record Through Application

Dec 13, 2006

Hi

I am a little bit confused with locking subject

I have a table in ms access database. it has some fields.

I access to this table through the application

but I want to fetch the information of a record and then lock this record. close the connection and then work on this information
after finishing works I want to update the record and then release the record.

the locks that I read are a little confusing

would you please help me and recommend a solution for this problem

thanks for attention
best regard

View 1 Replies View Related

Lock Individual Records After Saving

May 4, 2014

what i want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). ie They can all read each others created records BUT only update/modify their own created records. They all have individual passwords to log in.

View 3 Replies View Related

VBA Close Application Without Saving

Sep 21, 2004

I want to close an Excel application without it prompting me if I want to save it or not

that's what I use

set xlApp=nothing

it doesn't seem to work cause when I shut down my computer, it still asks me if I want to save it

looks like the application is still running in the background even if i set it to nothing

I could use xlApp.quit but I don't want anything poping up

can it be done?

View 2 Replies View Related

Text File To MS Excel Multiple File Import Application

Jul 20, 2006

hello,

I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).

I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?

Tokunbo

View 3 Replies View Related

General :: Accessing ACCDE Database

Aug 11, 2013

I have created a database, with various forms, modules and tables. Cos this is to be used where I work I have created an ACCDE version. I can't get the original version to open so that I can make changes.

View 4 Replies View Related

General :: Error With Accde Database

Dec 23, 2013

I have a working database which runs fine in accdb mode. But when i compile it and run the accde file I get the error "The expression you entered has a function name that XXDB nameXX cant' find."The problem is that the autoexec macro cannot find the VBA public function that is called with runcode command.

The accde file is running in the same folder as the accdb. It is a split database, I am only working on the Front End..I have tried, amongst others:

- Creating a new vba module and copying all the functions across

- Renaming the target function

- I reckoned there was a corruption somewhere, so I created a blank database and imported all the form/code/etc across from the broken version, which imported fine. The accdb ran but the compiled version failed again

View 14 Replies View Related

General :: Do Not See Make ACCDE Button

Mar 1, 2013

I do not see the Make ACCDE button. I'm using Access 2010 32 bit. Have an ACCDB FE file which I'm trying to create the ACCDE. I've compiled and fixed the VB errors. I've review trusted sources and insured the folders are trusted. For whatever reason, the button is not showing.

View 2 Replies View Related

General :: ACCDE To Open / Need To Have MS Access Installed

Sep 24, 2013

do I need to have MS Access installed, in order to open an ACCDE file.there is no need, as I see ACCDE as an exe file.

View 2 Replies View Related

General :: Avoid Multiple Instances Of ACCDE

Jun 14, 2013

I have an Access 2007 mydb.accdb file. If I click on it, it starts up fine. If I click on it again, then focus goes to the already open db.

If I do the same but with the .accde of the same db, for each click a new instance opens. This is not good, in that a single user then can have multiple instances running without noticing it, and that might mess things up. What Windows setting to use, to convince Win XP that only one instance of mydb.accde should run, similar to the .accdb?

View 2 Replies View Related

General :: Invalid Procedure Call Or Argument In Accde But Not In Accdb

Aug 6, 2012

I'm getting this error (invalid procedure call or argument - DLL error 0, number 5) on my accde file but not on the accdb.

View 1 Replies View Related

General :: Front End ACCDE Not Opening - Unrecognized Format Error

Feb 11, 2014

I have made a database, splitted it and then made the front end as accde. After that I copied both Front end & back end files in a shared folder. It is working fine as long as I am using it from my computer, but when I go to the other computer and try to open the front end, it gives the message of Unrecognized format error. This problem is only with the accde file, all other files are opening except this.

View 11 Replies View Related

Could Not Lock File

Nov 1, 2004

I created a database for one company. So, this database needs to support multiple users environment. One of the users has problem opening the database. Sometime he can open it. �. sometime he has an error message �Could not lock file�. What�s wrong with the database? (I gave him permission to �Read�, �Write� and �Read & Execute�)
Thanks in advance for all your answers.

View 1 Replies View Related

Security 'Could Not Lock File'

Nov 30, 2005

Hi all,
We are changing domains and are doing alot of bouncing around with passwords and such.
Now all my users who are not in admins can not open our Db.
We get a message 'Could not lock file'. Any ideas?
thanks

View 3 Replies View Related

Could Not Lock File Message

Sep 26, 2006

Hi folks - need some help with what is probably very easy but I just can't get it.

I am running an access database on a 2 pc network with shared access etc. I can see all files on both computers but when I try to open the same file on both systems I get error message " could not lock file" I had another database earlier this year working on the two machines perfectly and was able to input data from both and the file was not a froint end back end structiure.

also if is any help the second machine only seems to be able to open in Read only mode. I have tried the user permission on the my computer allow shared access but this has not fixed it.

Any ideas much appreciated

Thanks

Humph

View 2 Replies View Related