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 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?
I have a code which connects to sql server using DAO. I would like to know is that do my system require sql server native client installed to run this code? or what software needs to be installed to have this code works for me?
View 1 Replies View RelatedI 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 have adp projects that I connect to an SQL server that is remote. All worked fine until I had to do a windows repair. Now I open the project and it comes up as disonnected. It will not let me open any other box like connections. If I try that it says "Microsoft Access can not log on to server". If I try to start a new adp same message. I am the admin on my XP pro machine.
View 1 Replies View RelatedHi 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.
Hi there,
Thank you for this great site, and a special thanks to all persons here who are giving a big help to newbees as me.
here is my prob:
I have set up some few ASP pages using dreamweaver 8 in wich I put some forms to collect data from users (actually I'm recruting subjects for a scientific research) and teste them on my local host using IIS server and access 2000 database. all things work correctly. My strconnection in my local machin is as follow:
Code:<%' FileName="Connection_ado_conn_string.htm"' Type="ADO" ' DesigntimeType="ADO"' HTTP="true"' Catalog=""' Schema=""MM_connsujets_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:InetpubwwwrootSujetsRecdbRecruSujets .mdb; Persist Security Info=False"%>
I have found a site (http://www.asphost4free.com) wich host free asp pages. I uploaded my pages but the connection to the data base is no longer working. the host site give this sample of code to get to connect to the data base:
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
strConnection = "DRIVER=Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("/USERNAME/db/yourdatabase.mdb")
oConn.Open(strConnection)
....
...
oConn.Close
I have follwed it and I have changed the username and the database name with mine but I can't figure out what to put to replace the .... after oConn.open. I git error this error when I have tryed to connect:
Microsoft VBScript runtime error '800a01a8'
Object required: 'oConn'
/kin2006/Connections/connsujets.asp, line 11
I deleted the oconn but it doesn't help I have tryed many other combination without any success.
Any clue!!
thanks in advance
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?
Hi all
I'm making an Access front-end for an existing app based (I think) on SQL Server 2000. (The Access thing makes labels... the "label wizard" supplied with the SQL Server program isn't very good.)
I can use it fine, but eventually it's going to be used by non-techie people. As it uses linked tables, when you first run it you get a message box similar to this popping up:
http://www.rainjam.com/images/login.jpg
On some machines it tries to create a trusted connection automatically, and fails, and then gives you this box with "Use Trusted Connection" ticked - thus making it even harder for people to use.
Ideally I don't want anyone to have to bother with this. Is it possible to put something into the form's OnOpen event that passes the server, database, user & password details to SQL Server, so it all happens invisibly? I've already tried creating a file DSN on the machine it'll be used on (doesn't seem to do much) and also putting this code in:
Set objConn = New ADODB.Connection
objConn.ConnectionString = "Driver={SQL Server};Server=[server];Database=[db];Uid=[blah];Pwd=[blah];"
objConn.Open
(I must admit this was a bit of a stab in the dark... it didn't work anyway)
I also found this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=50449) and tried the code but it didn't seem to work (got one of those "You entered an OnOpen expression that can't be evaluated"-type errors).
Finally... I briefly investigated redoing this whole thing as an Access Project, but haven't ever used them before and don't really have the time to learn!
Any tips would be really, really gratefully received...
Cheers
Nick
http://www.rainyjay.com/tapi/tapi.htm
we have a tapi enabled phone and i want to connect it to my pc and allow it to talk freely to my database..
eg.. a customer calls up.. if their phone number exists then display their details in access..
if it doesnt exist then open a new form which lets you add a customer.. etc
anyone had any experience in linking phones to access databases
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
Is there a way to connect access database with a softphone? I have an IP PBX and a soft phone and i need to click on a form and auto dial the contact. My DB contains all the data I need and also PBX.
PBX running asterisk software.
Do i need a module or something like TAPI that call windows dialer (but win dialer use a modem and not Ip phone I guess)..Or something that just wake up voip softphone and paste data?
I seem to be missing an understanding of the difference between a project and a database. I am using a .mdb and writing code with success until I try to use the recordset feature which I took from my "VBA programming" book.
My code is simple...
Dim db As Database
Dim rec As Recordset
Dim strSQL As String
Dim intCount As Integer
Dim listEmails As String
strSQL = "SELECT Email from Member"
db = CurrentDb()
rec = db.OpenRecordset(strSQL, dbOpenSnapshot)
Do Until rec.EOF
listEmails = listEmails & Chr$(10) & rec(Email)
Loop
rec.Close
MsgBox listEmails
But when I run it I get a compile error because in line 1 the term 'database' is only a class in "a project".
Can anyone explain the issue and better still the solution.
Thanks
Phill
I built a database application, and I need for more than just myself to use it at the same time. I have just learned that I should have built a project instead. Can I change my application "Maintenance.mdb" to a project or do I have to start over?
View 5 Replies View RelatedI have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it interactive by means of searching. Thanks
Riley
I'll try to explain what I'm trying to do. I want to use the MS Access (2010) application residing on the remote server on a Access database(accdb) that is located on my local (home) PC. I copied the database from the server. How do I get Access (running on the server) to work on my copy of the database?
I tried using my local (on my PC) copy of MS Access (2007) to work on the database, but but I get file errors (file paths look like server paths).
Hi,
I created a database in Microsoft Access and then upsized it to SQL Server afterwards.
I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another table which contains a description of the column.
e.g.
Main_Table
Case_ID Foreign_Key_Field_ID
1234 78
New_Foreign_Key_Table
Foreign_Key_Field_ID Foreign_Key_Field_Desc
78 Describes the ID 78
I also setup a CONSTRAINTREFERENCE between the fields in these 2 tables.
I then relinked my tables using the Linked Table Manager to pick up the change to the table I altered (Main_Table). I also linked to the new table I created (New_Foreign_Key_Table).
My problem:
In Access if I create a new table I can select the lookup value for a field in the Table Design view Lookup tab. However, I altered my table in SQL Server and then linked to it again to pick up the change. Now when I view the linked table in Access it does not have any lookup value AND it's not possible to change this for a linked table.
Is there some piece of SQL I can use in SQL Server to change the lookup value for the field in my table OR have I approached this the wrong way. Should I have modified the local table in Access and upsized it again?
Otherwise if I select all values from my Main_Table in a form it displays the Foreign_Key_Field_ID instead of the Foreign_Key_Field_Desc because the lookup value has not been set to Foreign_Key_Field_Desc
This posting is a bit long - I hope it makes sense.
Any ideas or suggestions would be greatly appreciated.
Many Thanks
Hello,
I have a database MS access: test.mdb.
Is it possible to attach to SQL SERVER 2005, or any other solution ?
I need to transfer all the application:
structure and data.
How to do it?
Thank
I am currently working on an application where I am using MS access as my FE and working with linked tables to SQL server BE. I also have a few temp tables within Access that are not linked but needed.
1. What are my steps into making this into a SPLIT DB? I am assume the BE will have my linked tables from SQL and the FE will have my temp tables and forms. Is this correct?
2. Once I split it, then I can make an .ACCDE file for a Mulit User environment, is this correct?
What other steps should I be made aware of?
Currently I have an Access dB that was developed in A2003 but we are currently using A2010, it is accessed by multiple users that all have a frontend locally on there own networked PC's, with the backends etc on an old NT server, we are having problems with new technology accessing the NT server so it's well past time we got shut of it
We have a share on our network that has been made available to us to migrate all our NT server files to, Here's my problem, on testing the procedure I copied the database backend and .mdw file over to the share then tried to open the dB where upon i got the following error message
Cannot open microsoft Access database information file
On further investigation it seems that both the back end and the .mdw file have copied over with no content i.e filesize is 0kB, not only that the originals also seem to have had there content "deleted" a simple copy shouldn't have done this (I did have a backup btw)
Hi,
My access database's tables are currently linked to an excel document. My question is, how do I move my database to the network? Currently when I move the the database to the network no one can open my tables because the link goes to my documents on my computer which they can't access on the network.
So how do I move the database and maintain the link between the database and my tables?
Thanks in advance,
Ryan Smith
I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.
Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?
I am trying to upsize the access database to sql server ,i have an odbc connection and when I try to move the tables,all the data is moving except one table "tblproductinfo" . I have attached the table data and error.
View 1 Replies View RelatedI have a database which is now reasonably finished and am looking slightly ahead at how it can be accessed by the staff. The first clinic has two stations that need constant access to it, namely the clinic area and the reception area.The second clinic is about 3 kilometers distance away from the main clinic and will also need constant access which, I presume,would be by hosting the database on a Windows based Server, to which all three locations would connect and then be able to use the database directly. When I say Windows Server I mean as could be used to host a web site on the Internet rather than use of an internal Intranet system.
Should I split the database and only host the backend part on the server (i.e. the tables)?Does the whole database need to be uploaded to the Windows Server?Is any other software required to make this work?I presume that I would need to introduce record locking? Is this easily done and, if so, how?