Remote Deskptop Connection To Access DB On Server
Apr 10, 2007
Hi
I 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 Replies
ADVERTISEMENT
Sep 23, 2005
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 Related
Jun 10, 2007
Good 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?
View 1 Replies
View Related
Jan 28, 2007
Hi,
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.
View 6 Replies
View Related
Jun 4, 2007
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.
View 2 Replies
View Related
Jun 17, 2006
Hi :
I have a question of the connection between SQL Server and MS Access.
I have a project, which is using SQL Server as backend, we use MS Access forms as the frontend.
Firstly, I created the datbase (db1) in the SQL Server, and create a few tables in db1. And then, I create a few forms in the MS Access, I used ODBC connection to link tables from SQL Server to MS Access, it is working fine. Those forms can access the linked tables.
After it is done, I put the MS Access database in the sharing drive, many people can share the files in this sharing drive.
When I go to my associate's computer, and then open the MS Access database in the sharing drive. The forms is working, but, it cannot access to linked tables from SQL Server.
I go back my computer again and then open the MS Access database, it is working fine.
What's the problem with it?
Does anybody need to install SQL Server software and also have db1 database in SQL Server and the path?
I want any user can access the linked tables from SQL Server, but I do NOT want any user can open the SQL Server and open the tables directly. I just want the users can access the linked tables through MS Access Forms only. Because I will make security in the MS Access. So, I don't let the users modify/open the tables in the MS Access, the users must access the tables via the forms only.
Please tell me the steps how to solve it.
Please help.
Thanks.
View 5 Replies
View Related
Aug 30, 2013
I am trying to put together a vba adodb connection string to a remote server. It is the first time I am using adodb in this context. I can get msysobj.connect but how do I format that information into a connection object connection string?
View 3 Replies
View Related
Oct 23, 2004
Hi all,
Is it possible to make a backend/frontend access system and putting the backend on a remote internet server.
E.g. http://www.mysite.com/database/backend.mdb
Because when I try this I keep on getting a message "Not a valid file name."
Any suggestions apart from RTFM?
Thanks,
Bud.
View 2 Replies
View Related
Jan 30, 2007
Hi all,
I have an .adp that works fine on a number of people's laptops.
One of the users however, keeps getting an error message stating that SQL Server does not exist or access has been denied.
This particular user is definitely setup on SQL Server with dbo permissions. She can also ping the server.
I have tried creating a DSN and this doesn't work either.
I am at a loss as to why this error message is occurring given that she can see the Server and has definitely been setup.
Do you have any suggestions?
Thanks,
Kabir
View 1 Replies
View Related
Oct 8, 2013
In the code below I want to wait for ten seconds if there is connection to the server, if not to exit the sub with message "No connection to server". How to check it
Dim req As New XMLHTTP60
Dim resp As New DOMDocument60
Dim xmlNodeList As IXMLDOMNodeList
Dim myNode As IXMLDOMNode
Dim xmlNode As IXMLDOMNode
Dim presription As IXMLDOMNode
req.Open "GET", "https://api.zdravstvo.gov.mk/rest/prescriptions/" & Me.br_recept, False
req.send
resp.LoadXML req.responseText
View 2 Replies
View Related
Aug 30, 2005
Hello again,
I have a MS Access project that uses a SQL Server connection to retrieve data. It is set up to authenticate the user every time the database is used, which is what I want it to to.
The problem is the timing of the dialog. In 'design mode', Access tries to show the Database window as soon as the file is loaded, realizes that it has to fetch data from the SQL connection, and prompts the user for the password - this is fine. However, the 'release version' has a different setup. Automatic showing of the database window is disabled, and the user controls the app via a customized menu instead. The result is that Access only prompts the user for his SQL Server credentials when a form is opened - this isn't OK. I would like Access to always ask for a SQL logon when the file is opened, even in 'release' mode.
I'm kinda new to using Access and SQL Server together, but I suppose there is some way of programatically invoking the dialog via a macro, right ? If so, what function should I use, and how do I make a macro that is run immediately after opening the file ?
It would also be nice if there was some way of detecting a successful logon, so that it can reinvoke the dialog indefinitely if logon fails.
Thanks for everything :)
View 1 Replies
View Related
Apr 8, 2014
How I can check if connection to SQL server is established with VBA before the SQL is executed. btw I use VPN connection to connect to sql server, and some times VPN connection is going down in middle of work and it is quite unconvinced.
View 2 Replies
View Related
May 18, 2005
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.
View 2 Replies
View Related
Nov 8, 2005
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
View 3 Replies
View Related
Oct 4, 2006
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.
View 3 Replies
View Related
Jul 29, 2007
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,
View 2 Replies
View Related
Feb 20, 2008
Hi,
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
View 2 Replies
View Related
Jul 15, 2015
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 Related
Aug 4, 2013
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?
View 3 Replies
View Related
Sep 26, 2005
Dear Guys,
How to Establish the connection between Ms-Access2000 & Oracle using DAO Connection through Code?.
I created one table in Oracle and I created User-DSN in ODBC.
I linked that oracle table into Ms-Access MDB using Link table option in ms-Access.
Now, Whenever I open that mdb, we need to establish the ODBC connectivity automatically through code (I mean, we need to refresh automatically).
I need to hardcode all the information in the Ms-Access code.
My User DSN Name: abcd
Oracle Database Name: abcd
Schema Name(User Name): abcd
password: abcd
View 1 Replies
View Related
Mar 25, 2005
I have a website writen in ASP and connected to Microsoft Access.. Why several people is telling me they couldn't find my website, it's not working. But they didn't tell me what is the error are they getting..
I get about 50 hits daily. Could Access handle this type of job?
View 2 Replies
View Related
Dec 5, 2003
Hello all,
It's the first time I use VB.NET. I already use VB to connect to an Access database with ADO objects.
But now, I don't know what should I use and how.
For now, I have try OleDbConnection object with the Provider Microsoft Jet OLEDB 4.0
but when I connect to my database, I have the error following:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
.....
Line 54: OleDbConnection1.Open()
......"
If you have any idea, please tell me
Lord
View 2 Replies
View Related
Apr 4, 2008
hi everyone,
i have an access file (access 2003) in my root folder. an ASP page where i select the records from the access database table. in this page all are working perfect. my asp code:
ASP Code: Original - ASP Code <%Dim adoConDim rsGuestbookDim strSQLSet adoCon = Server.CreateObject("ADODB.Connection")adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb")Set rsGuestbook = Server.CreateObject("ADODB.Recordset")strSQL = "SELECT * FROM table_name ORDER by user_id;"rsGuestbook.Open strSQL, adoCon%><table bgcolor="#ffffff"><%Do While not rsGuestbook.EOF%><tr> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("user_id"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("email"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("city"))%></a></td></tr><%rsGuestbook.MoveNextLooprsGuestbook.CloseSet rsGuestbook = NothingSet adoCon = Nothing%></table> <%Dim adoConDim rsGuestbookDim strSQL Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb") Set rsGuestbook = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM table_name ORDER by user_id;" rsGuestbook.Open strSQL, adoCon%> <table bgcolor="#ffffff"><%Do While not rsGuestbook.EOF%><tr> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("user_id"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("email"))%></a></td> <td><a href="somepage.asp?user_id=<%Response.Write (rsGuestbook("user_id"))%>"><%Response.Write (rsGuestbook("city"))%></a></td></tr><%rsGuestbook.MoveNextLooprsGuestbook.CloseSet rsGuestbook = NothingSet adoCon = Nothing%></table>
when i click one of the links to view the details of each record, the page displays this error:
Quote: ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/some_page.asp, line 0
this is the code of my page:
ASP Code: Original - ASP Code <%Dim adoConDim rsGuestbookDim strSQLDim user_iduser_id = CLng(Request.Form("user_id"))Set adoCon = Server.CreateObject("ADODB.Connection")adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb")Set rsGuestbook = Server.CreateObject("ADODB.Recordset")strSQL = "SELECT * FROM table_name WHERE user_id=" & user_idrsGuestbook.Open strSQL, adoCon%><table width="300"><tr> <td>UserID:</td> <td><%Response.Write (rsGuestbook("user_id"))%></td></tr><tr> <td>E-mail:</td> <td><%Response.Write (rsGuestbook("email"))%></td></tr><tr> <td>Telephone:</td> <td><%Response.Write (rsGuestbook("telephone"))%></td></tr><tr> <td>Fax:</td> <td><%Response.Write (rsGuestbook("fax"))%></td></tr></table> <%Dim adoConDim rsGuestbookDim strSQLDim user_id user_id = CLng(Request.Form("user_id")) Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("testdb.mdb") Set rsGuestbook = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM table_name WHERE user_id=" & user_id rsGuestbook.Open strSQL, adoCon%> <table width="300"><tr> <td>UserID:</td> <td><%Response.Write (rsGuestbook("user_id"))%></td></tr><tr> <td>E-mail:</td> <td><%Response.Write (rsGuestbook("email"))%></td></tr><tr> <td>Telephone:</td> <td><%Response.Write (rsGuestbook("telephone"))%></td></tr><tr> <td>Fax:</td> <td><%Response.Write (rsGuestbook("fax"))%></td></tr></table>
any idea is acceptable.
thanks in advance
View 2 Replies
View Related
Sep 21, 2006
Hi, I am completely new to ASP. I have experience in other programming languages, but for my job I need to use ASP, sigh.
Anyways, just learning ASP I decided to try a free host to "get to grips" with it. It has been great for the first couple days, and am moving onto databases.
I have hit a snag where I upload a simple MS Access database to the host (7host.com) and try and connect to it. I have tried W3Schools, and numerous other tutorials but none of them seem to work
This is the kind of code I am trying:
Code:Set conn = server.createobject("adodb.connection")conn.connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=db1.mdb"conn.Open
Which comes up with this error:
Code:Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1238 Thread 0x10b0 DBC 0x267a024 Jet'./virtual/test.asp, line 16
Now, I really don't have a clue about ASP databases, so please be gentle ><
Thanks
virtual
View 2 Replies
View Related
May 9, 2013
I have a question about connection strings. Basically I have an access front end and an access back end. It works fine for now, but when it gets rolled out, I don't want to have to manually relink the tables every time. Is it possible to hard-code the database connection strings for all the tables used in the solution as the paths won't change once deployed?
View 4 Replies
View Related
Nov 9, 2006
I have an MS Access front-end with a SQL back-end database. It works great, I connect the MS Access front-end to the SQL back-end using a File DSN.
I have a few users (who are in the database the most) who get ODBC disconnection errors time to time. The cause of the error is not consistent, they seem to just appear out of no where. The table that reports the disconnection is not consistent either.
The only way for the users to resolve the errors is to exit the MS Access database, and then re-enter it.
I have had the DBA team analyze the SQL server, and it does not appear to be having any difficulties. We moved the database to another server (so it would be on a server with less traffic) and I rebuilt the File DSN. But the errors continue.
I will have the network team look into any errors, but I am not certain if they will find anything or not.
Has anyone run into this, and what resolutions did you come up with/work arounds did you perform? I am starting to consider upgrading to a Visual Basic .Net front-end, but wanted to see what options were left.
Thank you for your time.
T.J.
View 1 Replies
View Related