Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   SQL Server backend with Access frontend My db is the MS mdb front-end and SQL Server back-end. I'd like to make a duplicate db to play with it. Do you think it's a good idea? Is the original one likely to be corrupted? Thanks,... 17 28.11.2005 00:12:58 OOBC, Access, Postgres Hello, I have a database application to be used in a multiuser environment. The Access file resides on 1 server and it contains forms, reports, queries, etc. The data resides on a Postgres server which Access links to using a system DSN. My question is, if I am not consistent in naming the DSN's the same way when I set things up on all the user's machines, will I run into problems? What d... 5 18.11.2005 04:58:55 Linked table shows this: "#name?" Hi, I just created a table in Excel and exported it into Access and then the SQL server using Enterprise Manager. I can see the table and all its contents in via Enterprise Manager. However, if I look at same linked table throught the Access FE, the data displays fine, but if I start scrolling to see the remaining columns on the right, at some point all the infomation in the columns... 3 15.11.2005 00:59:01 Lookup Properties disappear in upsizing wizard I was recently tasked with upsizing an Access db (that I was not familiar with) to SQL Server. I used the upsizing wizard to do this having it create linked tables. The database extensively uses the Lookup tab properties of the table design to format the table view with combo boxes and checkbox, etc. I don't know if any of them made it across in the upsizing wizard because I also impleme... 4 12.11.2005 22:52:53 SQL Server Error 11004 Hi, I have an Access FE connecting to a SQL server. A couple of my users are getting the following error message and they are not able to connect (they are both connecting from home via broadband): --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: 'S1000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver]Cann... 3 11.11.2005 22:12:04 set arithabort on Hello, I've a problem with inserting a record through a form. The recordsource is a view from sql server. The view has a computed column. The problem occurs when there is an insert on that view. In my ado-connection i can fix that, but how do i do it when the view is linked through odbc?... 4 11.11.2005 10:37:10 Access and Unicode Code page Problem Accessing a SQL 2000 database and trying to add records using recordset ..addnew in Access 2000. It is a multinational application and the fields in the database are identified as nvarchar, nchar, or ntext. When using the regional option English (united States) the information is placed in the SQL table as unicode. However when the regional option is changed to Chinese (PRC) the data ... 1 09.11.2005 13:12:03 Need help with connecting to an ODBC ORACLE/SQL back-end Good morning I would like to have my access db serve as a front-end to an ORACLE DB that allows me to access my oracle/sql back-end report server over the internet. I currently have to log into the program over the internet, select the fields I want, run the SQL statement, download the report and save as a text file, and import the fields into an access table to manipulate. Goal: 1. Have ... 1 03.11.2005 15:44:08 PHP ODBC / DAP Access DB I have an AccesDB (2000 Jet4.0) where I store content for my intranet webpage. For administering the content I use Iexplorer 6.0 and DataAccessPages. I display the content with dynamic pages (PHP) which is connected to the DB through ODBC (Newest servicepacks and drivers). The whole system worked very well for the las half a year. I could change content with DAP while useres where viewing the ... 1 03.11.2005 13:20:06 Connecting to Sybase I'm trying to link to an Adaptive Server Anywhere 9.0 db in Access 2K code: Dim ConnectString As String, MyDB As DAO.Database, MyTDF As DAO.TableDef Dim LocalName As String, ForeignName As String ConnectString = "Connect=ODBC;Database=GIDS;DSN=GIDSHome;" LocalName = "dbo_TktRemarks" ForeignName = "dbo.TktRemarks" Set MyDB = CurrentDb Set MyTDF = MyDB.CreateTableDef(LocalName, ForeignNam... 3 02.11.2005 15:10:30 Problem with HOST_NAME Function with Linked View I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about 25-50). This allows each user to have their own set of selections. The selections table has three fields: ID (int), Sel (bit), MachName (varchar). ID and MachName comprise the primary key. I hav... 20 01.11.2005 08:06:22 ODBC connection i have setup a Access application with MsSQL server. Now i have to setup ODBC connection at each XP workstations. any better method to setup this connection at once rather than do it at each workstations? Thanks a lot. tony ... 5 30.10.2005 08:40:51 ODBC function sequence error after converting from Acc 97 to Acc 2 After converting an Access97 database to Access 2000, the append queries do not work The append queries select fields from pass-through queries that use an ODBC connection to an external database. The queries are of the form . INSERT INTO myTable ( field1, field2, ...) SELECT DISTINCTROW passthru-query.field1, passthru-query.field1,...FROM passthru-query; The error returned is a... 1 28.10.2005 18:51:01 Porting SQL Server Stored Procedure to Microsoft Access Hi all, Is it possible to port a SQL Server Stored Procedure with Output parameter to Microsoft Access Query? Currently, i'm having problem porting the below SQL Server stored procedure to MS Access Create Procedure myProcedure ( @CustID int @CustName nvarchar(50) OUTPUT } As Select @CustName = CustName From CustomerDB Where CustID = @CustID Thanks for helping. ... 2 28.10.2005 14:54:07 Access to Visual FoxPro - ODBC vs OLE DB Can someone give me the differences and/or reasons of using the ODBC vs OLE DB connection between Access 2003 and Visual FoxPro database? I'm using ODBC right now, but the speed is terrible. Someone asked about OLE DB. I'm just starting the research but am not quite sure of the differences. Thanks in advance...... 2 27.10.2005 23:56:15 3167 record deleted error HI, i have an access MDB linked by ODBC to SQL2k. I get a strange behaviour when i do an INSERT INTO to a local Mdb table from "LEFT OUTER JOINED" SQL tables. If the related table hasn't related record to the first table, it get an Error 3167. This behaviour is not present with MDB tables JOINS. Who know something about this ? ... 1 27.10.2005 16:01:57 Prompt for UID & PWD This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C5DB10.908A4E70 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0011_01C5DB10.908A4E70" ------=_NextPart_001_0011_01C5DB10.908A4E70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Public Sub PromptConnect() Dim WkspcODBC As Workspace, NewCon As Co... 1 27.10.2005 15:08:04 Windows 2003 System DSN not found (but User DSN works) We just setup a new Windows 2003 server and we can't use System DSNs. If we setup user DSNs they work just fine, but everytime we try to use a System DSN it can't be found. Does anyone have any suggestions? Josh ... 1 26.10.2005 19:08:38 Retrieving open connections to an access database Is there a way of retrieving any open connections to an Access Database. And if so can the computer name from which these connections are established from, also be retrieved or not?? Say for instance there are 3 computers connected to a single access database located on a server, is there a way to retrieve the open connections to this database as well as the name of the computers. Any he... 2 25.10.2005 13:58:30 ODBC Wizard Problem I’ve run into an issue with a user trying to make an ODBC connection to an SQL Server database and I have no clue as to why this one thing happens (or more precisely doesn’t happen). She logs on to her PC with her Id. She can make a connection to a database on one server with no problem. However when she tries to make a connection to a similar databse on another server she gets an er... 2 25.10.2005 13:30:02 9 Pages: 1  2  3  4  5  6  7  8  9