Search results

Yes. In the FE, it contains everything (tables, queries, forms & reports) with arrows pointing left ... which means they are linked. The BE only contails tables, not the queries, forms or reports ... The FE should be used for the users that create reports? Or should I import everything into...

My BE has tables only and my FE has everything.

I am using Access 2000.

Spitting db Ok. I was able to successfully split the db into what appears to be BE only. I made a backup copy of it. Now, what is my FE? I can identify the BE. Help. This is new to me. Thanks;)

Possible Solution Found After reading through some of the posts, I found that by installing Access 97, repairing the database and reopening the file in Access 2000, worked. Now when I tried splitting the db, it worked successfully. Thanks.

Help! I am trying to split a db. In the process, I get an error message that reads, "The Visual Basic for Applications project in the database is currupt". As an attempt to rectify this problem, these are the steps I took: 1. Detect & Repair the Database. No success. 2. Under "Database...

Thanks.

Thanks. I have encountered an error msg that reads, "The Visual Basic for Applications Project in the Database is corrupt". I have tried to compact and repair without success. What do I do??

I still need help ... Ok. I found out more to this issue: It's now 4 people needing access to the database. 2 are keying in data only into the "dislocated workers" database. The other 2 are running reports. Some of the reports are standard reports that have already been created. Otherwise...

After reading your response, I may be pulling straws, but what would happen if I were to use an ODBC connection? I understand that the one user will need to create and run reports possibly on a daily basis, while the other 2 users work in the database, possibly keying information. Here's a...

Hi. I need some assistance in solving an issue whereby I have a total of 3 people sharing 1 database simontaneously. The problem occurs when 1 user begins to create reports via the wizard tool and/or runs reports. While doing this, the other 2 users are unable to use the database. The...

I FOUND THE ANSWER! Once you disabled your editing menus, navigational tools, etc., and you need to edit any part of the database, here's what you need to do: Close the file. Locate the file, press the SHIFT key and click onto the file name. There you go!

How do you enable editing menus once you have disabled them. In the startup options, I disabled all navigational tools, menus, etc., so the user would not use them. I need to make changes and I know how to press F11 to enable the database window to access tables, queries, forms, reports, etc...

Thanks. Thank you. I will modify the statement. -StacyStacy

I still need help --> Update Query I got it! I had to create another table and link it to the query. I am working from an ODBC dbf and the table is uneditable for safety purposes. Thanks! ;)

Convert fields that contain a "1" into "YES". In this database, "1" means "YES". Thanks, StacyStacy

I Got It!! Here's how to write it! #7/1/2000# And "«Expr»"<#6/30/2001#

How do I write a statement in my query to pull records from a certain timeframe. Ex: between 7/1/2000 and 6/30/2001 Thanks.:confused:

GOAL: I want to create a form in Access whereby a User can click onto a button and obtain a report in an Excel spreadsheet from a switchboard menu. That's the easy part. HERE'S WHAT I'VE DONE: I have imported 2 .dbf files via an ODBC. I have created a query and as a result, created a report...