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.
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?
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 RelatedHiI 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?
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.
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.
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
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!
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 RelatedI 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?
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.
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
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 RelatedDoes 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 RelatedHi 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
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.
Does anybody knows how I can have an access database in the internet?
Please let me know.
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?
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.
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.
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.
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
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
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