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...

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...

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...

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...

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...

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...

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...

Hi all, Here's the situation: I have a bunch of Excel sheets and textfiles I need to link to. I created an Access DB which links to these files. This DB is my backend DB and it only contains linked tables. I then create a frontend DB in which I link to all tables in the backend DB. I do this by...

Hi there, I have written a bunch of general VBA functions and put them in an Access database called DAPlibrary.mdb. Several other Access databases now have a reference to DAPlibrary so they can use all functions in this database too. These databases are used by several users so they can be...

Hi there, I have a bunch of linked tables in my Access database. The sources can be Excel worksheets, normal textfiles or other Access tables. Problem: I can't delete some of these linked tables anymore. Pressing delete+yes doesn't help. Deleting them in VBA doesn't work either. I have no idea...

Hi there, My app contains various forms. Every time I open a form, it's also shown in the taskbar. After a while, I can have up to 5 or more forms listed in my taskbar. How can I prevend this from happening? Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine

Hi there, Inside an Access macro, I start Excel with this line: d:\blabla\excel.exe "e:\blabla\myworkbook.xls" The workbook contains various worksheets. I want to be able to show one of these sheets when the workbook is opened. I thought about writing macros in the Excel workbook...

Hi there, Inside an Access macro, I start Excel with this line: d:\blabla\excel.exe "e:\blabla\myworkbook.xls" The workbook contains various worksheets. I want to be able to show one of these sheets when the workbook is opened. I thought about writing macros in the Excel workbook...

Hi there, I know this is dangerous, but I want to update some fields in the MSysQueries table. However, of course, Access says I don't have access to this table. How can I access this table anyway, if possible? Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine

Hi there, I have a bunch of linked tables which are being used in a lot of queries. I now need to rename lots of these tables. I thought Access would update all queries that use a specific table when I rename that table (so that the queries use the new tablename). But this doesn't seem to be...

Hi there, I have a macro containing a few conditions. I want to call one of my own VBA functions in one of these conditions but I don't know if this is possible. I can run standard VBA functions (like DCount, Msgbox etc) in conditions but I want to run my own. Is this possible, and how? Bye...

Hi all, I want to design my Access 2000 application by using the 3-tier architecture. I have a few ideas on how to do this but I'm looking for any advice on the subject. The final product will contain hundreds of queries and lots of (linked) tables. Putting all of these queries in one database...

Hi there, We are developing an Access 2000 application with 2 developers (me being one of them). The problem is that we can't work in the same .MDB file at the same time. If we do that, only one of us is allowed to save changes. Of course, this doesn't work very well for us. We would like to...

Hi there, I need to find out (in code) if a field with a given name exists in a table. How can I do this? Bye, Jeroen Bye, Jeroen A 3d level editor in Delphi http://www.gamefortress.com/~delgine