Search results for query: *

Your right Vic, the SQL statement should have read "DELETE [Table1].* FROM [Table1];". That was my typo when starting this thread. What I was really trying to say was that according to Mellors, all the records are being deleted but the status is being reported incorrectly by Access...

Hi, I have an Access 2000 database that I have split into Client/Server or Front-Ent/Back-End design. The front-end runs on a Win 2000 work station and is linked to the back-end which resides on a NT file Server. My problem is I have a delete query based on a table that has say 400 odd...

Place a Crystal reports control on a form. Set it's ReportFileName property to the file name of your crystal report. Place a button on the form. In the onclick event for the button type this code: 'cmdOpenReport is the name of your button Private Sub cmdOpenReport_Click() 'Action Code 0 will...

Thanks to everyone who responded , After reading all your replies, it seems that there a number of things that I have to consider before I or the organisation that I work for can make a decision. By the way, I used MS Office 2000 professional version to develop the database. I have no problems...

Thanks Transcend, I also failed to mention in my first thread that I may not be able to distribute a runtime version of Access 2000 due to financial constraints. If, I then develop my application using ADP or something similar how do I account for users who may have different versions of...

Hi, I currently have a typical MS Access (2000) database. I have split the database into two parts, Client (front-end) and Server(Backend). I need to distribute my application to users that may have different run-time versions of MS Office or Access. Also they may have different versions of MS...

Thanks for the tip. I'd rather not hard code the path, but if I have no choice then I guess I'll have too. Problem is, I have multi-users using the database and several of them have mapped varying drive letters to the folder. Anthony

I hope someone can help with this problem. I have a split database, the back-end resides on a network server and the front end on my pc (win 2000). I have linked the tables from the back-end to the front-end using the recommended UNC path. However, I cannot open any of the tables in datasheet...