We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a normal GSM connection.
The employees that will be using this also use an access database that I've created though. Whilst it isn't crucial that they can use this while they're out and about, it might be useful and it's something I am interested in looking into. In order to make it feasible though, I think I would probably need to dramatically reduce the amount of data transferred between the be and fe due to the high cost of data over GPRS (as well as the speed). So I have a few questions.
1) Am I right in thinking that if I am using ms access as a backend, all the processing is done at the front end? i.e. I run a query on the front end, the whole table is retrieved from the back end and then filtered at the front end?
2) Is there any way to get around this? Or would it require switching the back end to SQL Server or something?
3) Is there any way of measuring how much data (in bytes, kb etc) is being transferred between the front end and back end while running queries, updating records etc.?
I'll probably think of some more questions but this will do for starters. :)
I've been told numerous times that a shared database should have each user with their own FE. I've also seen in a number of places that the FE should be on the user's local machine. Is the FE on the local machine to limit network traffic only, or is there a greater reason for it?
I was under the assumption that the seperate FE's were to lower the probability of corruptions and sharing of local temp files... If this is the case, is it reasonable enough to have each user have their own FE in their own user folder on the network?
I have a table in which i have fields that have numbers with a huge number of digits after the decimal. i.e 10.2356491876545.... when i change the properties of the field to show only two digits. it does display two digits but the number is still stored in its original format. Is there anway i can chop off the unwanted digits forever so that they are not stored in the table anymore.
I am new to access and databases. I have taken on the job of creating a new one form scratch for my company. We are an advertising company and want a system to log, track and search all jobs that go through our traffic and production departments.
I have attached the basic plan for what I think we will need. Can anyone have a look at this and tell me if it looks ok or am I going in the wrong direction. The database will record many different job types with each having unique information in it. I was thinking of splitting these job types in to separate tables but always looking up a value JobsID in the jobs table in order to provide a unique number. And would it be or how would ii go about linking jobs with each other? So one JobID may have more than one job type linked to it ?
Sorry if I have not explained this well but I am trying to learn as I go along.
Наверняка ниже должна быть масса профессиональных терминов: про регистрацию в каталогах, поисковую оптимизацию, релевантность запросов, целевую аудиторию, продвижение бизнеса в сети, результаты поиска, исследования поисковых систем...
По идее текст должен содержать: Узнаваемость сайта, стратегии интернет маркетинга, контекстная интернет реклама и пр.
Документов должно быть много. Статьи по темам, помощь в раскрутке, советы профессионалов и прочее, что может быть полезно начинающему веб-мастеру самому освоить "науку раскрутки" (а фигли, мы ж не жадные ;) ). Обязательно по всему тексту должны быть расставлены ссылки на самых "вкусных" словах:
Регистрация сайта в поисковиках и каталогах
Уверен, будет текст, призванный окончательно убедить клиента сразу оплатить услугу и получить гору клиентов. Примерно такой: Мы обладаем огромным опытом в оптимизации сайтов, ведьу нас работают только признанные специалисты интернет маркетинга и рекламы. Используйте опыт специалистов в области оптимизации сайтов, знающих свое дело.
Ну вот примерно так. Представили? А теперь к делу! оптимизация сайта (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) оптимизация сайта (http://www.mulka.ru) оптимизация (http://www.mulka.ru) интернет реклама (http://www.mulka.ru) создание сайтов (http://www.mulka.ru) создание сайтов (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) раскрутка (http://www.mulka.ru) поисковое продвижение (http://www.mulka.ru)
When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.
How can I reduce the form size (so it looks like an Excel form)?
I have set up a group of 3 buttons to select between on my form which works fine.
However I want this to be a bit more visual than it is so Id like to introduce a traffic light system which lights up RED ORANGE or GREEN depending on which one has been checked.
I am not too sure how I would go about achieving this, im not sure if you can import images and hide them or show them depending on the selection or if it requires something further.
I have a database that located on a network. I have several child replicas that only certain persons can access. The main database, everyone has all rights to. The child only the person allowed to have access has rights to. We keep getting the message that the database is already in use, when a second persontries to get into the database. Does anyone have any suggestions that might help?
I can't add it to the form's base query because when I do the query becomes un-updatable.
While I'm working on the form on my pc locally the field shows the correct value. However when I view it on my client's pc, where the data is on the server but everyone has a frontend, the field shows Error#.
Any ideas or is there a better way to show this calculated amount?
I have created a management DB which basically shows a high level overview of our Call Logging system. This is basically a split DB (FE on users machine and BE on Network). In th FE there are also a couple of ODBC Linked tables from the main DB.
Everything is working fine with this but periodically there seems to be a Network Blip which causes numerous error messages 'object not set' and Disk or Network Error.
I appreciate that this is probably due to the Network experiencing a tiny blip but it kills my DB.
Is there any way to either automatically reconnect the DB or alternatively close the DB cleanly without all the error messages.
I have two pc,s hooked up as a workgroup network( no server) I have a database on one of the pc,s and when I open the database in the other pc it says that it is "read only". So I cant enter new records.
is there any way to use a same database in a network that if i entered some entery and some body else entered another entery it will show all data entered by every people in everyone's computer ?!
For the past several years I have been designing and building Access databases. They are designed for small evironments to be used on one machine only. I am now faced with a situation where my client would like to have his database placed on his network server so it can be accessed by several computers. This is a little outside my area of expertise. I have searched the forum but I keep coming up with references to front end and back end and other things I don't understand. Can someone point me in the right direction to search for: what should be on the netword and what should be in the computer. what changes should I make to the database stand-alone vs. network. what unexpected problems should I expect.
Or perhaps you could suggest a book I could buy to assist me.
This post is really aimed at someone that has experience of network databases and the problems they can pose but if you can help at all that would be great!
I work for an insurance company and we have created a database for registering complaints on. The one we currently use is a single .mdb file which can be shared by up to 60 people at any one time. This is creating a lot of problems when the queries and some VBA code are run. I therefore made a server file which is just an mdb file with data tables in and NO forms or queries. This file is stored on a shared drive on the network server. We then created a client file which contains all of the forms and queries and code. This file contains linked tables to the server so when data is entered into the form, it "Sends" it to the server mdb file. The client is installed on each of the local machines c:. The problem with this was that if we made a change to the database, we would need to reinstall the client on every single user pc. This would of took ages. I therefore made an auto-update function that checked the version number on the server and if the server number was greater than the client number, a simple .bat fiile was run which copied the updated client file from the network to the relevant users local disk. The problem we have now is that our IT department are concered that if we make a change to the client and all the staff log in at 9am for example, it will start doing multiple copying of a file around 8mb in size to around 60 machines. They are only running on a 2meg pipe so this could cause some problems. We are not looking to change the client & server idea but does anyone know if this will have a big impact and infact if the updates for 60 machine is the equivalent or lesser of 60 people sharing the single file i mentioned earlier. If the IT dept are happy with 60 users accessing the same file at the same time, which they currently are, why are they unhappy with it updating these machine using the new method.
Would really apopreciate any thoughts anyone has..
I have searched for help on this forum and all over for a while but cannot find the help i need.
I have a database stored in my user area on a schools network. Other users around the school access the database by clicking on a shortcut to it found on their start menu. The database is not split with a fe/be and usernames and passwords are not required to log on, they simply click the link.
I would like to know how I can find out which users have the database open at any given time? I have a piece of software that tells me the computer name but that is no use, I need the users name. Is there a way of pulling this from the network because each user must first log on to their computer using their name and password before they can access the database?
I have a small access database that my users keep open all day long. Access 2000.
I have one primary version of the DB on the network. No one uses it. I have another file on the network that has linked tables to the primary db. I copy a version of this DB to each workstation.
So each user has a full blown DB on their desktop with linked tables back to the main DB. Is this a good set up or are there any issues doing this? What is the best set up for multiple users across the network? Thanks.
I'm making a version of my dba using the upsizing wizard, then i'm packinging it to distribute it as a runtime version and save the data on sql server
But i'd like to be able to keep track of who is adding what to the database. How can I check who added what data? from which station? how can I monitor things in that setting?
Also if 2 users open the same form I'd like to restrict the second user, and have a window poping up telling him/her "you cannot add data to this table until user#123 is done with that table" a little bit like quickbooks does.
This might sound like a stupid question but I'm just trying to work through it in my head and I don't want to miss something, so a couple of new pairs of eyes might just clarify.
I've created a call monitoring database for a call centre and I have split this so that they have a front end and a back end as per someones instructions. They have done the normal thing in as much as just putting a shortcut on everyone's computer so that they are all trying to access the one front end instead of putting a copy of it on everyone's machine. I've got a feeling they are going to ask me to go in and put it right, so when they have put a copy on everyone's machine will that automatically link to the back end or do new links have to be made, if so how would I/they do this? - is it done from each computer?
I don't really know, I'm just assuming that's what needs to be done but I don't want to tell an IT team that what to do if it's not.
I've only ever set up a sharing database once before and that was built on the company network and I set it up on each computer in the department, but they weren't doing data entry it was only for interrogation purposes and it was a few years ago now so I'm rusty, but I do remember it took me a long time to do.
I have a db on a network drive and the performance is terrible, it runs fine on my local machine. How can I make it run better? The db is only 2 megs so I figured it would be ok, but since my forms have numerous queries within them, performance stinks.
Hi, I've been developing a database 900k records so far, and with the DB installed on my local machine my queries that I use for my reports work pretty good. They will open in under 10 seconds.
but now that I've about done with the DB, I've moved it to the network, and now those same queries are taking forever to run some over a minute to open!!
Here is an example of one of the queries
SELECT q_complete_list_IIR_2Apt1.Main_ID, q_complete_list_IIR_2Apt1.Code, q_complete_list_IIR_2Apt1.Code_Description, q_complete_list_IIR_2Apt1.Display_text, q_complete_list_IIR_2Apt1.Static_Text, q_complete_list_IIR_2Apt1.Effective_Start_Date, q_complete_list_IIR_2Apt1.Effective_End_Date, tbl_IIR_description.IIR_code, tbl_IIR_description.IIR_description FROM q_complete_list_IIR_2Apt1 LEFT JOIN tbl_IIR_description ON q_complete_list_IIR_2Apt1.Information = tbl_IIR_description.IIR_ID WHERE (((q_complete_list_IIR_2Apt1.Effective_Start_Date)<=[Forms]![frm_report_screen]![txt_date_completelist]) AND ((q_complete_list_IIR_2Apt1.Effective_End_Date)>=[Forms]![frm_report_screen]![txt_date_completelist]));
I've already tried to compact/repair the database, and that brings the overall file size down, but really doesn't help these queries at all.
I thought at first, that maybe since I don't need to look at 'all' records, that I could maybe do a prefilter. So I created another query, to get only certain records, and then used that in the first query. But that actually made it even more slow. I guess it's because this new query, still has to look at the main table to start with, so it really just made another step in the process.
Everything (almost) is ready to go live on my database. My problem now is that when I put the DB out on the network, and went to someone elses pc station, to enter data, it saved the changes there at her station but not back out on the network. WHY? Am I missing some setting in my DB somewhere? Please help?
The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.
The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.
They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's
I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.
In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?
I've got a back end database on one of my computers and i'm trying to get the link tables to work over a network from another computer. Ive set the link tables up but it wont let me edit any data because it is read only. Its not read only when i run the front end from the computer that stores the back end. How do i enable the front end to edit the data over the network?
also, it is a multi-user system so i want multiple front end parts accessing the one back end but whenever i try and access the data from one system when another is already open it says the file is in use and i can't do anything!
I'm really stuck at the moment and i really need some help please! :confused:
I have a access application which is split into 2 bits with the backend being on the network. The thing is its very slow performance wise and i want to try and optimise it...
