Search results

You have to delete all the table links in the FE, then re-link again to the BE. You'll be asked to enter the password once, After closing the FE and re-open it again, you won't be asked for the password again.

Hi all, I've set up security on my database before with great success, and now I'd like to use the same workgroup file (a copy with a new name and location) to secure a nes db. I open the new db, and join my earlier created mdw file. I'm prompted with that I have joined my workgroupfile. I...

OK Doc_Man I appreciate your guidance here. I will do some research. If anyone has done anything like this before, it would be great to know. Thanks for your time and interest once again.

Thanks for your interest and replies FoFa and The_Doc_Man I have considered something like you describe by using some kind of syncronization solution. My boss would REALLY like a LIVE one :eek: . I need data from the current db to the new one as well. This is production data needed in the...

I have a split database. BE located at a server and FE on each users workstation. There are 8 concurrent users at the most. This runs smoothly over the LAN. Now I'm adding a new feature to the database. I'm using a wheel loader to weigh products on a weight scale. The operator in the wheel...

A record isn't necessary being edited at the time, but the record is probably in edit mode after it has been edited. Edit mode is indicatet on the formms record selector bar by a pencil. To go out of edit mode you'll have to save the record. This can be done by the user or done automatically...

If the purpose is to do some updates/development on an Access database, you have another option. I'll just give you the outlines here first. When the users start the db, open a connection to where the back end is located. I use a form that's hidden and is always open when my app is running. In...

Hi Roy-Vidar Got it! I use a criteria on the 'many table' (tblProsesstider) on the CID field which indicates each batch. So when the left join query runs - the criteria dont allow the null value CID record to be shown. Solved this by setting the criteria in a new query, and using this query in...

Thanks for your interest though. I have many left join queries in my project, so it's not that I've never used them before. This is strange. I've tried making this query directly on the tables so it should be straight forward. It's not essential that I make this work, because I now get listed...

Hi Roy-Vidar I'm no expert on this but I've made a new left join query like this: SELECT tblProsesstyper.PTID, tblProsesstyper.PBESKRIVELSE, tblProsesstider.CID, tblProsesstider.START, tblProsesstider.STOPP FROM tblProsesstyper LEFT JOIN tblProsesstider ON tblProsesstyper.PTID =...

Hi, I have a left join quert that's not working as it should The query is like this: SELECT tblProsesstider.CID, tblProsesstyper.PTID, tblProsesstyper.PBESKRIVELSE, tblProsesstider.CID FROM tblProsesstyper LEFT JOIN tblProsesstider ON tblProsesstyper.PTID = tblProsesstider.PID; The problem...

Thanks for your replies Pat. Very much appreciated!

Yes! That's a great idea. The components are categorized in 15 categories. I won't have space for 15 columns but I guess I could place more than one subform in each column. If the users need to add new components, these will be added to the respective subform. It is more likely that we'll add...

Thanks Pat. I suspected that. I have a table that lists 80 components in a production plant. My idea was to create a form that listed all these components. They will be colored after if they are working or not. Would be nice to make more than 1 column since the column width isn't any wide...

HI Is it possible to get more than 1 column per page in a continous form? TIA

Hi Crilen007 Thanks for your input. In Norway we are only allowed to use 100mW of output power on a WLAN access point. (1w in US I think). This limits the coverage area to to about 400 to 500 meters. I'll see if we can arrange some tests. Instead of using the main database, I wondered if I can...

Hi Wayne and thanks for your thoughts and comments. My situation is that I want to have the database in a Catepillar that weights metal blocks. The Cat picks up these blocks in another part of the production hall where we don't have any network coverage. The blocks is then driven to the weight...

Hi! I'm running a split MS Access database. Backend at the server and front end at each workstation. Now we want to use the database on a laptop with a wireless LAN adapter. The laptop will be placed in a loading vehicle which drives all over the company's site. When the laptop looses it's...

Yes, only fields from both tables Thank you both for the replies. I'm not at work now, so I can't try this out till tomorrow. Thanks again!

Hi! I want to update some records in one table from another table. How do I do this? I see how I can increase a value by 5% by setting the 'Update to' field in an update query to '*1.05', but I want the new value from another table. Thanks in advance