f



Splitting a text field conatining a carriage return.

I have a field in an access 2000 database that is actually three lines
of text separated by carriage returns.

Is there a function in the Access version of SQL that will let me
locate the carriage returns and then split the field based on the
positions of the carriage returns?

Or do I need to process the field with Visual Basic?

I seached for an answer to this on the web.  I found an answer that
said to use the CHARINDEX function but that is apparently not a part
of ACCESS 2000 because I get an error message saying that it is
invalid.  

Thanks in advance  for your help.

Greg Teets
Cincinnati Ohio USA
0
gteets (11)
12/30/2004 8:06:19 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
533 Views

Similar Articles

[PageSpeed] 9

On Thu, 30 Dec 2004 20:06:19 GMT, Greg Teets wrote:

> I have a field in an access 2000 database that is actually three lines
> of text separated by carriage returns.
> 
> Is there a function in the Access version of SQL that will let me
> locate the carriage returns and then split the field based on the
> positions of the carriage returns?
> 
> Or do I need to process the field with Visual Basic?
> 
> I seached for an answer to this on the web.  I found an answer that
> said to use the CHARINDEX function but that is apparently not a part
> of ACCESS 2000 because I get an error message saying that it is
> invalid.  
> 
> Thanks in advance  for your help.
> 
> Greg Teets
> Cincinnati Ohio USA

If your version of Access has the Split() function (look it up in VBA
Help), you can use it to parse the field into 3 different parts.
You would use Chr(13) & chr(10) as the field delimiter.

Because this is a VBA function, you'll need to create a module, then
call it from the query.

In a module:

Public Function splitthis(fieldin, X)
Dim var As Variant
var = Split(fieldin, Chr(13) & Chr(10), -1)
splitthis = var(X)

End Function

In a query:
New:splitthis([FieldName],0)

will get the first part. The parts are Zero based, so the third part
will be 
splitthis([FieldName],2)

-- 
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
0
fgutkind1 (959)
12/30/2004 10:16:11 PM
Reply:

Similar Artilces:

Splitting MS Access Database
have an access 2000 database which has several levels of security defined, i.e., certain users can only see certain forms, run certain reports. I am splitting this database in front end and back end. I want to move back end to Oracle. I don't know where security is stored in Access. Will access users see only he forms/reports they have been authorized after the move to Oracle. I can limit database access to Oracle by creating different Oracle users, but my question is what happens to front end security after the split. Thanks, Prem premmehrotra@hotmail.com wrote: > have an access 2000 database which has several levels of security > defined, i.e., certain users can only see certain forms, run certain > reports. > > > I am splitting this database in front end and back end. I want to > move back end to Oracle. I don't know where security is stored > in Access. > > > Will access users see only he forms/reports they have been authorized > after the move to Oracle. I can limit database access > to Oracle by creating different Oracle users, but my question > is what happens to front end security after the split. You have to remember there are different authentication schemes possible with Oracle, like ldap, jazn, sso, etc. If you are using Access with odbc as an Oracle client, your option for security will be whatever is provided thru the odbc driver. Most likely you will have to hatch some schmeme on the...

Carriage Return in text field on form?
Can I change the behavior of using the enter key in a text box? The current behavior when using a carriage return is that you will be taken to the next field. I don't want that to occur, I want the cursor to go to the next line in the same field. Possible? Thanks again in advance! Tom You can if the field is a memo. You have to trigger editentermemoview when you arrive or go into edit mode. See the constants section of the opal help. Denn Santoro President Resource Development Associates http://www.RDAWorldWide.Com Offices in the United States and Germany Provi...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but I don't know what software is >needed. Do you know? If so, please answer this post. Thanks. I think it comes down to semantics. "Licensed" vs "Loaded". No you can't create an app that will run on a PC with nothing loaded. Yes you can create an app that will run on a PC where nobody's paid the fee to run MS Access. You still have to install something on that PC, however. What it is is a freebie version of MS Access that only runs applications - doesn't allow anybody to develop an app. You develop the app on your PC, which has MS Access installed. Then somebody installs the freebie ("Runtime Access") on somebody's PC and they can run the app you developed without having to pay any money to anybody. -- PeteCresswell Sue, If Access isn't present, some version of it must be installed to run an Access database. VB.NET, ...

Re: Replace a carriage return in a text field
----=_vm_0011_W853083665_20681_1178885376 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I usually unload the primary key and the field in question to a file on unix, and use the 'tr' command to get rid of any control characters, then load it back up with a sql statement. <DIV><FONT face=Verdana size=2>&nbsp;</FONT></DIV> <br> ======================== <br> email: floyd@fwellers.com <br> Home: 703-430-0805 <br> Cell: 703-477-6045 <br> ======================== <br> <br> www.one.org <br> <br> <br> <br> >-----Original Message----- >From: jared.hanks@gmail.com [mailto:jared.hanks@gmail.com] >Sent: Thursday, May 10, 2007 09:05 PM >To: informix-list@iiug.org >Subject: Replace a carriage return in a text field > >Hello, > >I need to remove carriage returns in a text field. Does anyone know >how to do this? I've tried the following: > >update item_table >Set long_description = replace(long_description,"~r"," ") >where inv_id = "130539"; > >and I get the following error: "674: Routine (replace) can not be >resolved." > >I've also tried: > >Update items_table >Set long_description = replace(replace(long_description, >char(10),char(13)),char(13),' ') >where inv_id = "1305...

Why does the Database Connectivity Toolkit not return my text fields?
I'm running LV 8.2.1 and have the Database Connectivity Toolkit. My database is served by MS SQL Server 2005.&nbsp; The table looks like this: &lt;meta http-equiv="Content-Type" content="text/html;charset=UTF-8">dbo_Test dbo_Test ID Text 1 abc 2 def 3 slkdfj 4 owierlkjsdf 5 soiwuers A snapshot of my vi block diagram is attached.A snapshot of my vi front panel is attached.Where is the text?<img src="file:///C:/DOCUME%7E1/s156556/LOCALS%7E1/Temp/moz-screenshot.jpg" alt=""><img src="file:///C:/DOCUME%7E1/s156556/LOCALS%7E1/Temp/moz-screenshot-1.jpg" alt=""> vi.jpg: http://forums.ni.com/attachments/ni/170/312825/1/vi.jpg vi-fp.jpg: http://forums.ni.com/attachments/ni/170/312825/2/vi-fp.jpg kc64, I don't think I completely understand the problem.&nbsp; Can you go into more details of exactly what is the issue you are experiencing? ...

Problem concatenating memo fields in MS access database
I have an access database form where I have a button that is supposed to be appending the contents of 1 memo field to another is behaving non-predictably. The code is: Me![ToDo] = Me![ToDo] & Chr$(13) & Chr$(10) & Me![Studies1] & Chr$(13) & Chr$(10) & Me![Studies2] Me![Meds] = Me![MedsEntered] & Chr$(13) & Chr$(10) & Me![IVF] & Chr$(13) & Chr$(10) & Me![Diet] DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Any thoughts on what I'm doing wrong? Could there be a casting problem? (I just want to append the text of 1 field to another field - am I actually assigning objects this way?) Any help would be greatly appreciated. GH ghadley_00@yahoo.com I have managed this in a report without the $ sign e.g. =[FirstName] & " " & [lastname] & Chr(13) & Chr(10) & IIf([job title] Is Not Null,[job title] & Chr(13) & Chr(10),"") It does not use memo fields but I would think they would work OK? James <ghadley_00@yahoo.com> wrote in message news:1131535433.245165.221450@f14g2000cwb.googlegroups.com... >I have an access database form where I have a button that is supposed > to be appending the contents of 1 memo field to another is behaving > non-predictably. The code is: > > Me![ToDo] = Me![ToDo] & Chr$(13) & Chr$(10) & Me![Studies1] & > Chr$(13) & Chr$(10) & Me![Studies2] > Me![Meds] = Me![MedsEnter...

Remove Carriage Return in Access Exported Text File
Hi All - I have some data that I export from Access to a pipe-delimited text file. Unfortunately, the text file always has a carriage return symbol at the end. I need to export this file frequently and send to a system that cannot accept this character at the end of the file. I am looking for a way, perhaps with VB code, to automate this process. I found this code on another Google Group, but I can't get it to work. Any advice appreciated. :O) Here is that code: Function RemoveCarriageReturn_UMG() Set fso = CreateObject("Scripting.FileSystemObject") Set NewFile = fso.CreateTextFile("C:\hello.txt") Set file = fso.OpenTextFile("C:\return.txt") Do While Not file.AtEndOfStream CLine = file.ReadLine CLine = Replace(CLine, vbCrLf, "") NewFile.Write CLine Loop file.Close NewFile.Close Set NewFile = Nothing Set file = Nothing Set fso = Nothing End Function You need to search for chr(10) and chr(13) and replace them "Ellen" <ellenchriston@gmail.com> wrote in message news:1168944047.244816.224500@m58g2000cwm.googlegroups.com... > Hi All - > > I have some data that I export from Access to a pipe-delimited text > file. Unfortunately, the text file always has a carriage return symbol > at the end. I need to export this file frequently and send to a system > that cannot accept this character at the end of the file. I am looking > for a way, perhaps with VB code, to automat...

How to link fields in MS word document to Access database
Anyone have experience in linking fields in an MS Word document to an access database? What I am considering doing is taking an existing fill-in-the fields word document, for which I cannot now save the data, and allow it to be opened with no data, have the fields filled in and then save the data in an Access database. I also want to later select the document (from a file in the database), open the word document and populate the fields from the database. Of course if there are then any updates I want to put them back into the database. Workable? Anyone with sample code? Bob Alston On Jun 10, 6:21=A0pm, Bob Alston <bobalst...@yahoo.com> wrote: > Anyone have experience in linking fields in an MS Word document to an > access database? Hello Bob, Instead of Word documents I use RTF-documents. RTF-documents act just like Word documents in Word. The difference is that RFT-documents are plain text-files, and can easily be processed in Access to find - with the appropriate placeholders - the filled in information. HBInc. > > What I am considering doing is taking an existing fill-in-the fields > word document, for which I cannot now save the data, and allow it to be > opened with no data, have the fields filled in and then save the data in > an Access database. =A0I also want to later select the document (from a > file in the database), open the word document and populate the fields > from the database. =A0Of course if there are then ...

How to import a tab delimited text file into MS Access database
Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is created and the table structure is defined using DAO methods. So now I have to fill this table with the data in the text files. For a few rows in the text file, the number of columns could be less than the number of columns in the table. Can anyone please post me the code to do this. Thanks a ton in advance. Pradeep wrote: > I have the following task to be done in VC++ 6.0. We'd be happy to give you the VBA code, but do you really want to throw away your C++ and use Microsoft Access for the job? If you want to keep C++, you can ask for C++ code in another newsgroup, because we'd just be guessing. -- Message posted via http://www.accessmonster.com ...

Forcing a New Line in a Text Field in MS Access using VB
Heya! I feel I'm beating an old horse to death with this question but I can't get around the problem. I want to update a text field on a form with a string from a VB module. I need enter/linefeeds in the string. I've tried: Chr(10) & Chr(13) Chr(13) & Chr(10 vbnewline vbcrlf none of which seem to work. I've set the properties for the text box to [Enter Key Behavior] = 'New Line In Field' and [Can Grow] = 'yes'. At the moment, my code looks like this: celsql = celsql _ & "Program: " & encname _ & vbCrLf _ & vbCrLf _ & "Start Time: " & sttim _ & vbCrLf _ & "Participants: " & numpart _ & vbCrLf _ & "Confirmed by Curator: " & cbc _ & vbCrLf _ & "Client: " & clntnm _ & vbCrLf _ & "Contact: " & cntct _ & vbCrLf _ & vbCrLf Forms(frm)(bts) = celsql If I toss this string into a [MsgBox], it comes out fine. It's just something about the text field... I'm working in MSAccess 2007, but need it backwards compatible to 2003. I'd really appreciate any advice. Cheers, KG I've seen this type of problem before, but I typically just use a separate text box for each data field. Is there a par...

Problem with carriage return/newline character when writing SAS database to a text file...
I had a table in Excel which included an ID (identification number), COMMENTS, and AMOUNT column. The COMMENTS column were text notes (up to 2000 characters) commenting on the corresponding ID. I imported this table (via proc import) into a SAS dataset and then used the file and put statements to write the dataset to a fixed-length text file (i.e., for each record, the ID variabe was outputted to positions 1-4, COMMENTS outputted to positions 6-2005, and the AMOUNT column outputted to positions 2007-2012). The text file, however, did not come out how I expected because some of the text in the COMMENTS field wrapped over to the next line in the text file (each record is supposed to appear on only one line in the text file, not multiple lines). When I looked into the COMMENT field in the SAS dataset I created, I noticed some tiny black, rectangular symbols that appeared sporadically throughout some of my records. I'm assuming those symbols represent a carriage return/newline character (I don't know what the exact terminology is for it)?? I noticed that wherever those symbols appeared in the SAS dataset is where the text file broke to a new line when the dataset was written to the text file. Is it possible to eliminate this carriage return (or whatever it's called) symbol is SAS? For my text file to be correct, I need to have each dataset record appear on only one line in the text file and it appears as though it is this carriage return which is making some of the ...

HELP! Retriving field names and properties from MS Access database using ASP
Hi everyone! I have a really frustrating error and need help. I&#8217;m trying to do a function that gets the properties and names of the fields in a MS Access database using ASP. I haven&#8217;t programmed in a while so I&#8217;m quite lost. Once I have the my database structure I will insert the corresponding fields from a web form but the database is huge and I want to be able to change the database and form without changing the ASP code all the time. This is my function that is not working yet. I cant seem to connect properly to the database... Function InsertDataBase() ...

how to import text field from MySQL db to MS Access 2003 using ImportXML
Hi Guys, I'm trying to import data out of MySQL db to MS Access 2003 using ImportXML. I don't have any problems doing the import, except for one table with a "text" field defined. I'm getting an error message saying "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.". Thanks, Do you have to use ImportXML? Why can't you use the ODBC driver to MySQL? Linda <nepifanio@gmail.com> wrote in message news:1137431763.824498.100740@g44g2000cwa.googlegroups.com... > Hi Guys, > > I'm trying to import data out of MySQL db to MS Access 2003 using > ImportXML. I don't have any problems doing the import, except for one > table with a "text" field defined. I'm getting an error message saying > "The field is too small to accept the amount of data you attempted to > add. Try inserting or pasting less data.". > > Thanks, > MS Access is not allowed to directly access the data from mysql db. The data from mysql db is exported in xml format using a system (with user login/password) and then imported into MS Access. I'm not exactly sure what cosmic events make it work for me, but I do it all the time. I access tables in a MySQL database using MS Access. I make edits and run reports. Linda <nepifanio@gmail.com> wrote in message news:1137532447.886457.233460@g14g2000cwa.googlegroups.com... > MS Acces...

Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)
Hello, I made one application that opens MS Access databases.And I have one problem.How can I find the real data type of columns(text, memo, OLEObject, numeric) like it is into Access.I tried with resultSetMetaData.getColumnType(columnIndex) but I receive java.sql.Types.I have two columns that contains OLEObjects(images).But I receive two different types for columns : VARCHAR once, and for second column SMALLINT.I only want to see the types like in Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance! Best regards, Calin Pop ...

Access 2000 Enter key causes carriage return, not next field, in datasheet view
Hello all, I am using Access 2002, with file format of Access 2000, and am experiencing a problem. I have a subform that is shown in datasheet view for users to edit data direct to a table. When a user presses the Enter (or Return) key a carriage return is made in the cell, rather than the cursor moving to the next field, which is what I expected to happen. (I believe that usually, to create a carriage return, the user would have to press Control+Enter.) Is there a way of preventing the carriage return and forcing the Enter key to move the cursor to the next field? Under the Options, Keyboard Tab, the 'Move after enter' setting is set to "Next field". Is there an option on the form or subform that is causing this change in behaviour? Many thanks in advance for any help. Chris Hi again, I have found a solution to my problem: On the sub form (design view) some of the controls had their 'Enter Key Behavior' property set to "New Line in Field". Changing this to "Default" solved the issue. Chris ...

MS Qry and text field to date field
I am using MS Query to pull files (from IBM AS400) and put them in Excel. However, when I do this the dates are now text fields. The text/ Date field looks like this: 20070331 (YYYYMMDD) I would like the change this text to a date field so Excel will see it as a date. Can someone please help me? I have looked all over the place for a solution and I have found nothing. Also, if you know of a good place to get information on MS query please let me know. /Thanks! wwolford wrote: > I am using MS Query to pull files (from IBM AS400) and put them in > Excel. However, when I do this the dates are now text fields. The text/ > Date field looks like this: 20070331 (YYYYMMDD) > > > I would like the change this text to a date field so Excel will see > it as a date. > > Can someone please help me? I have looked all over the place for a > solution and I have found nothing. > > Also, if you know of a good place to get information on MS query > please let me know. > > /Thanks! > In Access you could use DateSerial. Ex: x ="20070331" ? dateserial(left(x,4),Mid(x,5,2),mid(x,7,2)) ...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Accessing text form fields name=field[label]
I'm pretty much a JavaScript novice. I'm good at learning by example and changing those examples to suit my needs. That said .... ..... I have some select fields in a form I created for a database search that I am unable to figure out how to access. (The search is implemented in Php/MySQL.) The user enters search values for: name, address1, city, .... etc., ..... and for each of these they also select whether the search should look for the field to be equal to, not equal to, Like, or Not Like the value in the database. So in the form I have: <input type=text name=city> in combination with <select name=func[city]> <option value='='>=</option> <option value='!='>!=</option> <option value='LIKE'>LIKE</option> <option value='!='NOT LIKE>NOT LIKE</option> </select> For an example, this search could be to find an entry "WHERE city $func[city]] $city. (Php - e.g., WHERE city = 'Denver'). This works fine - in Php. I use similar combinations for name, address, etc., ... Okay, here's the JavaScript problem. For the Reset action I have a JavaScript function to Reset all the form fields. I want to Reset the selected indexes for the "func" fields (func[name], func[city], func[state], ...) using a loop that goes through the associative array, "func." I cannot find the right syntax to address them as an array and I am beg...

Running a ms access database with access 2003 in Vista
I have a Database that I am trying to run on a new vista computer. Up to now I was running it on a win 98 computer and using access 2003! I installed access 2003 and I can make it run and view the data but I can not save any new records. Has any one seen this problem yet? Thanks Clarence Wollman On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <clarencewollman@gmail.com> wrote: Do you have the same problem with the Northwind sample application? (search your computer for northwind.mdb) -Tom. >I have a Database that I am trying to run on a new vista computer. Up >to now I was running it on a win 98 computer and using access 2003! I >installed access 2003 and I can make it run and view the data but I >can not save any new records. >Has any one seen this problem yet? > >Thanks Clarence Wollman On Aug 22, 7:29 pm, Tom van Stiphout <no.spam.tom7...@cox.net> wrote: > On Wed, 22 Aug 2007 13:17:13 -0700, cwoll <clarencewoll...@gmail.com> > wrote: > > Do you have the same problem with the Northwind sample application? > (search your computer for northwind.mdb) I don't have a problem opening and editing the northwind.mdb. Thanks Hi I found a workaround. This database has a fronted and a backed. When I link them in the linked table manager, I was going threw the network to my computer. The reason I am doing this is when any networked computer opens the shortcut to the front end of this computer the linked table manger knows...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Singularity.co.uk> wrote in message news:1118749208.204709.287950@g49g2000cwa.googlegroups.com... > Hi > > The technical support guys at my company have set up my system so that > the server containing the MS Access database is on one server, while > the pages that should access the database are on another server. > > When the pages and database are on the same server, I usually just > connect through ODBC. > > The problem is that I don't know how to set up an ODBC connection to > link from one server to a database in another. > > Anyone know what I am getting at and know of a possible solution, or a > link to a site which may help. > I think this may be more of a network issue than an Access one. Can you see both servers from your PC? Is there any particular reason why they've been put on different servers? Seems a little odd to...

Access Split Database
I have an access database that has been split and resides in the network share. When the access database is currently being updated by someone, and I try to open the database, I cannot open the file by double clicking on the database filename, for example, \\sharename\testdb.mdb I have to launch MS access, go to the file, then open the file from within MS Access. BUT If no one has the file open, I can double click the database from the UNC Any ideas?? http://forums.aspfree.com/microsoft-access-help-18/multiple-users-can-t-open-same-access-database-124338.html solved a multi-user problem by setting "the secure server, which is outside our network server's domain, (as) a "trusted site" for file access" If you are using https:// this might be relevant. ...

Web resources about - Splitting a text field conatining a carriage return. - comp.databases.ms-access

2 Unlimited, biography discography, recent releases, news, featurings of eurodance group - The Eurodance ...
Everything about 2 Unlimited : biography, discography, tracklisting, news, tourdates and more

Altruistic and Selfish Bacteria
The Boston University Physics Department hosted a very interesting talk yesterday by Robert Austin of Princeton. Austin has been studying the ...

ALLERTON AVENUE, Bronxdale
» ALLERTON AVENUE, Bronxdale » Forgotten New YorkForgotten New York -

Legislating Away American Ingenuity and Enterprise
That's what I think of what happened Friday. I watched the debate myself on C-Span. It has taken me this long to get past the fury engendered ...

Thunderbolt RAID provides boost over eSATA
Macworld Lab recently saw how dramatic an improvement Thunderbolt performance is over FireWire 800. In response to that report, Macworld readers ...

About Scrabble cheat blog
Scrabble Cheat Blog on scrabble cheat using our scrabble solver engine

Accommodation
A comprehensive and up-to-date guide to self catering breaks & accommodation in Suffolk

Twinity
... May 20, 2011 08:41 am British Invasion ! – Spring/Summer collection 2011 is out now. Visit the shop and get inspired by the chalkboard conatining ...

Geometry of the Sphere 2.
Suppose we have two distinct points A and B on the sphere.Together with C , the center of the sphere, we have threepoints in space, and there ...

Why You Have a Better Chance of Landing a Guest Post Than You Think
... sample: Hi I am [name removed]. I wanted to guest blog on your esteemed site under SEO section. Here by i am sending doc conatining article ...

Resources last updated: 3/21/2016 12:34:53 PM