Recent content by michaelak117

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