Search results for query: *

Hi, I'm trying to access the MSysQueries table of _another_ Access database from within my current database. This gives me a "no permission on MSysQueries" error. I've tried various things, amongst which is to create a workspace and a database object and running a query from that database...

Been searching for a topic like this one for i have a simular problem. I have an Oracle backend with tables and relationships defined between them but when I try to link them in my MS-Access frontend, the tables are there without their relationships. What am I doing wrong? Bye, Jeroen A 3D...

Hi there, We're using an Access 2003 frontend and have ODBC links to tables in an Oracle database. The relationships between the tabels are correctly setup in the Oracle database but they don't show up in the Relationship Window in Access. They also don't show up when creating new queries with...

Thanks. Figured as much, just wanted to make sure. :) Bye, Jeroen A 3D editor project http://www.delgine.com

Hi there, Suppose I have 1 database that contains 1 VBA module with a public variable like this: public myCode as string Now 2 users open the database at the same time and change the value of the myCode variable. Will there be 2 seperate Access instances and will the users be able to work...

Error handling code won't help in every situation. For example, suppose I have made a few queries based on some table. Now the layout of that table (field definitions) change and I am not notified of this. I thus assume that my query is OK but it will in fact hang up on me because it expects...

Hi there, Every morning I automatically run a few macros (which run queries) in an Access 2003 database. I do this using the Task Scheduler from Windows. The task is run by a system useraccount (I can't use that account, I have to go to the system administrators to get things changed if...

Hey, thanks very much for that comment, it's good to know where to look in the registry. Now I only hope I am allowed to change this setting. You see, all users work on a server. They login on that server with their own account and the work with the application on that server. I guess I have to...

I have a related problem. I set the Macro Security to low and this works perfectly for all users except one! He has to set it to low each day again. Does anybody know how to solve that one? Bye, Jeroen A 3D editor project http://www.delgine.com

Thanks for your suggestion, i'll give it a try! However, I already made a simple loop like this: for i = 1 to 12000 doevents next i and it didn't work. Maybe your suggestion does work so i will give it a try right now. :) Other suggestions are also greatly appriciated. Bye, Jeroen A 3d...

Hi there, I'm running a macro in a database from within another database. I create an instance of an Access application and then call the DoCmd.RunMacro action like this: Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase strDatabase appAccess.DoCmd.RunMacro...

Hi there, We have a very large Access 2003 database both in terms of filesize and number of records. One table has over 11 million records and we are wondering when/if it's going to be too much. I read somewhere that 1 Access table can be up to 1 gigabyte in size. Is this correct? If so, I...

Thanks for the info Danvlas. I'm afraid things are a little more complex though. I'm not interating through recordsets or collections. From inside one Access database i'm simply running a macro (containing a variable number of actions) inside another Access database (by creating another Access...

Simply use TransferTextfile. Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine

Hi there, I have two Access database. One containing the userinterface (UI) and one containing queries (called a functionality database). The reason I set things up like this is because it's nicely modular; I have several functionality databases each doing a seperate task and one UI database. I...

Yes, i'm using this routine in an Access 2000 application myself. Just create a new public function (!) in VBA and call that function from a macro using Runcode (for example). The only problem you might have is not being able to access your users desktop computer from the network. But that's not...

If the users desktop computer is also on the network, you can simply use something like this: dim fso as FileSystemObject set fso = new FileSystemObject fso.CopyFile source, dest set fso = nothing "Source" is (of course) your orignal database located somewhere on the network...

Never mind, I fixed the problem by exporting to a textfile. Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine

Hi, I'm trying to export a table containing 13500 records to an Excelsheet using the OutputTo action. This gives me the following error: Error: 2306 - Description: There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access. The weird thing...

Deleting these tables using a macro and the DeleteObject action doesn't work either. I have absolutely no idea why this is happening. Does anybody have an explanation? Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine