Search results

Hi people, I've been considering how to setup my database to secure my queries. In this case, the data in the tables is not so important, as the process that is used to filter the data and produce an output. I was thinking of an alternative way to secure the queries, without going the...

I did end up imported all db objects into another db and was then able to work with the tables, etc. Apparently the client had been experimenting with Replication and wasn't quite sure how to use it. I've advised them to no longer use the legacy database (replicated) and just backup the design...

I tried to do the same for the BE by going to: Tools -> Replication -> Recover Design Master However, the option was not available. The only one that was, was "Create Replica". If I hadn't got that error message when working with the BE tables, I wouldn't have even recognized this as a...

It is just a single user. I believe they received the database from another source. I was trying to see if I could manage without contacting the original developers. It seems I might have to. The other source would provide updates to her FE via replication. However, she no longer wishes to use...

I recently was asked to update a client's BE & FE database. It seems the client only has a replicated version of the database. I don't have the original Design Master. Problems with negative autonumbers (it seems are due to replication), made me want to remove all need for replication from...

I successfully imported a whole companies dBASE III files from OpenAccess to Access 2003, using the import options from the import menu. I ran into trouble with time conversions. If you've got any time field that needs to be imported, you'll find they import as a long integer number. I...

Thanks so much John.Woody! That tutorial is excellent. It's got so much information and easy to follow screen shots. I think I'll be able to follow it. Now I've just got to find the time to do it. :)

Thanks John.Woody, The company has a static/fixed IP address with their ISP. Can you explain this a little further: I've also had secondary thoughts about security. Instead of accessing the db on the server machine, perhaps I could have them access, through remote desktop, one of the FE...

Remote Desktop connection to Access DB on Server Hi I currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to...

Hi MicroE, Your article link was very informative. I'll try a few of those other options. The batch file sounds like a great idea. I've been thinking how the company would manage their new reports if I locked up my FE database. E.g. Let's say I create the FE MDE version, with a switchboard...

I like that idea: So do you give the company a locked MDE version whenever you do an update to the FE or BE? And then simply create a new database that will link to all the tables in the BE which will allow the company to create their own Ad-hoc reports? It sounds wonderful for a few...

I always keep a copy of my last FE update before sending an update through. They will put a copy of the FE on each local machine. Once it's in the hands of the company, they may make changes to the FE according to their needs. This updated FE would then be copied again to local machines across...

Yes, I think that would be fine, if the staff were not also making changes. One of the staff make changes to the FE to make extra reports and I have asked him to document these. Which is why I first took the table out of the FE. I was concerned that if he made a change, and recorded it in...

Hello everyone, I have been wondering about how I'm going to keep track of revisions for one of my databases. Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the...

Found the missing Link! I never did get around to telling how the problem was solved. It was due to a missing Join between the largest Table (Jobs) and the 2nd largest Table (Customers). I had a combo box on the main form for entering in new jobs. This would reference the customers table to...

Avoiding Errors with Null Date Values I ran into some trouble as some fields had no date data in them. I fixed the problem by adjusting the formula as follows: FiscalYrWeekNo...

THE FORMULA for - Calculating Week Numbers Starting from the Current Financial Year Thanks Rural, I didn't do it that way exactly, but the idea about using the Fiscal Years helped me to complete the formula to do the job. Also, thanks to Rich for posting the following function to calculte...

Hi everyone, I want to calculate the week number of a date in a year starting from the 1 July (of the current year) - as this is the beginning of the Financial Year in Australia. The starting day of the week is Wednesday. I've been trying to think how I could use the Access DatePart...

Access 2003 only shows .BMP files because of missing OLE Server in Office 2003 Hi People, I think I've found the simple explanation to this problem, which has been plaguing me also. Microsoft explains how Access 2003 requires an OLE Server to show pictures other than .BMP files in an Access...

Support Microsoft Solution - Need OLE Server to Display Images in Forms / Reports I found this explanation from Microsoft helpful. See the link here: http://support.microsoft.com/kb/832508/en-us