Hi,
I got a question related to a database with a frontend and backend.
It seems that every time I make a minor adjustment to the frontend its size increases.
i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the size is now allmost 6 mb!
How is this possible?
Hi all
I have a database I built for my employers that is accessed by up to as many as 50 users at one time. It is a relational database. I did a compact and repair this morning which changed the BE from 215MB to 45MB. I went to lunch and came back and the database is now 58MB. Does anyone have any ideas as to why it has increased by 13MB within an hour? There is no way this is caused by geniune data records.
Thanks
Gareth :eek:
Hi,
I am trying to send a "EMP" table in an excel format using "SendObject". User clicks the "Send Mail" button to email the table in excel file. The user then clicks on the "Exit" button to exit. This wipes out the data in the table "EMP" as was expected. Every thing goes fine..... but the size of my database increases by more than 100 MB. (Note that the table in the data has been deleted & the data is around 59 MB).
Any suggestions on what could be causing this increase in file size.
Thx in advance,
Jatz
Am I right in thinking that the a listbox.itemcount increases by 1 if you include headers.
ie - the headers are counted as a row?
I have a database of apprentices, so there are a lot of wage increases, as a lot of them are on minimum wage, which rises as they get older.
I want to run a query that automatically updates based on their current age, how to do this?
Rates are:
<18 - £140.23 per week
18 to 20 - £189.81 per week
21+ - £240.50 per week
All of the employees work 37 hours a week.
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc
I have created a form that I want to share with other people. They will never add or change any of the data - they will only use the form as an information source. I need to be able to access the database to add/change information.
What is the best way to do this?
Hi Experts,
I am trying to develop a multiuser database. I heard that in a multiuser setup the back end should be on the network and front end on the users machines. Could anyone please explain what is these back end front ends and how should I set it up.
And one more (silly) question... Do we really need MS Access to be installed in the users machines in order to do this?
Any help is appretiated..
Thanks,
binjos
Hi im in the process of starting a small project to be used at work. Basically I want an Access DB which will be used by about a dozen people, accessing it over a network drive. I want them to be able to do the standard create/edit/delete records and wotnot in different tables of the DB and also want some reports and search functions.
In the future I want room to make more advanced things in it.
Would I be best to do this all in Access with forms and reports, or maybe use VB for a frontend or even something else?
Dont have much experience with Access outside of the standard DB records stuff, will security and multi access be a problem with Access?
cheers
I have a database split with a frontend (FE) and backend (BE). Both reside on our network. I give a copy of the FE to all users. The FE is linked to itself so if I make a change to the network copy the next time a user opens theirs it tells them to close down and it recopies itself. This works really good. The problem we're having is people going and making a shortcut to the networked FE. So WHENEVER they open their FE everyone gets a message saying to close and recopy. The database is about 10mb but for someone across with a slow intranet connection it can take a bit to download. I'm looking ways to prevent users from accessing the networked FE. Can you simply hide it?
Thanks,
DT
I've split the database and have a version table in the FE and a linked version table to the BE. On start up if the version numbers are different the user is asked to update the database. The problem I have is after the database FE is copied over (batfile) the Version numbers are still different because the Master FE is still showing different Versions. How did you get around this?
Thanks,
DT
Hi!
I´ve just made a frontend backend solution with a db i Access2002.
I made this because my users 5 persons have a booking system wich they use at tehe same time.
But the db locks all the time... I thougt we would get rid of that problem now.
Is there something I have to check?
I have some lookup tables, can this cause this kind of trouble?
Jack
A simple personal database created by me is to be deployed on a home network having two PCs. I did splitting to FE and BE. The BE shows only tables. I would like to have the guidance of experts in this forum for the following:
1. Whether BE to be copied first in the host PC?
2. FE to be copied in the other PC?
3. After copying the Access DB how to link FE and BE between the two PCs?
4. Whether data entry, edit, search etc. possible from both the PCs?
5. If I test with dummy records, how do I delete dummy records, from BE or FE?
Shall be grateful for help.
Hi all,
I have been building an access database at work which would be useful to share with eveyone else at over the network or live server.
Is there a front end I can get for it, or is using the access file itself the only alternative. All i know is html, css and actionscript - so I don't think I can use this. It would have to be pretty basic - I have no idea what kind of technologies are available for me in this regard.
Any suggestions or methods would be very much appreciated!
Cheers,
Doug
We have a backend of 97 version and frontend of 2003. When the users try to cnt-break out of a query that is taking a long time the de-bug window pops up and then they hit yes and the database shuts them out. How can I keep this from coming up?
View 1 Replies View RelatedHi Guys,
Does anyone have a code to check if the frontend version being used is the latest? I have a frontend in the server linked to a backend which I distribute to users via a batch file. The batch file simply copies the frontend unto the users desktop. When I do an update, I simply overwrite the old one with the updated frontend and tell the users to run the batch file again. Any ideas is highly appreciated. Thanks.
Luther
I am evaluating a program for the use of a customer. It's a VB frontend attached to an Access database.
The backend has no relationships. No table in the backend even has a primary key.
My question: Is this scenario acceptable in any way?
I tend to think not, but am unsure whether the design of the frontend application establishes relationships "on the fly". Even if so, the fact that there are no primary keys makes me think I should dismiss this application out of hand.
Thanks
At work i have a newtwork of computers each with a frontend of my database on it and 1 computer with the backend on it, once there's about 8-10 computers using it, it wont let anymore in it saying something like unable to open, exculsively opened etc. How to i get round this?
View 1 Replies View RelatedHi all, 1st post. I'm and Access n00b I'm afraid, so take it easy. I normally use php/mysql, but have been roped in to fixing a broken access database.
I've got an Access database, and a fileserver is holding the data (mdb file), but I've got around 10 machines which access the database thru a frontend (mdb file).
Now, this has been working fine until today, where I am trying to view one table (Orders), and access bombs out. It shuts down instantly with no warnings. It does this on every machine, so I think it is a database problem. I can view the data if I open the standalone data file, but I cannot view the data thru the frontend.
I need to fix this asap... what's causing the crash? I didn't make the front end, but if I could look at the code, I may be able to see where it's failing.
I am very good at excel and can program macros. I am being asked to build something in access for my company, or at least manage a build. So here is my question... If we build it without both a front and back end, is it easier to take what you have and switch it to a front and back end? Also, when and why is it better?
View 4 Replies View RelatedHi,
I'm wondering about the following.
If I would have a backend table with the data kept in tables and a frontend database with forms and reports and queries etc. and linked tables to the backend db, what would be the right way to secure both.
In my situation I have salary information in some of the tables, which should not be wide open to the holy world. I also need to restrict the access of some queries and forms in the frontend database to different users. That means I need to set up a secured frontend database with different usergroups having different object permissions. So in that frontend database the Users Group and the Admin User do not have any permissions any more. Thats why I created a shortcut where I kept the database and workgroup information in the target. Every user needs to open the database via the shortcut.
Unfortunately I was not able to secure both the backend and the frontend database, because the linked tables in the frontend db are only pointing to a database not to a shortcut. Because the backend database is secured as well (no permission to Admin and Users any more) it can't be opened directly - only by shortcut.
Am I right that there is obviously no possibility to have a secured backend and frontend db via the Jet database engine and Access?
I hope somebody can answer my questions. At least I know that I can't do anything else and I did not something wrong ;)
Wondering if anyone had tried this yet, and if so, encountered any problems. I have a few existing DB's in the office. Split with backend on server in mdb format. I am now using both 2003 and 2007... BUT.. Now that the runtime is out I would like to make my future updates in 2007. So the question is... Has anyone used a 2007 file format frontend with a 2000 to 2003 file format backend? I understand that the new field properties wouldn't be available in the mdb backend, but besides that, would they still link properly?Thanks
View 1 Replies View RelatedHello all
I have a "Read only" frontend and Backend as 2 different files on the LAN shared drive.
i have around 50 users logging on to this to view information (No editing allowed by the user).
I read on some of the previous forums that Multiuser frontend does not work that well. I want to know if this is true even if my users are in read only mode??? I have tried with 3 users and it works with out a hitch. i just want to be sure before i roll out this to the entire 50users.
thanks
soni
Hi people,
Does anyone knows the difference between frontend and backend database? I look 4ward to hearing from any database expert.
black85
I created a database a few years ago and it has been working well. This database is split.
Recently I started to update the front end based on user feedback and I am adding some queries.
I am noticing that sometimes I try to create a new query and Access tells me that the tables that are involved in the query are not related. Sure enough if I check in the front end, the table relationships are not the same as those in the back end and while the table relationships I need exist in the back end, they do not in the front end.
While the relationships were initially created in the unsplit database, it is possible that I added some of them later during past development/updating processes when the database was already split. This is the only reason I can think of for them to be different.
When I add a relationship in the back end (new table or bug fix) do I also need to add it to the front end if the database is split? if not, why would they be different? What kind of issues can this create?
I have a database that I have developed on my computer that works well. This database is split and has a number of pie charts and listboxes in a couple of different forms based on data from the back end. This data is basically showing statistics, such as number of customers, type of customers and % of customers with issues. The pie charts show up correctly on my computer.
When I copy the back end on a server and the front end on another computer and link them together then the pie charts do not show up (image 1). The listboxes, which use the same data show up just fine, but the pie chart area is simply a grey box. If I double-click on this box then I can see the chart in a sort of "edit mode?" (image 2) meaning the chart shows up on the screen with a small data sheet underneath. Oddly enough the data in this sheet can actually be edited! which I do not know what effects it may have on the actual data.