Search results

I am currently attempting to replicate my database for mobile use, but continue to get the error that either "the database has exceeded the 2gb capabity or there is not enough room on the disk", which neither are the case. I am simply trying to convert it to the design master and cannot get past...

I am currently attempting to replicate my database for mobile use, but continue to get the error that either "the database has exceeded the 2gb capabity or there is not enough room on the disk", which neither are the case. I am simply trying to convert it to the design master and cannot get...

I recently split my database to take advantage of multi user capabilities and also set passwords for my database. I created a pw for my BE and FE databases. Everything within the FE DB has been working fine except for one feature. On the daily I run a process that involves importing data and...

I have converted my 2007 DB to 2003 to take advantage of the security features and have applied some. Once I have gone to replicate the database in order to make it available for more users and have sycronization capabilities I have run into a problem. Once I create a Design Master Copy and...

I have heard it is possible to choose certain objects in a database for security. I am interested in protecting my tables so that they cannot be edited, deleted, or changed in any way. I have heard you can use the Access Security Wizard but for some reason it does not show in my ribbon...

Currently I run a daily process that involves appending data to a table and querying for data lines i need. I then use tables to lookup and add other important fields. My issue lies with the lookups I am using these other tables for. In financial trading at the end of every month that month...

Currently I am bringing in text and number data on a daily basis by importing and appending to an existing table. At this point query for the information I need which consists of some criteria(todays date being the most important). I do this process twice on two existing tables. Then the...

I know its possible to have Access run a query, but is there any way to have it create and run the query for you? I have the same number of fields and data types coming in daily and I'd like to automate it to that point to make it easier? The process is simple and involved dragging moving the...

Currently in order to change my field from a positive number to a negative number I have to change the name of the field and multiply the old name by -1. There has to be a quicker, easier, more efficient way to do this, Anyone? Thanks Mike

I import about 9000 lines of data into Access and that consists of many lines of initials. One persons initial could include hundreds of rows and then the initial changes to another person. I would like to lookup to another table that has the persons full name. Such as many rows of AFu...

Does anyone know if its possible to use a left function to change the entire field in a query. I have a dates that come in as Mar-09/fwd and I would like only to capture the "Mar-09" portion. I just dont know where I would put the function to make it work and also how to specify the field or...

I have an issue with my numbers in a crosstab query. I have my numbers formatted as currency with 0 decimal places but when the crosstab is created the formatting is lost. When I use the property sheet to change it back it is ineffective. I have written different expressions Such as a CCur...