Search results for query: *

Is there a way (or addin) where we can take our existing Access DB linked through ODBC to SQL by using OLE DB with limited programming and query changes? And, the users need to see the linked tables - like they do with the ODBC connection.

Can you connect and MDB file to SQL using OLE DB? If so, any code examples?

Access 2000 Front end, SQL 2000 Back end, linked tables Situation: User1 opens a record, another User2 opens same record. User1 may or may not have made changes before User 2 opens it. User2 makes a change, saves record. User1 makes a change and we obviously have a problem. Error: The...

I need to import flat double-byte characters files(Japanese) into Access and export them back out as DBCS. 1) is this possible? 2) if so, will I need any translation packages? Thanks much

Hello - I am looking for direction/resources to help me develop a database which translate english into Arabic script and Cyrillic script. I need an end result of showing a form with an English phrase and also Arabic and Cyrillic in the appropriate script. Any ideas? Thank you

Help please -- must be simple. Upsized an Access 97 database to SQL 7 - all seems OK (so far) except when we add or update a record in a FORM, it locks the record - and I cannot get it unlocked. When I add a record directly through enterprise manager, it also locks. When I update the record...

Help please -- must be simple. Upsized an Access 97 database to SQL 7 - all seems OK (so far) except when we add or update a record in a FORM, it locks the record - and I cannot get it unlocked. When I add a record directly through enterprise manager, it also locks. When I update the record...

"SELECT * FROM adview WHERE 1=1 AND memid=11219 ORDER BY ADID, positiontitle" Can someone tell me what the WHERE 1=1 is doing? Of course no field named 1. Thanks

Access 2000, split database. A new one to me -- multi user setting, and the error somtimes occurs: -- DB placed in state by user xxx which prevents it from being opened or locked-- It occurs when the passive shutdown control is invoked -- intended to force users from not entering when admin...

Hello -- We are running various asp pages, attached to an Access 2000 db on the web server. We cannot determine when the users get this error -- and something at the server level must then be re-set for the pages to work again. Any ideas on how we can address this without a server reset...

Look for recommendations for linking Access 97 or 2000 with mapping software programs -- need to generate maps based on addresses entered in the database. Is MapPoint an option?

This is really strange - I must be missing something. Access 2000, columnar form with 2 continuous sub forms - The control source of the second subform keeps changing to the control source of the first subform. I change it back, save it, it looks OK -- then the next time I open if the problem...

Have a customer who wishes to accumulate questionnaire information via email and auto import to Access. Has anyone had success with linking -- I am new to Outlook forms but, after creating a quick and dirty one I noticed I cannot access custom fields easily in Access. What do you think the...

Hope this is a quick one -- I am probably being pretty dense. I need to ensure when a user updates the value on a control and it goes to the next record that the control they just updated has focus (sometimes, not all the time). Thought this was working but it is not dim ControlName as...

Hello -- This one has been driving me crazy for a while. When a user uses Advanced filters on a form, it seems to save the filter on the form - without a prompt or a real save. We actually have gotten around this in the form but now we're launching a report from the form - if there is a...

Selecting Contents of Text/Combo box on Click -------------------------------------------------------------------------------- Hello - I need to ensure text gets selected when a user clicks in the text or combo box. Using the Got Focus event I've tried: HeadFootTrim.SelStart = 0...