How Do You Ix A Broken Database When You Can't Touch The Back End?
May 17, 2006
I have been asked to take a database created last year and re-design it to make it more user-friendly.
Not a problem, I thought when asked but I am running into a little problem...(the database designer)
In my opinion, to make a system more user-friendly there is a necessity to access the code and tables in order to gain a reasonable knowledge of the way in which it has been constructed. Unfortunately, although I am allowed to LOOK at the front end, I am not allowed any further access to coding or back end information.
At present middle management are siding with the database designer as they feel that from a security standpoint, access needs controlling (I can agree with this to an extent)
Does anyone have any ideas of how I can talk the management round or any suggestions for a way through this issue?
(Oh, and I'm not allowed to build them a new database and substitute it...I already asked)
I'm using ms access 2013.i have a project where i need to create a touch screen jukebox.my problem is that i have a textbox and a list box.the list box has all my track and i'm filtering from the textbox.when i use my keyboard the filter works fine from the textbox.but when using the touch screen buttons even though letters appear on my textbox, the filter does not work.how to make my textbox filter work from the on screen touch buttons?
Cannot open back end database. There are no other users logged on Tried opening it in open exclusive mode but still error message. Front end on number of desktop PC's. Back End on server. I need to get in design mode on back end but won't let me. I get logon screen but when try to log on get message below I can log onto front end ok.
Error message something like.
* You do not have perimission to open or enable database * You must have open/run open/exclussive administer permissions. * Request other users to log off e.t.c.
I need to take my database 50 miles to a factory site so that an engineer and I can review/modify all the records, ~450 so far.
Can I copy the front end and back end files to my laptop, review edit the data offsite, and then overwrite the back end file on my server when I get back? Are there any issues with doing that?
Does anyone know of a way to make a database back up by a click of a button in a main form in the database? (so a customer does not have to go tools/database utilities/back up database)
We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event.
Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking everyone off!
Manually copying and pasting is good, but would really like to crack this one
I have done the mistake of not keeping a backup, what I did is split my database file access and then created my mde file, I need to change some data on my tables, but I get the msg that I cant edit a linked table, is there a way that I could put things back the way it was, also this path that was created is it possible to change for future purposes (I might have to move the dir into a different path)
I need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...
Hi, I am not sure where to put this thread hopefully someone here can help me.
I have spent a good deal of time developing a very effective access database for a client. It is split into a front end and back end and connected using the Linked Table Manager when necessary.
The front end is quite loaded with queries, reports, forms, macros etc and the back end simply has the tables.
The front end is about 15 mb and the back about 8 mb.
Current set up is a small workgroup network with about 4 -5 consecutive users at any one given time.
I am looking for some advice on how to set up or facilitate getting the backend on the internet so anyone with a front end can access it outside of the LAN.
Today I set up an account with WebDrive which can connect to and assign a drive letter on your pc to any FTP, HTTP site.
I made the connection with WebDrive and using the linked table manager successfully linked the tables on my local machine to the back end on the FTP server - and actually ran the database at a pretty good rate.
I noticed however that it was downloading the backend to my local pc and once I closed the (a) form it was uploading the data back to the server? Very slow and often threw errors.
This of course is not what I wanted. Has anyone heard of doing this? Any work arounds or setting params would be greatly appreciated.
I have been told to create the DB in ASP but I do not have any idea on how to do that whatsoever...
I plan on using Excel as the front-end and Access as the back-end only. (all queries and forms are in Excel). A single Access database will be queried from multiple Excel files that will be located on the share drive (Linux server). Access tables contain memo, text and number fields. Data will be sent to Access tables and records will be appended/deleted; all via Excel.
There will be multiple users interacting with a single Access database via multiple Excel files located on the shared drive. Users will be interacting from different workstations with Windows 7, all have Access 2010 and Excel 2010 installed.
This process works for me from my workstation but I am not sure what will happen when other 4 people will be sending/appending/deleting records to the same Database? How do I make this work? What settings do I need to check in Access to make this possible?
I have a database which is split so that several people can have a 'front end' to the database to access one common back end. This works fine on a network but I thought I could load the backend up to my webspace and then with the links manager point to it, but it doesn't work. I get an error report of 'not a valid file name.'
The website is [URL] .... and the backend database name is Probus_data_A.accdb and so I entered [URL] .... as the address in link manager.
So i want to protect the back end of a database but im limited to what I can do....I am unable to restrict members from accessing the file by username...I am unable to place it in a local area which is pass protected...I am also unable to encrypt the back end as the front end needs to be able to access it (and I dont know how to allow it to do that...)
I have a database already split and I wanted to put a password on the back end. When I open up the front end and try to navigate through the forms it says "Not a valid password".Is there somewhere I need to go / something I need to do to link up the two now that a password has been created?
I have created two DBs, one Back End, and one FrontEnd. My FrontEnd contains all the UIs/Forms, Linked Tables, and the queries fetching data from linked tables, and the Back End consists of all the Tables.
Now, in my Model, the BackEnd DB will be stored in a common drive and will be accessed by multiple users through same FrontEnd.
Now when I am trying to fire a query in FrontEnd (aka FE) DB, it is locking up the Back Up database. Even though I have set the RecordLock property to No Locks to query and the form.
I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared.
I have back ups of the database going back with the first 1000 records complete.
How would i take the 1000 records and add this to the current database where the information is missing? so it wouldnt mess up recent records? could some one provide me with a step by step account. Would be much appreciated!
I have a split database. The front end with forms etc is distributed to users and the back end with tables sits on a shared drive.
I have been trying to set the security on this and quite frankly it's driving me mad. I managed to get the security set with 5 user groups and about 100 users - it all worked well on my PC but when I distributed it, the copies open with the Admin as user, no password required, resulting in no security whatsoever.
Further reading showed me that I had to change the owner of all objects from Admin to a new adminitrator, who I named Custodian1. This I did. I then created a new database while logged on as Custodian1. So, the new database has all objects owned by Custodian1 and the database itself is owned by Custodian1.
The book said I had to delete the Admin user but, after asking if I was sure that I wanted to delete the user, Access would not let me.
I went through the Workgroup security wizzard a number of times to try to reset things that way, all to no avail. I then did the whole ownership change thing with the back end database and relaunched the wizzard. Still unable to delete the Admin user.
My final attempt was to use the wizzard and create a new WIF rater than edit the existing file. And still, I cannot delete the Admin user and distributed copies have no security.
I don't know how this ties in, but the distributed copies do not seem to be linked to the WIF although they find the Back End database, in the same shared drive/directory with no problems. If I set a password on a distributed FE database copy, it then cannot be opened as the users are not defined.
I'm obviously missing something fundamental to the whole process. A further difficulty is that I have the live database FE/BE, working copies FE/BE, The security wizzard backups FE/BA, and all the directories have similar names. On top of that, I have my normal none database duties to distract me. I'm finding it very hard to keep track of where I am or what I am doing.
Any help most gratefully appreciated and received.
Goal: : To improve an application's performance by basing sub forms and combo
The application has a front and back-end. There is no SQL server involved. I use a module for, seeking out the back-end and automatically linking to the back-end in order that I might be able to provide updates. This has worked for me since first setting everything up.
First let me define what I mean by, “sub form” as to how I am designing my application. I have a number of, what I call, “main (unbound) forms” that are used to open up separate application modules. Each module contains a number of hyperlinks to each of the other application modules. Also, each main form (application module) contains a tab form with bound forms. Therefore, I am calling these lower level bound forms, sub forms and basing them on query files instead of tables. Many of the tables have fields for collecting information across a second form. I did not want to bring back all the fields when they are used in any of the two are three forms bound with the same table.
Problem: When I base either a main form or a sub-form on a query, that particular front-end query form no longer links to the back-end database table via a query file whenever I import everything g into a new/fresh version of the front-end application. Whnever I open one of the query files via the form, I get an error message in each of the fields indicating it can't fine the field even though the table is listed with all the fields. No, I do not have the same problem with forms based on tables.
I suspect that my problem is in what I am calling a main and sub form; and that the main form is really the first level bound form and never the top unbound form if one is used. I have a lot of forms. I just wanted to get some feedback on my suspicions or find out what else could be the source of my problem before re-doing everything.
I have created an access 07 database and split it to a back-end and a front-end with linked tables.
I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across online, the Back-end has to be located on a folder where all users have Red and Write rights!!! And I am thinking, if the users on this network can actually see the back-end since it is on a shared folder where they have all the rights, then does that not compromise the security?
Is there a way of linking to the back-end on a network WITHOUT the users being able to access the back-end?
Can I create a table in the back end of my database using VBA in the front end? My client is using this system and I can't easily go to their location. I need to create a table on the back end and have it available in the front end applications. My thought is to create a front end only for the purpose of updating the backend with this new table. My idea is now to have it open with a button for the user to click - this will add the table to the backend with the required fields, confirm the update was completed and then close. This app then would be trashed so it would not be run again. (Though I would put a check in the VBA that if the table existed, the user would get a message box and the coding stopped to avoid overwriting the existing file.)
And once the table is created, is there a way to programmatically link it to the front end. I will be providing a new front end with this update so I could add something in the new version.
I have a Back end (with password) which resides in a netdrive while the front end is installed in each individual users desktop, the problem is, some of the users netdrive was mapped in a different way (different letters..some are J others are G). I'm looking for code that I can relink the database to the front end in runtime, I did try to look in the net but I can't find anything that I can put the password as parameter.
this sample code from Dev is good, but i got an error because the database requires a password.where i can put the password?
Code:
Function fRefreshLinks(NewDbName As String) As Boolean Dim strMsg As String, collTbls As Collection Dim i As Integer, strDBPath As String, strTbl As String Dim dbCurr As Database, dbLink As Database Dim tdfLocal As TableDef
I am trying to use VBA to backup the BACK-END of a split database (so I can automatically archive selected data). If I use FileCopy I get a message that the BACK-END database has not been found.Obviously I could 'unlink' the BACK-END, copy it and 're-link' it..Is it possible to copy the BACK-END tables(not just the links) into the FRONT-END and get at them that way?
