Replies

He was getting this “rumour” from a Microsoft rep, so what’s going on
– have to keep my eyes peeled for anything on their site
– it’d be interesting to see what SQL Reporting Services can do

He was getting this “rumour” from a Microsoft rep, so what’s going on
– have to keep my eyes peeled for anything on their site
– it’d be interesting to see what SQL Reporting Services can do

Thanks for the pointer Charlotte, as you say, even Microsoft suggest it
– we’ve got licences for people, so I can’t see why he’s worried

Thanks for the pointer Charlotte, as you say, even Microsoft suggest it
– we’ve got licences for people, so I can’t see why he’s worried

I’ve got lots of Oracle 8i and 9i database connecting from my Access XP databases

There are a whole heap of possible causes for the failure
– have you got the Oracle client installed on you PC ?
– does your Oracle TNSNAME.ORA have an entry for the database you’re trying to connect to ?
– what version of the Oracle ODBC driver are you using (check in the DSN for the Drivers tab)
– at the command prompt , can you TNSPing the Oracle database ?

Cheers,
Steve C.

I’ve got lots of Oracle 8i and 9i database connecting from my Access XP databases

There are a whole heap of possible causes for the failure
– have you got the Oracle client installed on you PC ?
– does your Oracle TNSNAME.ORA have an entry for the database you’re trying to connect to ?
– what version of the Oracle ODBC driver are you using (check in the DSN for the Drivers tab)
– at the command prompt , can you TNSPing the Oracle database ?

Cheers,
Steve C.

Glad to hear things are moving forward Sarah
– wish I could say the same on this side of the Atlantic
I don’t think the FSO has a RenameFile method, so to rename files I use the MoveFile method on the file in question

Scripting Runtime Library
MoveFile Method
Moves one or more files from one location to another.

object.MoveFile ( source, destination );
Arguments
object
Required. Always the name of a FileSystemObject.
source
Required. The path to the file or files to be moved. The source argument string can contain wildcard characters in the last path component only.
destination
Required. The path where the file or files are to be moved. The destination argument can’t contain wildcard characters.
Remarks
If source contains wildcards or destination ends with a path separator (), it is assumed that destination specifies an existing folder in which to move the matching files. Otherwise, destination is assumed to be the name of a destination file to create. In either case, three things can happen when an individual file is moved:

If destination does not exist, the file gets moved. This is the usual case.
If destination is an existing file, an error occurs.
If destination is a directory, an error occurs.
An error also occurs if a wildcard character that is used in source doesn’t match any files. The MoveFile method stops on the first error it encounters. No attempt is made to roll back any changes made before the error occurs.

Note This method allows moving files between volumes only if supported by the operating system.
The following example illustrates the use of the MoveFile method:

[VBScript]
Sub MoveAFile(Drivespec)
Dim fso
Set fso = CreateObject(“Scripting.FileSystemObject”)
fso.MoveFile Drivespec, “c:windowsdesktop”
End Sub
See Also
CopyFile Method | DeleteFile Method | GetFile Method | GetFileName Method | Move Method | MoveFolder Method | OpenTextFile Method
Applies To: FileSystemObject Object

——————————————————————————–

There are example databases with various user interface tips and tricks on Microsoft’s site at
http://www.microsoft.com/AccessDev/Articles/solover.htm%5B/url%5D

I can’t give you a definite answer, just some experience I had that may relate
– we had a multi-user database (1-4 users) on our Novell server, and the performance was an absolute dog
– the developer couldn’t see the problem on his machine, but that’s because both front and back-end database were local
– solution was IT had to really push up the number of locks available, didn’t seem to hurt the server, and made the database a lot better to use

Could you take the original forms Filter setting and in whichever event you’re using, set the Filter property of the new form

Charlotte,
you are a STAR
I reset to my default of 2002 format and lo, the database rebuild fine
Many many thanks

If you’re going to be doing Access database and VBA work, I’d very strongly recommend the Access Developers Handbook (97,2000,2002) by Getz. Litwin, Gunderloy
– it really is the bible for Access
– well in my opinion anyway

Sarah,
the FileSystemObject is a Microsoft object in the scripting DLL, scrrun.dll
It’s a general purpose object for dealing with, wait for it …., file system objects, so we’re talking about directories, oops sorry old name, folders and files. You can instantiate it using most languages, so VB, VBA or VB script can call create a FileSystemObject and then use the objects methods, e.g. as you’ve found there is a method to CopyFile. I use it a lot for bits and bobs with VB scripts

Lots on MSDN about it e.g. http://msdn.microsoft.com/library/default….ObjectModel.asp[/url]

The only way I found to automate the creation of MDE’s was using an external automation tool, in my case AutoIt, to “drive” Access for me.
I added a registry entry to the MDB shell, which calls a VB script, which amongst other things creates the MDE (and makes an Access 2000 + Access 97 version, then zips them up)

Legare,
thanks for the feedback, and confirming my suspicions that a formula can’t change another cell
I’ll drop into VBA and hook into the Change event – gives me a reason to start looking at the Excel objects