Remote Link To Internet Server?

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 Replies


ADVERTISEMENT

Link To Sql Server Tables On Internet

Jun 14, 2007

I would like to use a local Access front end to edit tables linked to a SQL Server database located on my Internet host provider's server. I haven't been able to find any information about how to do this or whether it is even possible.

If I need to set up an ODBC source, how can I do that for a non-local (Internet) SQL Server database?

Can anyone help?

View 1 Replies View Related

Remote Access To Database On Server

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

Remote Deskptop Connection To Access DB On Server

Apr 10, 2007

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 Related

How To Get Data In Access Table From A Remote SQL Server

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

Connect An Access Project With A Remote MDB Or SQL Server Database

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

Hosting The Access File On A Server And Having Multiple Remote Users

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

Link Tables To SQL Server

Nov 27, 2007

Hi,

I have build system DSN for SQL Server.I want to link table to the DSN.

But I can not select the DSN when I start the 'lined table Manager",I only can select files.why?

Please let me know how to link table to system DSN.

Thanks

Mark

View 1 Replies View Related

Link To Tables On Server From Local Machine

Oct 10, 2004

Hi,

I'm trying to establish the link from my local mdb to an mdb on a commercial server I'm using.

The problem is there's no way to locate the remote access database when using the Link Table wizard.

Anyone knows how to establish that connection??

Thanks in advance!

View 2 Replies View Related

Mdb On Remote FTP

Jul 11, 2006

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

Db On Internet

Jun 7, 2006

I have a database which is being used for maintaining documents status. Its working fine in stand alone PC. I want to share it on internet. But problem is, I can upload the complete file, then download and use. Its not updated.
So is there any way to upload this db onto internet and work there only the way we do in single PC?

View 2 Replies View Related

Remote Access

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

Internet Database?

Jan 3, 2006

Hey, I am currently designing a database for my group of friends. Things such as ,Name, Age, Musical Instrument, Band (of which they play in), Favourite Band etc. would be in there indefinately.Its not a complex Db and so I was hoping to put it on my website but dont know how i would do this...I would like it to be on the internet as if you were just looking at it on your own computer and webmaster could edit any fields after it is finished. Is there anyway of doing this? If yes is there any way of doing this without the viewer having to download the Db?

Regards, Tommo

View 10 Replies View Related

Getting Access On To The Internet??

Mar 14, 2008

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to run the reports off control buttons /macros of the forms view not see the tables or query design. Any suggestions of best to approach this, Also any input about "project" or "ADP" woud, be very useful, thanks Andy

View 1 Replies View Related

Sending A Mdb File Via The Internet

Jul 27, 2005

Does anyone know what's the best way to send a mdb file via the internet. I've tried sending is as an email attachment and putting is on a webserver for downloading. Both wayes only gives errors.

View 1 Replies View Related

Creating Unique Id On Remote Pc

Aug 21, 2005

Hi all,

Got my job database going quite well, at the moment, it generates a job number form the first 4 letters of the customers name, and the ID (autonumber), so for example mr smith's job number would be SMIT0012 (assuming the 12th entry in the database)
Now this works fine, tables are linked and the database access the tables via a mapped network drive for other pc's (2) to use. But the problem is, if the database user were to be at a remote location with a laptop, how could this work? I could use a local copy of the tables but then of course the ID's wouldnt match! Can anyone offer any ideas on this?

Thanks

View 3 Replies View Related

Remote Access Through ADODB

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

Speed Up Remote Access

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

Access Database In The Internet

Mar 21, 2007

Does anybody knows how I can have an access database in the internet?

Please let me know.

View 1 Replies View Related

Internet Synchronization Error

May 23, 2007

I have an Access 2002 database (about 120mb) which was replicated using Replication Manager (version unknown). It is set up to use Internet Synchronization. We use it on state government LAN and WAN as well as the Internet. It works well in most cases, but on a few computers we get the error "Http address not found" when synchronization is attempted. The address is indeed visible to those computers. We have determined that reloading Windows (XP Pro) will usually solve the problem at least for a while but when GIS mapping software is installed it reappears. More worrisome is that some brand new laptops with factory-installed Windows are showing the same problem, which means it could get worse as we upgrade equipment.

Has anyone else encountered this error?

View 5 Replies View Related

Secure ODBC Over Internet

Apr 11, 2008

Hello All,

I was wondering if it is possible to connect a MS Access front end to a MS SQL server on the internet in a secure way through ODBC or some other means.
Anyone have any ideas?

Thanks.

View 1 Replies View Related

Set Linked Tables On Remote PC

Nov 6, 2007

I have an Access database which we inherited and it has linked tables (2 database files, one with data tables and one with forms, queries etc) - the links being set to a path on our local company server. We are in the process of opening another company office in another part of the country and we want to use the same database system. I have taken a copy of the database, cleaned out all the existing data out and now need to send the blank database to the new office. Is there a way of forcing the database to reset its table links when it runs in the new location (or pre-defining the paths before it is installed)...rather than my physically having to go to the new office to use the Link Manager when in situ.
I wondered in fact whether was a way of holding the required path statement in one of the tables so that the links could be easily reset on any future installation. I do not know how to code anything like this or set it up - I am new to Access databases
Could anyone advise please.

View 2 Replies View Related

Local Query - Remote Db.

Oct 10, 2005

Ladies and Gentlemen,
I'm sure you gurus have an answer for me.

I have a MDB (MS Access 97 db) on a shared drive. All my data resides here.
I have a local MDB (MS Access XP db) on my hard disk. Currently, I have queries located on the shared MDB that puts out a table. I then execute queries on my local DB, linking to the table I have on the shared db.

My requirement is this.
1. I want to be able to run queries against the shared db from the local db.
2. When the create table query is run, I would like it to create the table in the local db. I can live with creating the table in the shared db, but local would be better.

I'm sure that this can be done. I've seen it. But, that has always been a client/server system.

Thank you.

View 1 Replies View Related

Remote Close After Countdown?

Oct 13, 2004

I have two databases; a server and a client. The server houses all of the tables, while the client has the tables linked and serves primarily as a form for users to enter data to the main table. Periodically I update the form, so I would like to be able to shut down each client while I upload the new files to update the client. Here is my thinking:

I have a table in server.mdb called admin with 3 columns and one record.

The fields are:

closex (text) - This will be populated when I want to send the close countdown command.
message (text) - The string I want to display in a warning popup box.
Timer (integer) - The time in seconds before the program will close.

Right now I have a hidden LIST box in the form (closemsg) that is bound to column 1 and column count=3.

Me.closemsg.column(0) is closex
Me.closemsg.column(1) is message
Me.closemsg.column(2) is timer

The box is requeryed every 2 seconds to check and see if the table has been updated along with another line of code that keeps the time current until someone starts to enter a record.

I have a macro that will perform the close operation. Here is the code I have thus far....any help would be greatly appreciated.

___________________________________________

Private Sub Form_Timer()

'Updates the Time to Current
If (IsNull(Agent)) Then

Me!Call_Time = Time()

End If

'Checks for updated values in Admin Table
Me.closemsg.Requery

' -------------
'| Force Close |
' -------------

'Message Variable from T.Admin
Dim message As String
'Timer Variable from T.Admin
Dim timer As Integer

'Macro Variable to Close App
Dim macroname As String

macroname = "Closeapp"

'Check to see if T.Admin has changed
If (IsNull(Me.closemsg.Column(0))) Then

Else

message = Me.closemsg.Column(1)
timer = Me.closemsg.Column(2)

'Set Timer
timer = timer * 1000
'Notify User
MsgBox message

Count:

timer = timer - 1

If timer > 0 Then

GoTo Count

Else

DoCmd.RunMacro macroname

End If

End If

End Sub

View 5 Replies View Related

Navigation Remote Issues

Jan 9, 2005

So im starting to have a lot of the same buttons to search and go threw records in in diffrent forms.

Ifigure to save space i can make ,or a form that cotains all the buttons or a personalized menu bar on top with access.
But i rather have it on a form,
First things first i am having a lot of trouble with the mos t basic part of it all. i cannot seem to control the simplest
GoToRecord , , AcNext


I have an error that always says you cannot go to that record.
i have an open form called "Calls"

Forms("calls").form.apllication.docmd.gotoRecord , , AcNext 'is the buttons on_click event.


And i figure with a combo box on the navigation window i can add witch form i should be controling Like a tv remote that has vcd, tv , dvd. but i cant even get the simplest thing working any addvise would be apreiciated.
Mark

View 2 Replies View Related

Transfer Data Over The Internet

Mar 28, 2005

Is it possible to transfer data over the internet if the BE is in one country and the FE is in another? If so, could someone explain how I would go about doing this? I'm in the Military and when we deploy it's normally to a far off country.

Thanks,
Scott

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved