I have developed an application for a friend. We live about 100 miles apart in the UK. The database (Access 2007) works perfectly for us, I input data from various sources and he views the reports I've designed that show him exactly what he wants to see.
Now I want to move to the next phase which is I enter data from my PC at home and he then views the reports on his PC at his home.
Any advice on how I can do this, at low cost,
I've just split a database into the front-end and back end components. But how to distribute it further.
Additionally, I need people who have the front end to access the database from their homes, not just from work.
What would I need to use?
Is there anything available for free?
I am making a database to coordinate the activities of my band (how rock and roll!)...
Is there a way I can somehow host the file remotely, and have users (4 total) access that file through their own computer using access, so they can write, edit, delete records?
We have a db at my work that we use like this, accessing from multiple computers, though this is on a network drive.
I created an access database for the sole purpose of sharing approved data with my entire company. The end users will view the data in a Form which utilizes several tabs and also gives them the ability to run pre-set queries out of the Form. The Form was created using several queries which were built from tables off of the server.
The tables update every day, as does the information in my Form. The problem I am running into is that it takes about 2 minutes to open the DB (the DB opens directly to the form and all queries run immediately to update), which is annoying to end users and might deter them from actually using the tool. I have tried moving the DB to SharePoint, but that did not work due to the size of many of the tables.
I just created a fix to an issue found in my database. I need to get this fix to several users in different locations. Does anyone know of a way that I can do that throught email without having to send the complete database?
My fix is meerly an addition of two item in a macro. The end users do not have permision to get into the main database, they only have user rights on a few forms.
Is there a way to create a macro that would, when executed on the remote PCs, delete the old macro and replace with one sent via email? If so, how would that macro be structured?
Any help form the experts would be appreciated.
Thanks,
Pioneer
We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband.
I have been trying to find out the best way to achieve this over IP as we do not want the considerabe expense of leased lines. Originally we tried VPN but access seems to be very slow and appears to prohibit that route.
We were advised by our PC support company for one branch to use Terminal Services. However we do not currently have a powerful enough server to support these. We have a price for a server upgrade and it seems OK. I have since been advised by the PC support company at another branch that because of the upload speed on broadband (256Kb) Terminal Services would not be sufficient especially if we were using HTTP and VoIP over the same connection.
Looking at the various posts on this site it would seem that VPN and TS are suitable for some. Is there an easy way of calculating whether or not TS will work at our site? Has anyone gone down this route and found it not to work?
I'd be grateful for any feedback.
Thanks.
Hi everyone, I'm just a newbie in DB programming and I'm having a trouble:
I have a database located in my IIS server: "c:inetpubwwwrootwebapplication1dbs1.mdb".
I'm also developing a VB6 app in another computer which will access to my IIS server to get data in my database. I'm using ADODB, but I don't know how to establish the connection as well as to get the data from the server (remote machine).
Can anyone in here help me by showing an example in VB6 code?
Thank you very much, any sugestion is welcome
Reply With Quote
I have a database on a server that is accessed by mobile clients using laptops (broadband)
when out of the office. They use'virtual private network service' to do this.
(I did not set this up, I just design and program the front and back ends)
However some report a slow response time when retieving data from the database file.
Would 'Active desktop' be any quicker?
Any suggestions on how they might speed things up, would be most welcome
'Replication' comes to mind but I think their data must remain up to date at all times.
I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.
View 3 Replies View RelatedHi,
I am doing some computer work for a company that has an Access 2000 application. This app is split up between a program database that contains the forms, reports, etc. and a data database. Both the program database and the data database are located on a Windows 2003 teminal server. There are usually two or three remote users logged into the terminal server, but this number is about to increase to 6 or 7. I am concerned that these user's will all be running the same copy of the program database. I have read that this can lead to performance problems.
I was wondering if anyone hear thought either of the following would be an improvement:
1. Put a separate copy of the program database in each user's profile on the terminal server.
2. Rather than keeping the program database on the terminal server, put a copy of it on each of the remote client pc's. Then set up a VPN connection to the server and use this to link to the data database.
If anyone could tell me if either of these options would lead to improved performance, I would really appreciate it.
Thanks in advance,
Paul
HiI currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to come into the office.From my research, it seems I can setup Remote Desktop to connect from the client's home PC directly to the server PC, across the internet, using Windows XP Professional on both computers. Is it that simple, or should I be considering other things?
View 5 Replies View RelatedGood evening,
my web site (in hosting) stores data in a SQL Server database.
Now, I've and import these data in an Access application and, of course, I've no direct access to SQL Server instance.
I thought about using Web Services. Does anybody know how to do, or has an alternate way?
I have a database on a remote computer that has several reports that can be generated. Is there anyway to create a PDF of one of those reports and download it to my main computer?
View 4 Replies View RelatedHi,
I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website?
If so can you give me some quick steps to do so or a good article on it?
Thanks.
I have an access database that I used to be able to share between 5 different people (we were all able to input data at the same time) Something has changed and now only one person can get in to work on it at a time. If someone else tries it tells them that it can't find the database. Has anyone seen this before and if so what's the fix. Any help would be greatly appreciated.
View 2 Replies View RelatedGoal
I'm trying to trying to setup a MS Access database on a shared server drive where all of the main tables are linked via ODBC into an SQL database. The SQL database is updated and maintained via purchased application. It appeared that MS Access security could be used to control the type of access each user has. Most of these users will have read only access for reporting purposes since the main application is used to update and maintain the data.
What I've done.
1) I've setup ODBC Access for each user. Not sure if this should be User, System or File DSN. They all work and I can't tell at this point that it makes a difference.
2) Created the MS Access Database, created users and assigned security.
3) Linked the needed tables.
Problem
1) When I had a user try to access a table it said "Table definitions not defined". What I then realized is that the MS Access on there machine was picking up their default security. A security Table and a shortcut (.mdb1 file) that pointed to the correct security and table definitions.
2) Now when the user gets in everything seems to come up fine but when they try to go into a table they get an error saying they don't have permissions. If I relink while they have it open, they can get into the table just fine. However, they can't delete the old tables because they have 'Read only' access. I don't really want to have to relink all the tables for each user, I might as well to go to each of their machines and set them up individually...not a good idea.
What now?
This seems like something that should be fairly easy to do..what am I missing?
hi everyone,
i have designed a simple database which need to be accessed by 3 different people(number likely to increase) located in different towns.what do i need to do especially from a technical point of view.
Thanking you in advance.
I have a multiple user situation, the db is Access 2000, all works well then last week the IT technitian upgrades one computer to Access 2003.
The db is hosted on this PC and shared to other users, now multiple access to the db is no longer possible. I request that the db be moved to another PC with office 2000. Now all the users can share the db simultaneously but not the 2003 PC.
The OS (WIN XP) shares are set right, and the db itself is shared.
Any help will be appreciated
OK, I have spent the best part of a week trying to sort this out, so if anyone can shed any light on it, I would be very very grateful.
I have created a database in Access 2007, which I wish to share with my collegues. We all are running Vista, and access 2007, over a peer to peer network.
I have installed a Front End on each Computer and linking to one copy of the backend on the host computer in the public drive.
The system runs great on each PC, however, I am having a problem sharing the database. All users can log onto the database at the same time.
However, when one user enters a form, it locks access to the form for other users, it just hangs until the other user exits the form, then the user that was hanging goes directly into the form. I get no error message.
I have tried linking the form to a query rather than directly to a table, but no joy with that either, the form still allows only one user.
I am not sure if this is an exclusive permissions problem and I need to change the Windows security settings or something else.
Like I say, if anyone can help, it would be really appreciated. :D
I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to any help would be greatly appreciated.
I have attached the asp file, I can upload all files and database to a server if someone requires them (too big for the forum).
Thanks,
Richard
I am running a small access database over a wireless network which all worked fine (still does on 1 wired/3 wireless) with not too many problems total of 6 machines (5 wireless/1 wired). I have just replaced two machine as they were getting a bit old 3years. But these two new machines do not seem to have full rights to the access database, in that I can open the database and view records but when you add data you get a Disk Error message. I can open and share word documents etc but not the database – if I reverse this set-up I get the same problem the wired computer can open and save word documents but again not the database - what am I missing!!!
SET-UP = All machines have Windows XP Pro and Office 2003 with all windows/office updates done, all connected to the same workgroup etc. Two new machines are Dell with Dell Wireless adapter. No server just workgroup and database in a shared folder on one computer which is hard wired to the Netgear wireless router. I have not run any network wizards and I don’t think I need to, just sharing the folder should be enough? Windows is managing the dell wireless adapters, file and print sharing is enabled, other computers can print to this computer, but I just can’t get the database to share correctly – I have also checked “References” and all looks fine.
I have created the time booking application in access. (Application will alow autherised user to enter daily work done) My Idea was to put this file on the server and ask each employee to log in and enter information. But whenever I try to run application from other than my pc(On which file is created) it flashes error and can't run some of the form. It works absolutely fine when run from my pc. Why this hapens? What is the solution for this? Can access application is sharebale over network?
View 10 Replies View RelatedI have created multi user access application. I have kept it on server and all users access that application from there desktop pc. Can I set time out for application? Means, Session of each user must be note more than 10 minutes. I want to add this functionality for avoiding the application blocking.
View 2 Replies View RelatedI want to deploy an access database at a small office with 5 computers, small network. However I do not intend to create a server in order to have a domain etc. Operating system is win 8.1 pro. Should I use a homegroup or workgroup ? Would it require password in case of workgroup? Which is a recommended way to setup this and keep some security like a guest cant access these files?
View 14 Replies View RelatedI searched and doesn't seem to find anything about that question.
I am aware that there are forms that help with building dynamic queries for end users who need to juggle their data, but wondered if allowing them to access QBE would make everything easier (why reinvent the wheel?), and whether it is possible to restrict QBE from doing action queries or using dynaset to restrict end users from updating via queries which may circumvent the rules written in forms for the given data.
Have anyone had designed database with users having access to QBE? If not, how do you provide as much functionality without practically having to re-invent the wheel?
Thanks.
I've been looking around and it seems to be impossible to connect to an mdb file on an ftp (for Access 2002 and below). I'm using Access 2003 so does anyone know if it's possible in this version?
View 3 Replies View Related