I am in the process of updating a database to 2010 (.accdb) and cannot get past a problem. We are using Access 2010.
I updated the back end data to .accdb with no problem. I can't link the front end to that data without updating the front end to .accdb as well. There are no tables in the front end.
I try to update the front end to /accdb and I get the error message 'You are trying to convert an encoded database. Decode the database, then try again.'
How do I decode the database? I tried setting a password and then unsetting it, but that made no difference. I have not previously encoded the database.
can't finish the update to .accdb data. The alternative is to stay with 2003 MDB data. Is that a bad thing?
I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing.
However, I want to share a version of this database with a different start up form, some restricted forms etc. If I make a copy of the accdb it creates and make changes to that, it still synchronises those changes and they affect my own version.
What is the correct way to create a different database version from my accdw?
All I want to do is take the accdb it creates, change the startup form and give it to somebody to use.
Objective?: I'm attempting to change the file location of the back end portion of my split database.
What I've done so far: I've used the linked table manager to update the back end location of all tables in the front end portion of the database.
Symptoms: When making a change to the OLD back end: If I change the name or move the old back end and then try to re-open the front end, Access opens as if I'm opening the application itself without any database associated with it until I restore the OLD back end to its appropriate state.
When making a change to the NEW back end: If I change the name or move the new Back end and then try to re-open the front end, I get a: "Could not find file" error message until I restore the new back end to it's appropriate state.
I've just discovered a query that I think put me one step closer to resolving this issue. [URL] .....
When I run this query:
Code: SELECT MSysObjects.Database FROM MSysObjects GROUP BY MSysObjects.Database, MSysObjects.Type HAVING (((MSysObjects.Type) In (4,6)));
It returns 2 results: 1. The path of my old back end 2. The path of my new back end.
Unfortunately I'm not able to update the values from the Datasheet, but this does confirm to me that the old back end is still some how being used by the front end even after my tables have all been updated.
I have a (Access Data Project) ADP project which was created in Access 2003.I need to convert it into an ACCDB file with Access 2007. How to do this besides exporting each and every table, query,report etc one by one ? I was hoping there was something where I could import or export the whole thing in one go.
Is there an easy way to convert an old ACCESS db from version 2003 to version 2010?
My ACCESS db is .mdb and I want to convert it to .accdb as version 2010. It has hundreds of modules that may take awhile to export. Exporting is the only way I know to transfer from one db to another.
I have MS Access on my PC however wish to move the accdb file to a network location to allow other network users to have access to it.
Unfortunately a few of the other users do not have MS Access. Is it possible for them to still open the database without any admin or background - I would like them to be able to use the forms and 'front end'.
We have a split A2010 accdb, and the backend is now 1.8Gb so I need to do something If I put each of the 4 main tables in 4 separate backend accdbs, will the fact that the frontend then needs to link to 4 accdbs in some way impact on performance? Another possibility (given that 90% of our work only needs the recent data) is that I split the 4 main tables into 'archive' and 'current' (= recent) tables, with all the 'archive' tables in one accdb and all the 'current' tables in another accdb: but that would make it more difficult to run reports etc over the entire data Putting the 4 main tables in 4 separate backend accdbs seems like the answer to me - but are there any other considerations to this.
I have a database with extension .accdb. When I open it, everything is locked. I can't access VB Editor, Navigation Pane, Ribbon, nothing. It just opens a form and the only thing that can be edited are the text boxes on the form. I can't use Shift when opening it, that does nothing. It does not prompt for a password when opening.
This application must be able to read from a big table in a separate accdb.
This separate accdb contains info that should NOT be available for all my users to copy, as it is valuable competitive information that could be abused by people with bad intentions. So, a linked table solution is not an option.
However, it should be possible to run parameterized queries that do simple look-ups that return only small/relevant portions of the database.
I have Win7 Pro 64 bit and Office 2010 32 bit on my desktop machine. I have a laptop with Office 2007 and Win 7 Home Premium, 32 bit. I do NOT have Office 2010 SP1 because I heard there was some conflict between 2010 SP1 and Office 2007. I switch frequently between both (one on the desktop and one on the laptop).
I do not have this issue on the laptop ... they are both Win 7 64 bit, but the laptop has Home Premium and Office 2007 and the desktop has Office 2010 32 bit.
I converted some of my Access databases to the newer accdb from mdb format. The databases work fine on both computers. BUT, if I double click on the file or a shortcut to the file on the Win 7 Pro/2010 machine, a COPY of the file is opened and named "Filename1". If I double click again on the file or a shortcut to the file, then a different copy is opened and named "Filename2" (and this is a copy of the original "Filename", NOT the first copy "Filename1".) Of course, any changes I make to the file are saved in the new file name.
AND, if I double click on a copy, Then a NEW copy is made ..."Filename1" is copied to "Filename11"...The only way to open the original of the file is to select it and choose "open with ..." and Access.This does not happen with mdb files, or any other files that I can find. It also doesn't happen on the Win 7/2007 machine. It happens on every accdb file on the desktop machine, whether its a converted file (from mdb) or a brand new accdb file.I was ticked at my daughter for constantly creating "new" database files called Database, Database1, Database2, etc.! And she was frustrated because her changes were "never" saved ... they were, but not in the file she was clicking on.
Older daughter has a laptop with the same operating system (Win7 Pro, 64 bit) and the same version of Access 2010, 32 bit (installed from the same disk).I copied my file over to her computer and opened from Access, by double clicking in Explorer and by double clicking a short cut and it never duplicated the file. I did a repair of Microsoft Office on my desktop computer, using the install disk and that did not fix the problem. If I go to the Explorer right click on the file and choose "Open With" then, when the file opens, it is NOT duplicated. Or, if I open Access first and then open the file, it is not duplicated. So, maybe a file association problem? I changed the association to Excel.
I've been using this computer and Office 2010 since last July (2012).I discovered this problem in May and did some file checking and found copies of files created in February and forward ...
I have an accdb built using Access 2013 that will run with in 2010 Runtime. I am about ready to distribute the application, and am starting to do some research.
When I attempt to package and sign the db using the feature in Access 2013 it asks for me to "Confirm Certificate".
Before I go buy one I want to 1) try to create on myself and 2) learn about some good places to buy them.
1) I created a "Self-Signed" certificate using IIS, but the certificate doesn't show up on the list of certs when I attempt to package and sign the accdb. Is there a way to use a "Self-Signed" certificate to package my accdb?
2) If purchasing a SSL is the only option. Where is the best place to buy a SSL that I can use to package and sign accdbs from Access 2013?
I have a database that is saved as an accdr so it can be compiled for distribution as an exe..I have just found the accdr the exe installed and renamed to accrb and was then able to open it and view all the tables, forms etc.Obviously I cant stop someone renaming but if there was a way to stop the forms, tables etc opening.
I see a lot of really interesting ways to do this via code as an automated action, but what I can't seem to find is how to do this manually?? I will look into the automation at a later time and probably use some of these wonderful ideas. For the moment, however, I just need to know a simple way to update my front end table after I have redesigned it in the back end. MSAccess help files can't seem to point me in the right direction. I've already changed my back end table, but can seem to make those changes reflect in the front end. I would appreciate any help with this, thanks.
I was looking at Bob Larson's utility posted here (http://www.access-programmers.co.uk/forums/showthread.php?t=111132) and I have a question. Maybe I'm being dense (I probably am) but the loading page on my form looks like this:
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
I have just delivered my front end to the user. I have incorpoated a splash screen which uses the timer event and then a sign-in form opens. Trouble is, when the user opens the FE it just sits there on the splash screen. The Access security won't let the above process run because it stops all VBA until the user shift-starts and clicks the 'allow' button. After that it all works fine until I deliver an updated version and it all starts again. All using A2010. what I need to do to avoid the user having to shift-start?
Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own.
My question is this:
If I were to create a shortcut on everyone's desktop that linked to one front end would this be wise? I can't seem to get a straight answer from anywhere on the internet. I know most places say that it is better to have the actual front end on the staffs computer but that would make my job of keeping the database updated even worse because staff have multiple computers and this isn't my full time job.
If this is okay practice how many users would this be able to sustain? Currently we only have 6 users on the database with there own front end and it works great. I am planning on adding around 10 more users in the future but if needed they could have there own database as they are separate programs.
What is the best solution for sharing a front end DB as me having the BE installed at my pc, giving all user the FE and then refreshing table link with BE installed at pc but the problem is that the shared FE becoming slow any option ? as only 5 users using this at a time.
I'm trying to move a couple tables into the Front End of an Access 2010 database because the drop downs take awhile to load. We have horrible servers at work.
I can get some of them to convert to local table but naturally the ones I really need won't. The only table I want to remain in my backend is "project log data final". I don't even get an error message it just doesn't do it. Why would it not let me convert some to a local table. Does it have anything to do with relationships?
I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type servernamefolder..I have used the Linked Table Manager to point to the tables server name folderfilename.accdb
but in doing this I get a message Windows cannot access servernamefolder..is this to do Network Rights on the server that I don't have permission to access the server and folder.
I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!)The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower.I am looking to separate this in to 3 FrontEnd files as to simplify and to lessen the file sizes etc.
My question is - are there any issues around a 3 x FrontEnd databases all connecting to 1 x backend database holding all the tables - over a network?
I just split my DB into a front end and a back end. I only want the users to have access to 2 forms in the DB because the form already has buttons that link to all other forms and reports needed. How do I customize the front end view so that they only see these 2 forms?
