rename and add prefix two different things?

[smile]

Hi, I was wondering when you have built access database with tables and queries that are cascading, but do not have any forms.

Is renaming them and adding a prefix two different things. Furthermore I heard that access 2007 is better at this. Does this apply if I work with *.mdb file but still use access 2007?

Because it seems that if you add prefix like qry_ or tbl_ this never breaks them, but if you try to rename them to completely different names it does.

I have a db that everything except queries had a prefix, now as I need to make even more queries I fear that I might run out of names and it's hard to identify if for example report pulls data from what from first glance.

You could say if it has no prefix it's a query yes I use this approach now.

I would like to hear your thought about this with any tools to check db integrity after renaming. I mean Access 2007 has very sophisticated auto tracking and renaming facility but does it handle formulas too? I would hate to discover that some don't work, or perhaps if I do not get any pop-ups when run queries or reports I should assume it's ok?

 

[smile]

You said that your database doesn't use forms. I certainly hope that you are the only user since NOTHING you give to a user should allow access to tables or queries. Everything should be managed by forms.

I wanted to say it does not have forms because I have not created them yet. Thanks for your reply