Search results

Two things I think you are missing, though correct me if I'm wrong: 1) If I copy the rich text into the Long Text field that is being used by the ERP program, it will be copied as plain text. But that field is supposed to have the HTML markers for Rich Text. It will look unreadable when...

Creating and saving raw Rich Text source code into a field I'm using an ERP software that stores Rich Text product descriptions in a single Long Text field. The text is simply the source code of Rich Text files. For example, if I open an RTF file in Notepad and copy all of it into the field...

The password for the DB is in the ODBC entry. But that is different than the Windows login information for the server in Explorer. How can it even reach the database file without the login information for navigating to the file?

I've noticed I can connect to a database via ODBC by entering the path to the database file, even if I don't have the username and password to access the server through Windows Explorer Network Neighborhood. For example, SampleServer:C:\SERVERFILES\DB\MyDB.dbx can be entered as the database...

Okay, but can I get an answer on the MDF file question? Do these front end programs normally still save the data in a standard SQL Server file, or is it realistically possible that the database can be stored in a way that can't even be detected by outsiders, for example by merging the data file...

Thanks. Before I talk to the vendors I want to poke around on my own a bit. The vendor will only try to sell me something. I'm trying to understand what methods are available to the software vendor to prevent access to the database (even though I own and use the license for the software)...

So I see that several types of Enterprise Resource Management software use MS SQL Server as their database platform. I was wondering, is it possible to use MS Access to access the database that these programs use the same way that you would access any other MS SQL Server database? I think what...

I said I would leave parts of Excel editable and you're pointing out that that should never happen, and I agree with you. I was mixing up my goals for testing unfinished versions of the WIP database with the first release version of the database. For the first release version of the database...

Thanks guys, especially Solo712. Pat, it wouldn't be data I edit. It would be either master template cosmetic changes like spacing or fonts, or changes to parts I have not automated in Access yet -- the first few versions of the database will leave some things to be manually edited.

Every paragraph does NOT have the same structure. Think of each paragraph describing a smaller machine that is a part of the larger machine. I must have a table describing all the possibilities for that one smaller machine. It could be a small table, maybe only 3 values similar to a table for...

I am not using tables in Excel in any way related to the database. Only cosmetically if i make the borders for groups of cells visible to separate information. As I mentioned, I originally was using Word to make the contracts. The only reason I am switching to Excel is because it is easier to...

I want it in Excel in case I encounter something I have to edit manually. Can't do that with a report, at least not as easily. (?) Over 100 tables, mainly small ones, containing alternate strings of text to build a paragraph. Each paragraph would have about 3 tables related to each...

I sell big machines and the offers and orders are several pages long, containing numbers, specifications, and legal information that can change depending on the type of machine sold and the customization options that are chosen. I want to store our calculations, offers, and orders in an Access...

Well I got that fixed by changing the source object. I noticed when deleting a record it shows the next record when the confirmation dialog pops up as if the record I had selected was already deleted. If I select no then it goes back to the record I decided not to delete. How do I make it...

Tell me if I did a clean workaround. So I had the problem, after splitting my database, I would get Error 3048 "Cannot open anymore databases" when opening my report. My report shows a list of orders containing an item in a given time period. I pinpointed the problem to the subreport that...

Yeah that's why I'm asking what is the use of a line with infinity sign on both ends. Anyway, after doing some searching, I found out that I could fix my original corrupted database by redefining the record source of the offending table, i.e. cut out the fields, delete the tables, close and...

Question: I have added a details subform to my main form. It displays details for the selected item in another subform. The details are loaded from a query and displayed in single form view. I have done this for my first product type (Machines), but the problem is I have different product...

What does a relationship with an infinity symbol on both ends do for me in the relationships window? I have Orders and ConstructionSite tables, both of which have CustomerID foreign keys. I drew a line and it is like that, and it won't let me enable Enforce Referential Integrity.

decompiling and recompiling must be done from the command line? btw, I just Compressed & Repaired my database and it went from 93.5 megabytes to 1.9 megabytes :eek: all in a split second.

I never saw those checkboxes. I simply copied and pasted the objects. I thought that's what we were talking about. I guess I'll have to redo the relationships....although I wonder why in my recordsource queries it still has the relationships and they still function correctly. I've been...