Search:

All SQL Server and MS Access databases are going to be replaced by an all singing all dancing Company management system - Well they think this will happen anyway.

Each user will have their own database copy pointing to the same database on one of 3 servers depending on the users location. Currently it is set up at one site with one user. In an ideal world I...

Here's the thing I want to be able to do.

On start up I want to point everything to either the test or live SQL Server. The pass though queries over 80 of them run stored procedures, executing...

I have been unfortunate to have taken on a job of updating a MS Access 97 database with a SQL Server backend. All the connections have been hardcoded. I have modified this in all forms and procedures...

I've used bog standard telnet and hummingbird, Putty is a far easier and flexible tool than either of these.

There may be something in this , I do have a primary key which includes a timestamp. I think I may create a view breaking out the timestamp to see if this helps.

Thanks
Caz

I have linked a number of tables from a UDB database to MS Access 97, all bar one table can be seen and manipulated as expected. However one table in table view shows that all the records as...

Just the thing

Thanks

We want to be able to do this automatically in code running from a button on a form.

Does anyone know how to export a table to a text file and then append a line at the top of the text file?

Doing the export to a text file is no problem its just how to manipulate the text file to...

This suggestion is just a variation on a theme, but it seems to me you want a easily manageable site that both you and others can update. I have had great results using csCreate Professional from...

I would be worried about the term 'Many' users. MS Access is not very robust when many users try to access the data simultaneously.

You may wish to look into run time versions.

After an almost infinite amount of research I'd have to say the YABB (yet another bulletin board) is the best free forum out there. Excellent free support via an very active forum, when I had a minor...

I found this somewhere, it checks for a table and whether it is stored or linked:-

Sub Checklink()

Dim Db As Database
Dim Rst As Recordset
Dim Newrst As Recordset
Dim MySQL As String
Dim...

For info we've found loads of problems with memory leaking with SP6 we always instal SP6a, it saves us loads of rebooting.

I am creating a run time version that can be zipped up and FTPed to India where it will be unzipped and distributed on PC's that don't have MS Access installed. We've outsourced our Accounts dept to...

I have a database on a network that I need to create a runtime version from. I have found that the runtime version wizard conflicts with our anti virus software, when run over our network. The only...

One way to do this is to use global variables and set the values of these on the first form, then on the open event of your new form set the values of the appropriate fields to be the global variable...

I left my brain at home today. I basically need to copy the current Database I am working with to 2 different locations on a network. I could just export the files that I have changed but have found...

When you upload html pages you should upload them as ASCII, but when you upload images you need to upload them as binary, did you do this?

I don't use Cute FTP I use WS_FTP, but have a look and...

I recently got caught as I had not been keeping my virus checker up to date. It was only a month or two out of date.

I use Norton Antivirus, however when I updated the virus definitions, Norton...

Never done this myself but find someone with a copy of Access 97 Developers Handbook or a later version if there is one (by Paul Litwin,Ken Getz and Mike Gilbert) or buy a copy its a very useful...

I create a startup form and add an on open event, this is an example from Access 97, but may work for you.

Private Sub Form_Open(Cancel As Integer)
DoCmd.SetWarnings False
Dim TheUser

...

Take the data out of access trimmed, use the label wizard in Access and it will created the trimmed addesses for you or why don't you just print labels out from your Access database, far less hassle.

This query should list all your reports.

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;