Search results

Thanks

That is correct

Im considering just archiving off the database since its getting close to 1GB anyways and just starting fresh and establishing the replication feature from the start with a small table, and going from there. I'm realizing this is a funky problem and probably just has to do with the massive size...

Good points, but I have no OLE objects or memo fields, it is either text, date, or number. And yes, I do have over a million records in this table.

For now, atleast for this particular database I have just been working on it mobile, and saving over the other backend on the server. Meaning I replace the entire backend by saving over it with my mobile backend. Not the most efficient way obviously, but my only option right now since I...

Yes, it didn't seem to matter. I even tried manually bulding a repica. I created a replica with very little data and then manually ran append queries to build the database back up to its 500mb level. So I successfully reached the point of having a design master and replica, but then when trying...

Wanted to make sure it was in the correct category to get answered. Thanks

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

That pretty much does it. Thanks alot for laying that out for me, greatly appreciated. Easier than I had originally thought.

Users are linked to the design master aka the BE and your mobile employee keeps a replica on his laptop? I think what your describing would be sufficient for my needs. I am unclear and unlearned on linking the FE with BE though. Could you explain this further. How do I link users to the BE...

I am a little confused about splitting the db. When you split dont you have a back end with only tables? Then you recommend distributing the front end to the workstations. If im understanding correctly, are you recommending an alternative because splitting the database would leave no point in...

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

Well I know you an apply user level security and decide who can manipulate what inside your database, but this is only existent in 2003 and earlier. I am using 2007. I guess my best bet is to rely on the security I have now--automatic imports, using forms to reduce human error and keeping...

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

Could they just click both Auto and Transmission instead of any and you can include both in the criteria.

Thanks for the response. Where are you saying I should enter this SELECT... FROM... WHERE DateField = Date() ? Mike

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