Search results for query: *

I would like to use a query that includes an ole object (signatures) and merge it with a Word document but all I get is "Long binary or text value" where the signature should be. I have tried the Microsoft Knowledge Base and the Keyword search for this sight but can't find an answer...

Thanks for your helpful comments! The database already is seperated between front and back with only the back end replicated. Only about 20% of the tables contain data that both locations use and require syncronizing. I would like to use your idea of creating a generic database and...

When syncronizing 2 replicas, I received 2 error messages, the first said they weren't from the same set (they are!), the second saying that the one database was not a replicated database. When I looked, much to my horror, it had "lost" it's replica status! Out of desperation and...

Thanks for your help! It works great!

I have a report where I would like a number, which is the result of a calculated field, to always round up. If the answer is 8, I would like the report to read "8". If the answer is 8.3, I would like the report to read "9". Currently, 8.3 rounds down to 8 and 8.6 rounds up...

Looking for code that will shut down a database that is shared on a network when there has been no "activity" for a specified time. Users tend to get into database for info and then leave it up while they do other things...go to lunch,etc... Makes it run slower for those using it and...

I have a front-end/back-end application on a network with several users. When trying to merge a query ( it has parameters) with a word document, user occassionally gets the error message "File in use. FrontEnd.mde is locked for editing by "another user". Click notify to open as...

We have a front end back end application. Front end is mde and back end is mdb and replicated. Most of the data entry is done at a location an hour away from my office. The back end is on a server that, until just a few days ago, had 64 mb memory, runs on windows 98 and Access 2000. Front...

thanks for your help! I realize my problem was in the one to many relationship. After looking closer at the tables, the information they contained and how they related to each other, they should really have a one to one relationship...which also fixed my problem!

Have a subform that is based on a query with 2 tables that have a one to many relationship. The key from the one side is the link between the main form and subform. I can add records to the subform fine, but when I delete (do have cascading update and delete turned on)only the record from the...

Thanks Terry, I'll check out those sources. I did try to delete the ldb file but didn't work.

We have a database with front end linked to back end on a network. It is like this on the server and then each work station has its own front end linked through the network to the back end. Twice, when I've wanted to replace the front end because of revisions, I couldn't because the ldb file...

thanks! I'll give that a try!

Does anyone know if a wizard exists, (or knows of the code) that would take information from a table regarding the arrival and departure dates of groups (i.e. the Boy Scouts are arriving on Friday, May 25 and leaving on sunday, May 27) and place them on a calendar. There could be more than one...

I imported the back end into a new database so it wasn't replicated anymore and converted it back to 97...and the missing fields were there! I then converted it back to 2000, fields still there and then replicated it and that seems to be where the fields are disappearing, or rather relocating...

When I converted a 97 database back and front ends to 2000, there seemed to be no problem, at first. Then I noticed problems with code and the occassional expression in a query where there use to be a field! Then I find the field that was there in 97 is not in the table in 2000! I can still...

I converted 2 97 databases to 2000 and made mde files on my computer at work, had no problem. (actually, I did discover that one field in one table was dropped. It showed up in the forms and queries as an expression. I did the conversion again and it was fine, unless there is another field...

In the Access 97 help files, I found some info on "greatly enhancing performance when opening the main database and opening tables and forms by forcing the linked database to remain open. To do this create an empty table in the linked database (back end?) and link the table in the main...

In Access help files, I found the following regarding improving performance of linked tables: "Create an empty table in the linked database and link the table in the main database." I'm not clear on which is the "main database," the back end or front end? I'm assuming it's...

Thanks for your input! I'm starting to work with Access 2000 and have read bits about its upsizing wizard. Can I "upsize" an access database so I have the back end in SQL and leave the front end in access? Is it really that simple? I've been told I would have to learn visual basic...