Recent content by nwgrl

I cannot open the version on the server. I can open a version on my desktop but cannot access any of the linked tables. We thought it might be related to corrupt data so we restored the SQL side to a pre problem date but we still can't open the server database or the linked table data.

There's nothing there. That's why I'm stumped as to why I cannot access the database.

Thanks. Where do I find the .ldb file?

I attempted to add new queries, reports, and a form to a shared database. It bombed out and I found that a user was changing data in the tables at the same time. Now I cannot access the database at all (front or backend) and receive the error message: “The Microsoft Jet database engine...

Skills??? Excperience?? I have minimal of both when it comes to Access. I've only just started working with it in any in depth fashion. Are there some examples somewhere I can take a look at?? I've learned what little I know by looking at Help, others' work, or examples. Any guidance is greatly...

It's pretty basic. It pulls data from four tables. The only criteria that I am using in the query is for an End Date field to pull 'Between CDate(Now()-1) And CDate(Now()+13)' and a Status field to pull only 'Approved'. I was grouping by Type but that then I found that running a query for Type...

I have created a query/report that meets all necessary criteria except that it contains multiple TYPEs per employee. This isn’t an issue unless one of the TYPEs is ‘W’. As TYPE ‘W’ supersedes all other TYPEs, any others that meet the other criteria should no longer be reflected in the...